Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting changes row height
It's just another column.
Put some kind of indicator in that column (Yes/No, True/False, anything that would indicate what you want to do later.) Then sort your data (but include that column with the indicator in the range sorted). Now all your rowheights are mixed up. Select all the cells and autofit the rowheights. Filter by that helper column so that you only see Yes, True (or whatever). Select those visible rows and adjust the rowheight (double it???). Then data|filter|showall (or remove the filter.) (Hide or delete the helper column if you don't need it anymore.) Michelle wrote: Hi Dave, Thanks for your post. I am having the same problem. Did not have this problem with previous version of Excel! Anyway...can you explain more about the helper row? I've used Excel for years but never heard of that. "Dave Peterson" wrote: The rowheight stays with the row. If I had to do this, I'd add a helper cell per row -- some kind of indicator. then sort my data, autofit all the rows and look for that indicator and adjust the rowheight of those rows. tsysjohn wrote: I have set the row heights for the rows in my spreadsheet exactly as I want them - different rows have different heights. When I sort the spreadsheet, which I do every day or so, Excel changes some of the row heights. How can I prevent this? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
Change height of row | Excel Discussion (Misc queries) | |||
How do I change row height to 16.0? I get choice of 15.6 (26 Pix. | Excel Discussion (Misc queries) | |||
sorting question | Excel Discussion (Misc queries) |