98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using Text in Excel
Using Text in Excel
Resolved · High Priority · Version 2003
Thu 16 Apr 2009, 11:50Delegate Sharon said...
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?
Fri 17 Apr 2009, 15:38Trainer Rajeev said...
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
Fri 24 Apr 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Sorting List SubtotalsIf you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows. |
