#1
|
|||
|
|||
Sort and Maintain Row Height
Using Excel 2013
I have about 5 rows in my spreadsheet that are a row height of 40 pt. The other 95 rows have a row height of 15 pt. When I do a sort in a certain column, of course the order of the rows change and now I have to manually expand the row height of the cells that contain more content/data. Is it possible to be able to sort and keep the same row height based on the contents in a cell? Your help is greatly appreciated. |
#2
|
|||
|
|||
With VBA in Worksheet_Change.
More detail would be needed to write the code. I don't 'hang about' here regularly. Try a new thread in the Excel Programming section. Describe what it is about the content that requires the change of height to 40. The reverse aspect of the question may also help - what it is about the content that requires a height of 15. Only a particular column? Multiple columns? The better the detail about the location, the less you should have to do to fit the code to your needs but, don't go overboard (people tend to glaze over on long-winded explanations). Aim for concise. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find and Replace maintain format | winningson | Word | 3 | 01-19-2013 05:38 AM |
How to maintain original styles after pasting | FredvanLeeuwen | Word | 3 | 07-19-2012 02:13 AM |
Maintain heading on an odd/even page | elevenless | Word | 4 | 07-10-2012 10:17 AM |
Form won't maintain formatting | SBrant | Word | 0 | 02-10-2011 10:29 AM |
Maintain paragraph spacing? | jake62 | Word | 2 | 10-20-2010 04:58 PM |