Autofit Row Height when sorting

%3CLINGO-SUB%20id%3D%22lingo-sub-2988939%22%20slang%3D%22en-US%22%3EAutofit%20Row%20Height%20when%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2988939%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20a%20worksheet%20contains%20rows%20with%20different%20heights%2C%20I%20would%20expect%20those%20heights%20to%20be%20automatically%20adjusted%20during%20a%20sort%20of%20the%20rows%20in%20that%20sheet.%26nbsp%3B%20Alas%2C%20this%20appears%20to%20not%20be%20the%20case%20(At%20least%20I%20haven't%20been%20able%20to%20make%20that%20happen).%26nbsp%3B%20Can%20I%20make%20that%20happen%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2988939%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2989059%22%20slang%3D%22en-US%22%3ERe%3A%20Autofit%20Row%20Height%20when%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2989059%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1224903%22%20target%3D%22_blank%22%3E%40gunner-b%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20manually%20adjust%20the%20column%20width%20or%20row%20height%20or%20automatically%20resize%20columns%20and%20rows%20to%20fit%20the%20data.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fchange-the-column-width-or-row-height-in-excel-4c0b8edc-4fb6-4af0-9374-7a953f48527b%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EChange%20the%20column%20width%20or%20row%20height%20in%20Excel%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdditional%20Information%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fchange-the-column-width-and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EChange%20the%20column%20width%20and%20row%20height%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2989082%22%20slang%3D%22en-US%22%3ERe%3A%20Autofit%20Row%20Height%20when%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2989082%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20help.%20I%20guess%20I'm%20just%20to%20lazy%20to%20want%20to%20do%20it%20manually.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2989094%22%20slang%3D%22en-US%22%3ERe%3A%20Autofit%20Row%20Height%20when%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2989094%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1224903%22%20target%3D%22_blank%22%3E%40gunner-b%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20automatic%20adjustment%20with%20VBA%20on%20all%20cells%3CBR%20%2F%3ESee%20the%20attached%20file%20with%20examples%20where%20you%20can%20try%20it%20out%20yourself.%3C%2FP%3E%3CP%3EEnjoy%20excel%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

When a worksheet contains rows with different heights, I would expect those heights to be automatically adjusted during a sort of the rows in that sheet.  Alas, this appears to not be the case (At least I haven't been able to make that happen).  Can I make that happen?

5 Replies

@gunner-b 

You can manually adjust the column width or row height or automatically resize columns and rows to fit the data.

Change the column width or row height in Excel

 

Additional Information:

Change the column width and row height

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

 

 

Thanks for your help. I guess I'm just to lazy to want to do it manually.

@gunner-b 

Here automatic adjustment with VBA on all cells
See the attached file with examples where you can try it out yourself.

Enjoy excel

I experimented on an excel worksheet with rows of different heights and inserted a variety of objects (pictures, text boxes, etc,) and, sure enough, when I resorted the rows, autofit did not function. I also tried reformatting the objects . . . no luck! I'm satisfied. Thanks for looking at this with me.

@gunner-b 

I am pleased that you are satisfied, I hope to see you again in the future here in the forum.
Welcome to your Excel discussion space!

 

Also wish you have fun with Excel.