Update AutoFit Row Height Feature To Work At Any Zoom Level
Note: This request assumes there are NO merged cells in the worksheet. It also recognizes the maximum row height of 409.5.
With "Wrap Text" enabled, the "AutoFit Row Height" feature is supposed to automatically increase or decrease the row height to ensure all text in a cell is visible. Unfortunately, the zoom level impacts whether or not the feature is successful. Sometimes, the text in a cell appears as expected: all visible with no extra white space above or below. Other times, “lines” of text are hidden from view. And other times, all of the text is visible, but “lines” of white space appear above or below the text (the location of the white space is dependent on the vertical alignment in the cell). Regardless of the “current” appearance, if you adjust the zoom level, the appearance of the text can change to any of those three states: “properly constrained,” “hidden text,” or “extra white space.” The row height and number of “lines” of text/white space does not change with zoom level.
To illustrate this, open a new workbook. Select cell A1 and enable “Wrap Text” and “AutoFit Row Height.” Type “The quick brown fox” in cell A1. Excel’s default row height is 15. Cell A1 now has a height of 60, essentially creating 4 lines in the cell, each of height 15. However, the text in cell A1 only takes up 3 of these lines at the default zoom level (i.e. extra white space). With default formatting from a new workbook, the first line in the cell is blank, the second contains “The quick”, the third contains “brown”, and the fourth contains “fox”. The default zoom level is 100%. If you zoom out to 85%, the first line of the cell contains “The”, the second contains “quick”, the third contains “brown”, and the fourth contains “fox” (i.e. properly constrained). If you zoom in to 160%, the first two lines are blank, the third contains “The quick”, and the fourth contains “brown fox” (i.e. extra white space).
To illustrate the third case of “hidden text,” open a new workbook. Select cell A1 and enable “Wrap Text” and “AutoFit Row Height.” Type “The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog.” in cell A1. Excel adjusts the row height to 315. With default formatting, the first three lines are blank while the remaining lines contain all of the text. If you zoom out to 85%, the text is properly constrained, filling each line in the cell. If you zoom out to 55%, some of the text is not visible.
If your desire is to ensure your text fits within a cell, having part of your text not fit is inconsistent with the notion that you have enabled “AutoFit Row Height.” Excel should be capable of further automating the selection of row height so that text is always properly constrained within a cell, regardless of zoom level. I can see situations where you would want to keep the row height constant at all zoom levels, so there should be an option to toggle between the current behavior and this new behavior.
Note that all of this also applies to double-clicking on the boundary below the row heading to change the row height to fit the cell contents.
Yes, please fix this. I cannot see the reason why WYSIWIG should bedepending on zoom level.
this is still an issue, agree needs fixing
This is really incompetent from Microsoft Excel Dev team that this bug hasn't been fixed for years!
For profissionals whe spent their majority time in Excel this might be really annoying. This might have impact on our results if we miss something because it was hidden.
I just spend an hour to understand why the AutoFit was not working!
Just find out that it was link with the "zoom level" and than I found your message Matt.
I totally agree with your idea and indeed it is astonishing that Excel can't assure the autofit for all zoom.