ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help with Auto Row Height with wrapped text (https://www.excelbanter.com/excel-discussion-misc-queries/198001-help-auto-row-height-wrapped-text.html)

mlong

Help with Auto Row Height with wrapped text
 
I have 316 rows of publication information that I need to print for someone.
I would like all of the information to be viewable upon printing, but doing
the Auto Row Height function isn't working. I'm working in 2007, the two
columns that I need auto fit are currently formatted as "General," because
formatting them as Text gives me the #######. I do not have any cells that
are merged. Can someone help!

Thanks!

Dave Peterson

Help with Auto Row Height with wrapped text
 
If the length of the text in the cell is really long, then excel will wrap the
text, but then just seem to fade out after a while.

One way around this is to insert alt-enters (to force a newline within the cell)
every 80-100 characters.



mlong wrote:

I have 316 rows of publication information that I need to print for someone.
I would like all of the information to be viewable upon printing, but doing
the Auto Row Height function isn't working. I'm working in 2007, the two
columns that I need auto fit are currently formatted as "General," because
formatting them as Text gives me the #######. I do not have any cells that
are merged. Can someone help!

Thanks!


--

Dave Peterson


All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com