BartH
New Member
- Joined
- Jul 4, 2006
- Messages
- 14
In the 20+ years we have been using Excel, we used to hide text in cells by making the font color white. Thus, the text would only show when the range including the white font cell(s) is selected, as the text would show on a gray background and it would not show on prints.
To my surprise, in Excel 2016 white text font (on default background) doesn't show at all when the range is selected anymore.
Is this behavior something that can be changed or is there a way around it?
When you select the white font cell and pretend to format it with a different cell style, the preview gives the desired effect, so maybe this could be used?
Grtz Bart
To my surprise, in Excel 2016 white text font (on default background) doesn't show at all when the range is selected anymore.
Is this behavior something that can be changed or is there a way around it?
When you select the white font cell and pretend to format it with a different cell style, the preview gives the desired effect, so maybe this could be used?
Grtz Bart