autofit row text (wrapped) without changing column width?

G

Guest

Working in spreadsheets with established columns. However, as data is added
and subtracted, text repeatedly becomes hidden when rows shift. Can I cause
the cells to "auto fit" text to the row without changing column width?
 
G

Guest

Allllen, this only works if I don't need to READ what is in the cell. Really
need a solution that will expand the row width without altering the column
width or text size.

Kim
 
G

Gord Dibben

Select your rows.

Format>Row>Autofit.

Also make sure the rows are set for Wrap Text.


Gord Dibben MS Excel MVP
 
G

Guest

Kim - did you ever get the answer to this problem, because I'm having the
same one. Jessi.
 
G

Gord Dibben

Select rows and Format>Row>Autofit doesn't work?

Also make sure the cells are formatted to wrap text.


Gord Dibben MS Excel MVP
 

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

Similar Threads

2007 Excel: text in cell becomes hidden when formatted to wrap tex 0
Need help on formatting row height 1
How do I autofit row height to adjust to new text on Excel form? 1
Cells with wrapped text won't auto-adjust row height correctly 2
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Setting column width to specific row in Excel doc ??? Thanks! 2
Printing wrapped text 4
Row Height-Auto Adjust to Content? 5

Top