Selecting an area, mark the info in cells with another colour (default: light grey), just like in previous versions
I know many people do not like the idea of 'supporting columns' integrated in the worksheet for the user. But I'm all for it. Font in same colour as background colour so no one sees it. If I'd like to quickly check what value the formula returns, I'd only need to select an area incl. that cell. The darker grey colour, to mark the selection, is of another shade of colur than the font.
At least until Excel 2010 this was always standard in excel. In the Mac version it still is the case! Please guys, would you consider going back to as it once was?
We aren’t going to be changing the selection color in order to make “hidden text” show up more easily because we don’t think that “hidden text” is a good thing in spreadsheets (generally).
Have you considered adding column to your sheet and simply toggling the hidden/visibility of that column (hide/show) based on whether you want to see the notes?
3 commentsComments are closed
Feyyaz Özen commented
If I select a string in the cell filled with color "# C0C0C0". I can not see the letters which I selected. Because excel emphasizes the letters I choose in the same color.
If the font colour was the same as the cell colour, it was possible to see the content of the cell by selecting an area. This worked at least until Excel 2010.
In Excel 2016 this doesn't work.
I've attached two examples.
Is it possible to change this as it was in previous versions?
Older versions of excel showed white font when the cells were highlighted (as if it was white text on the highlight colour background).
Excel 2016 acts as if the text is see-through, not white - i.e. the highlight colour is grey and white text is not visible against it.
Please bring back ability to see white text in highlighted cells - this allows unhidden cells to be used as part of a formula, but not show when printed - and the user can check the contents without having to change the formatting (or somehow know where the cells are!).