Forum Discussion
Row Height Changes By Itself
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 ...
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-height-changes-when-it-should-not-change?forum=excel
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-height-changes-when-it-should-not-change?forum=excel
.jpg){kind=link}
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