text cells

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Text in cells

Text in cells

resolvedResolved · 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


 

Excel tip:

Ctrl+d's double life

Suppose 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.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips


Server loaded in 0.1 secs.