98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Text in cells
Text in cells
Resolved · Urgent Priority · Version 2003
Katie has attended:
No courses
Text in cells
I have a lot of text in one cell, but the text cuts off when I print out the sheet. I have the cell formatted to text wrap but it seems I have to drag the cell all the way over to the right which I don't want to have to do, Id rather the cell dragged downwards with all of the text displaying without cutting off when printed. I want to keep the sheet to a reasonable size.
Please help
Many thanks
RE: Text in cells
Hi Katie
Thank you for your question.
Once you have wrapped text in a cell, you should be able to resize both the length and the width of the cell to make it the size you want. All the wrap text does is make sure that the text goes onto multiple lines inside the same cell.
I hope this helps.
Amanda
RE: Text in cells
Hi Amanda
Many thanks for your response. However, to be able to actually view the text once printed, I would need to drag the right side of the cell all across the sheet which would make the excel sheet huge. Ideally I need the text to shift down a line as I drag slightly to the right to keep the sheet at a nice size, as opposed to a huge sheet where the text runs in one long line across the page.
Many thanks
RE: Text in cells
Hi Katie
Have you tried making the row that the text is in wider, and making the column narrower so that the text spreads down the cell instead of across it?
Amanda
RE: Text in cells
Hi Amanda
I have tried this, but it still does exactly the same. That is what I was hoping and thinking it would do but it doesnt. I have got around it by cutting each line of text that was in the cell into separate rows and it works fine but I would have thought that you wouldnt need to do this and that there must be another way without having to take it out of the cell and putting them into rows of their own.
Kind regards
RE: Text in cells
Hi Katie
What if you use merge cells and join cells together down the column, instead of putting text into cells in separate rows?
A word of warning, move the text that is in each row following the first cell you have text in before merging cells together, otherwise when you merge you will end up with the text in the top/first cell replacing text in the cells below.
Does this help?
Amanda
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:Ctrl+d's double lifeSuppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae. |