Sorting without changing row height

[DMiller]

Greetings! This is my first post -- and I'm hopeful that one or more o
you know a quick fix for this problem.

I maintain a list of projects in Excel. Two of the columns ar
"Requesting Manager" and "Project". Dozens of managers access thi
spreadsheet on the network, and to make it easier for them to fin
their projects I sort the worksheet first by manager, then by project.


The problem is that row height varies across the spreadsheet dependin
on how much in the way of notes are included in a "Notes" field. Whe
I do the sorting I have to scroll down and manually adjust the ro
height.

So, the question is: is there a way to sort data in an Excel workshee
and still maintain the varied row height?

Thanks!

Denni

 

[Gord Dibben]

Make sure you have cells formatted for Wrap Text and all rows formatted for
"Autofit".

Should get the results you want.

Gord Dibben Excel MVP