Vickie has attended:
Word Intermediate course
Excel Advanced course
Word Advanced course
Time Management course
Rows
Hi Andrew,
This is a very simple question, but I just wanted to know if I am typing in a column.........when I press enter it moves to the next box. I actually want it to stay in the same box but just move to the next line?
Can you help me with this please?
Many thanks
Vickie
RE: Rows
Hello Vickie,
Hope you enjoyed your Microsoft Excel course with Best STL.
Thank you for your question regarding how to word wrap text into a cell.
There are two methods you can use for this.
1) Click the cell where you wish to enter text and then click the Wrap Text button which is located on the Home ribbon in the Alignment group. Make sure that you select whatever column width is appropriate for the amount of text to enter. Then begin typing... Excel will automatically wrap the text into the cell and when you have finished typing, press enter.
2) Click the cell where you wish to enter text and arrange the column width and then type a few words to fit the width of the column. Just before you arrive at the right side of the column use ALT+Enter to move your cursor to the next line. Keep doing this line by line until you have finished typing, then press enter. This type of data entry is known as 'manual word wrap'.
Hope this helps!
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
RE: Rows
Hi Rodney,
Thanks for that information I will try it and see how I go.
I do have another question Please. I am working a table which I just created from the list at the top.
I gave it 5 columns and each column has a persons name, but now under each person in the same column I want to make two columns under each persons name, but it just won't allow me. I click on Insert Column even if I highlight only the one column under one name, but it moves a new column to the left or to the right. I want the name at the top to stay , but under each name more colums. I hope it makes sense. I also tried clicking on Shapes where you can draw a line in the middle, but then the text does not stay in the once side, but moves over to the next side so the line in the middle does not seperate the numbers I'm trying to put in.
Thank you
Vickie
RE: Rows
Hello Vickie,
Thanks for your question regarding working with columns and merge cells.
The first thing you must do is determine how many columns you need for each person. Insert the name and then select the cell containing the name together with the cell to the right and then click the Merge & Center button located on the Home ribbon in the Alignment group. If you later need to add one more column for that person simply insert a column to the right and unmerge the name cell, select all the cells which will now contain the name and click Merge & Center again.
Do this for all the cells containing the names. Use the Format Painter button to copy this formatting to the others... it goes quicker.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
RE: Rows
Hi Rodney,
Thank you for that information and I can see that it will work, but when I click on my headings (two columns) to merge it greys out the Merge button so I can't do it?
Thanks
Vickie
RE: Rows
Hello Vickie,
This shouldn't happen, so send me the file containing that sheet only and I will take a look at it for you.
Send it to me at:
rl@stl-training.co.uk
Look forward to being of assistance.
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
