Home

Row Height Changes By Itself

%3CLINGO-SUB%20id%3D%22lingo-sub-314873%22%20slang%3D%22en-US%22%3ERow%20Height%20Changes%20By%20Itself%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314873%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Excel%202016%20Workbook%20in%20Excel%20with%20Prayer%20Requests%20on%20Legal%20size%20paper.%20Some%20only%20use%20the%20row%20height%20necessary%20for%20the%20font%20on%20one%20row.%20Others%20are%20longer%20and%20may%20be%202%20or%20even%203%20lines.%20Now%20I%20go%20through%20the%20workbook%20and%20set%20all%20of%20the%20row%20heights%20properly%20for%20the%20number%20of%20lines%20of%20text%20and%20go%20back%20a%20couple%20days%20later%20and%20the%20heights%20have%20changed%20on%20their%20own.%20Very%20frustrating%20to%20say%20the%20least.%20I'm%20going%20to%20try%20to%20attach%20a%20screen%20print%20of%20a%20page%20with%20an%20example%20of%20what%20it%20is%20doing%20and%20would%20greatly%20appreciate%20any%20and%20all%20help.%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EJerry%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-314873%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-315208%22%20slang%3D%22en-US%22%3ERe%3A%20Row%20Height%20Changes%20By%20Itself%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-315208%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20this%20is%20going%20to%20be%20almost%20impossible%20to%20believe%20but%20on%20the%2012th%20of%20January%20I%20made%20a%20brand%20new%20copy%20of%20the%20entire%20workbook%20by%20copying%20the%20worksheets%20one%20at%20a%20time%20and%20putting%20them%20in%20a%20new%20workbook.%20I%20saved%20it%20on%20an%20external%20hard%20drive%20I%20have%20and%20it%20HAS%20NOT%20changed.%20I%20know%20it's%20only%203%20days%20but%20the%20other%20one%20did%20change%20again.%20I%20just%20made%20a%20few%20additions%20to%20it%2C%20the%20one%20on%20the%20hard%20drive%2C%20and%20will%20watch%20it%20and%20report%20back.%20There%20still%20has%20to%20be%20a%20reason%20excel%20is%20changing%20it%20on%20the%20pc%20though.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EJerry%3C%2FP%3E%3CP%3E(Stranger%20things%20have%20happened)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-315181%22%20slang%3D%22en-US%22%3ERe%3A%20Row%20Height%20Changes%20By%20Itself%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-315181%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don%E2%80%99t%20know%20what%20the%20409.5%20is%20but%20I%E2%80%99m%20setting%20my%20row%20heights%20anywhere%20from%2040%20to%20150%20depending%20on%20the%20lines%20of%20text.%3C%2FP%3E%3CP%3EThis%20one%20worksheet%20in%20the%20workbook%20is%20about%20500%20rows%20long%20and%20this%20morning%20I%20have%20corrected%20at%20least%2030%20of%20them%20and%20am%20not%3C%2FP%3E%3CP%3Eeven%20%C2%BD%20way%20through%20it.%20The%20settings%20were%20already%20set%20as%20you%20specified.%20What%20a%20pain%20to%20fix%20them%20every%20time%20I%20want%20to%20print.%3C%2FP%3E%3CP%3EAny%20more%20suggestions%20will%20be%20appreciated.%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EJerry%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314878%22%20slang%3D%22en-US%22%3ERe%3A%20Row%20Height%20Changes%20By%20Itself%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314878%22%20slang%3D%22en-US%22%3EPlease%20try%20the%20following%20to%20resolve%20the%20issue%3A%3CBR%20%2F%3E1.%20Boot%20Excel%202016%3CBR%20%2F%3E2.%20Open%20%5BExcel%20Options%5D%20dialog.%20(%5BFile%5D-%5BOptions%5D)%3CBR%20%2F%3E3.%20Select%20%5BAdvanced%5D%20tab%2C%20turn%20on%20%5BCut%2C%20copy%20and%20sort%20inserted%20objects%20with%20their%20parent%20cells%5D%20option.%20(In%20%5BCut%2C%20copy%20and%20paste%5D%20section)%3CBR%20%2F%3E%3CBR%20%2F%3E*This%20will%20not%20resize%20rows%20that%20are%20currently%20set%20to%20409.5%20but%20I%20would%20like%20to%20know%20if%20this%20keeps%20rows%20from%20doing%20this%20in%20the%20future.%3CBR%20%2F%3ERefer%20the%20below%20thread%20%3A%20%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Fen-US%2F47740b73-9e06-442b-94af-5fbac0956add%2Fexcel-row-height-changes-when-it-should-not-change%3Fforum%3Dexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Fen-US%2F47740b73-9e06-442b-94af-5fbac0956add%2Fexcel-row-height-changes-when-it-should-not-change%3Fforum%3Dexcel%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Jerry Yeagley
Occasional Contributor

I have an Excel 2016 Workbook in Excel with Prayer Requests on Legal size paper. Some only use the row height necessary for the font on one row. Others are longer and may be 2 or even 3 lines. Now I go through the workbook and set all of the row heights properly for the number of lines of text and go back a couple days later and the heights have changed on their own. Very frustrating to say the least. I'm going to try to attach a screen print of a page with an example of what it is doing and would greatly appreciate any and all help.

Thank you

Jerry

3 Replies
Please try the following to resolve the issue:
1. Boot Excel 2016
2. Open [Excel Options] dialog. ([File]-[Options])
3. Select [Advanced] tab, turn on [Cut, copy and sort inserted objects with their parent cells] option. (In [Cut, copy and paste] section)

*This will not resize rows that are currently set to 409.5 but I would like to know if this keeps rows from doing this in the future.
Refer the below thread : https://social.technet.microsoft.com/Forums/en-US/47740b73-9e06-442b-94af-5fbac0956add/excel-row-hei...

I don’t know what the 409.5 is but I’m setting my row heights anywhere from 40 to 150 depending on the lines of text.

This one worksheet in the workbook is about 500 rows long and this morning I have corrected at least 30 of them and am not

even ½ way through it. The settings were already set as you specified. What a pain to fix them every time I want to print.

Any more suggestions will be appreciated.

Thank you

Jerry

I know this is going to be almost impossible to believe but on the 12th of January I made a brand new copy of the entire workbook by copying the worksheets one at a time and putting them in a new workbook. I saved it on an external hard drive I have and it HAS NOT changed. I know it's only 3 days but the other one did change again. I just made a few additions to it, the one on the hard drive, and will watch it and report back. There still has to be a reason excel is changing it on the pc though.

Thanks

Jerry

(Stranger things have happened)

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies