What happened to white text in selected ranges in Excel 2016?

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
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Forum statistics

Threads
1,214,631
Messages
6,120,640
Members
448,974
Latest member
DumbFinanceBro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top