Home

icon to autoadjust the rows in an entire spreadsheet by one click

%3CLINGO-SUB%20id%3D%22lingo-sub-311236%22%20slang%3D%22en-US%22%3Eicon%20to%20autoadjust%20the%20rows%20in%20an%20entire%20spreadsheet%20by%20one%20click%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-311236%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20question%20is%20-%20in%20the%20older%20versions%20of%20excel%20there%20was%20an%20icon%20you%20could%20put%20in%20the%20ribbon%2C%20that%20would%20automatically%20adjust%20all%20the%20rows%20in%20the%20spreadsheet%20to%20the%20same%20uniform%20height.%20I%20can't%20seem%20to%20find%20that%20anywhere%20in%202019.%26nbsp%3B%20Can%20you%20tell%20me%20where%20I%20can%20find%20this%20command%20%2F%20what%20it%20is%20called%20and%20if%20it%20still%20exists%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20answer%20to%20my%20query%20was%20your%20post%20and%20I%20couldnt%20find%20it%20in%20your%20attachment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312164%22%20slang%3D%22en-US%22%3ERe%3A%20icon%20to%20autoadjust%20the%20rows%20in%20an%20entire%20spreadsheet%20by%20one%20click%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312164%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F262179%22%20target%3D%22_blank%22%3E%40samneedshelp%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWas%20it%26nbsp%3Bone%20of%20these%202%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20336px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F65620i6D2F0C3FBCE8996D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20913px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F65619iAECF9FF5D0982238%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-311260%22%20slang%3D%22en-US%22%3ERe%3A%20icon%20to%20autoadjust%20the%20rows%20in%20an%20entire%20spreadsheet%20by%20one%20click%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-311260%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20your%20question!%20I've%20moved%20it%20to%20the%20Excel%20space%20so%20hopefully%2C%20the%20experts%20here%20can%20help%20you%20answer%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E(While%20I%20did%20post%20the%20summary%20of%20the%20Reddit%20AMA%2C%20I'm%20not%20able%20to%20answer%20your%20question%20myself.)%3C%2FP%3E%3C%2FLINGO-BODY%3E
samneedshelp
Occasional Visitor

My question is - in the older versions of excel there was an icon you could put in the ribbon, that would automatically adjust all the rows in the spreadsheet to the same uniform height. I can't seem to find that anywhere in 2019.  Can you tell me where I can find this command / what it is called and if it still exists?

 

The only answer to my query was your post and I couldnt find it in your attachment.

 

Thank you

2 Replies

Thanks for your question! I've moved it to the Excel space so hopefully, the experts here can help you answer it.

 

(While I did post the summary of the Reddit AMA, I'm not able to answer your question myself.)

 

Hi @samneedshelp

 

Was it one of these 2?

image.png

 

 

 

 

image.png

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies