Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-02-2019, 07:47 PM
Karen615 Karen615 is offline Sort and Maintain Row Height Windows 7 64bit Sort and Maintain Row Height Office 2010 64bit
Competent Performer
Sort and Maintain Row Height
 
Join Date: Jun 2011
Location: Chicago
Posts: 112
Karen615 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 12-16-2019, 05:24 PM
Steve_R Steve_R is offline Sort and Maintain Row Height Windows 7 64bit Sort and Maintain Row Height Office 2010
Novice
 
Join Date: Dec 2019
Posts: 6
Steve_R is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort and Maintain Row Height 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
Sort and Maintain Row Height 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
Sort and Maintain Row Height Maintain paragraph spacing? jake62 Word 2 10-20-2010 04:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft