Cells fill color apparently disappears (only on pre-existing files)

niko333c

New Member
Joined
Apr 21, 2016
Messages
39
Hello everybody,

this is new!

You know, sometimes Excel feels a little nostalgia of those moments when he drives you nuts, and decides to reiterate.

What about this time?

Since yesterday he decided to not to show cells fill color anymore, but!

• Only if you open pre-existing Excel files. If you create a new one, he shows you all the colors you want
• As soon as you open whatever pre-existing Excel file, the first fraction of a second it shows the colors of the cells, but then the color immediately disappear and the cells become white
• If you right click properties fill on any cell, it shows the preview of the color of the cell fill correctly in the window, but not in the real cell
• Sometimes, for example if you mouse-scroll, all the cells that are supposed to be colored (but appear white), became all completely black
• If you try to re-set the color of the cell or change color, for a fraction of a second it shows the color of the cell fill (just when you click on the color icon on the toolbar), but then the color of the cell fill immediately disappears and becomes white
• Other cells are fine, for example the header line of the table, which fill is light purple. Blue or yellow cells? Forget it!
• You can do whatever you want, even smash your head on the screen repeatedly :oops: the cells stay white

All other Windows colors are fine, MS Word colors are fine, even new Excel files' cells' filling colors are fine.

Any clue of what spirit just possessed it?

Thank you.
 
Last edited:
Love the google skills... curiosity: do you remember exactly what keywords did you google for such a thing?

Blimey, I've been asleep since I did it... but I think the search I used was "Windows 10 Excel 2010 Page Layout view screwing format".

Glad it worked!
 
Upvote 0

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,215,945
Messages
6,127,861
Members
449,411
Latest member
adunn_23

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