Sharon has attended:
Excel Intermediate course
Using Text in Excel
Best way to insert say a page of text between rows in Excel so that the text wraps and fits to be read as someone else views - ie. could cut and paste it in but how can I make it fit?
RE: Using Text in Excel
Dear Sharon
Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.
I believe we looked at this query in the training room. If you remember it is important to double click on the cell before you paste the data from word into Excel.
There are various ways to resolve this problem.
The best thing is that you can select all the cells and then choose Format > Cells... in the Alignment Tab choose Merge and then press OK.
Then you can adjust the height of the row to the desired value.
Then if you wanted to text to appear from the top of the cells then you can choose Format > Cells... in the Alignment Tab choose Vertical Alignment and from the drop down list choose Top.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
