Adjust row height of entire spreadsheet based on text in one column

**KerryGA** · 03-15-2012, 02:41 PM

Hi,

I am working with lists of items with several columns including one for descriptions. Right now, the row heights can sometimes be too large because it's expanded for the notes column which sometimes has more text than the description column (for example).

Is there a way to setup my spreadsheet so the rows will fit to the text of the description column? The amount of text on each line is different so I can't setup specific row heights.

No one in my office has been able to figure this out...

**DGagnon** · 03-15-2012, 09:39 PM

if you highlight the whole sheet, then double click where you would adjust a row height, all rows will auto adjust to display all data.

**royUK** · 03-16-2012, 03:04 AM

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

Moved to Excel General

**DGagnon** · 03-16-2012, 10:18 PM

Is your isseu resolved? If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.