Help with Auto Row Height with wrapped text

M

mlong

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!
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top