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
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies