SOLVED
Home

Default/no fill colour is grey

HHDKenyon
New Contributor

Hi all,

 

I have an issue with my Excel that I haven't been able to shift - wondering if anyone on here can help.

 

The default colour for a sheet in a workbook, whether I'm creating a new one or opening an existing workbook, is a kind of mid-grey rather than the usual white. I can colour a cell white, but then if I clear formatting it'll revert to that grey. Specifically, the colour is R205, G207, B212. Snip attached to show what I mean - all I've done in that snip is create the table and colour a strip of cells white and black to show the difference.

 

 

image.png

 

I've tried playing around with Themes and Colors, and even uninstalling Office entirely and starting again - nothing has made any difference. I can colour things white, but I can't change the 'no colour' colour to white.

 

I have no idea how to change this! Any help much appreciated.

4 Replies

The first place to look is the Normal style and see what the Fill property is set to.  I use such a fill intentionally to prevent cells being displayed in areas that I have not assigned to be part of my model by declaring ranges as Input (I use white rather than the ginger default) or Calculation (also white fill).

 

If it is the normal style then the jolly little stripy tables would need alternate lines set to white rather than no fill.

Hi Peter,

 

Looks like the Fill property is set to No Shading. I can change that to white, but if I do that then clearing the fill on a cell returns it to grey, so it's not ideal.

Solution

Normal style is for the current workbook only. IF XLSTART folder is empty (how to find depends on version https://support.office.com/en-us/article/automatically-open-a-specific-workbook-or-template-when-you...) it's better to re-install the Office.

 

Simple re-install won't help since office keeps all settings, you need to uninstall with fix https://support.office.com/en-us/article/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf... or fix manually https://support.office.com/en-us/article/manually-uninstall-office-4e2904ea-25c8-4544-99ee-17696bb30...

That seems to have fixed it. Thank you!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies