ExcelBanter - How can I show and print text with line breaks within cells?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I show and print text with line breaks within cells? (https://www.excelbanter.com/excel-discussion-misc-queries/247958-how-can-i-show-print-text-line-breaks-within-cells.html)

Julie

How can I show and print text with line breaks within cells?

I have many cells containing several lines of text using line breaks. I
cannot see the text or print it. I can only see it if I select a cell. How
can I print it?

Jacob Skaria

How can I show and print text with line breaks within cells?

Try

--Select the cells Ctl+A
--FormatRowAutofit

If this post helps click Yes
---------------
Jacob Skaria

"Julie" wrote:

I have many cells containing several lines of text using line breaks. I
cannot see the text or print it. I can only see it if I select a cell. How
can I print it?

All times are GMT +1. The time now is 04:05 PM.