A nice enhancement would be to have the red arrow indicating that the column width is not sufficient to display the entire cell contents be able to be displayed in the column header bar if any cells in that column exceed the column width, rather than just the visable cells. Thanks.
Pinging design team. Should we stick an arrow in the column header, if a cell in the column has content exceeding the width?
Let's make first clear what you are talking about. | A | B | C | 1| 123|Hello World| 2| 1234| ###| 42| In row 1 cell B1 a text exceeds the column width and would be either cut if C1 contains text (indicated by a small red triangle) or wrapped and the row heights adjusted. The other example is cell B2 where a numeric value cannot be shown which is indicated by the number signs (aka hash). Your use case is that somewhere in the spreadsheet out of the current sight data do not fit the column width and you want to see it in the header in order to...? I don't get this point. To print a properly sized sheet? Why don't you just select all columns before printing and double click between the column headers (horizontal split cursor)? I mean you don't want to _see_ that a column is too small but want it to be properly sized, right?
The arrow would identify that the column is not properly sized and would help me realize that I should double click between the headers so that when I scroll down I'll be able to see all of the data.
Sounds like a nice to have but not really needed feature. You can always auto size regardless it's required or not. For sake of simplicity I wouldn't implement this feature. Others may want to see if a cell contains text, a negative value, a reference... there are plenty of properties that might be interesting. If we use the canvas of the column header this will end up in a mess. Others may have a different opinion.
Yes, I think this is a better fit for an extension or maybe a macro with some other approach. Let's close.