How can I sort and maintain formatting?

L

littlelostgrl

I have a very large excel doc (well over 1,000 rows, by 30 somethin
columns) that require formatting (resizing the row height) each row b
hand. I have done all of that tideous work, but now I need to sort b
multiple columns, and when I do that, the formatting of the cells i
not maintained. (The size of the row stays, rather than moves with th
data) Please tell me there is a remedy and I haven't just wasted m
time formatting for nothing! Thanks for any and all advice
 
P

PokerZan

This is just a quick response, but wouldn't highlighting the entir
sheet then double clicking inbeween rows and columns do the trick here
For instance, when you highlight the entire spreadsheet and doubl
click between the A and B columns, it should autosize the columns t
fit the data in each column. Also, when you do the same between row
and 2, it will autosize the row to fit each individual rows data.

HTH,

PZa
 
L

littlelostgrl

Unfortunatly, because I need to hide some data, and show other data
within a single cell, the formatting cannot be done with autosize.
Thanks for the suggestion though.
 
Top