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
