SOLVED

Default/no fill colour is grey

%3CLINGO-SUB%20id%3D%22lingo-sub-359380%22%20slang%3D%22en-US%22%3EDefault%2Fno%20fill%20colour%20is%20grey%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359380%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20issue%20with%20my%20Excel%20that%20I%20haven't%20been%20able%20to%20shift%20-%20wondering%20if%20anyone%20on%20here%20can%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20default%20colour%20for%20a%20sheet%20in%20a%20workbook%2C%20whether%20I'm%20creating%20a%20new%20one%20or%20opening%20an%20existing%20workbook%2C%20is%20a%20kind%20of%20mid-grey%20rather%20than%20the%20usual%20white.%20I%20can%20colour%20a%20cell%20white%2C%20but%20then%20if%20I%20clear%20formatting%20it'll%20revert%20to%20that%20grey.%20Specifically%2C%20the%20colour%20is%20R205%2C%20G207%2C%20B212.%20Snip%20attached%20to%20show%20what%20I%20mean%20-%20all%20I've%20done%20in%20that%20snip%20is%20create%20the%20table%20and%20colour%20a%20strip%20of%20cells%20white%20and%20black%20to%20show%20the%20difference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20520px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84899i4CE322FF0C583331%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20playing%20around%20with%20Themes%20and%20Colors%2C%20and%20even%20uninstalling%20Office%20entirely%20and%20starting%20again%20-%20nothing%20has%20made%20any%20difference.%20I%20can%20colour%20things%20white%2C%20but%20I%20can't%20change%20the%20'no%20colour'%20colour%20to%20white.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20no%20idea%20how%20to%20change%20this!%20Any%20help%20much%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-359380%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-382783%22%20slang%3D%22en-US%22%3ERe%3A%20Default%2Fno%20fill%20colour%20is%20grey%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382783%22%20slang%3D%22en-US%22%3EThat%20seems%20to%20have%20fixed%20it.%20Thank%20you!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359430%22%20slang%3D%22en-US%22%3ERe%3A%20Default%2Fno%20fill%20colour%20is%20grey%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359430%22%20slang%3D%22en-US%22%3E%3CP%3ENormal%20style%20is%20for%20the%20current%20workbook%20only.%20IF%20XLSTART%20folder%20is%20empty%20(how%20to%20find%20depends%20on%20version%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fautomatically-open-a-specific-workbook-or-template-when-you-start-excel-be9cddc1-a148-4cbf-8f3b-779df08957a3%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fautomatically-open-a-specific-workbook-or-template-when-you-start-excel-be9cddc1-a148-4cbf-8f3b-779df08957a3%3C%2FA%3E)%20it's%20better%20to%20re-install%20the%20Office.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESimple%20re-install%20won't%20help%20since%20office%20keeps%20all%20settings%2C%20you%20need%20to%20uninstall%20with%20fix%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Funinstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Funinstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%20or%20fix%20manually%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fmanually-uninstall-office-4e2904ea-25c8-4544-99ee-17696bb3027b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fmanually-uninstall-office-4e2904ea-25c8-4544-99ee-17696bb3027b%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359429%22%20slang%3D%22en-US%22%3ERe%3A%20Default%2Fno%20fill%20colour%20is%20grey%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359429%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Peter%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooks%20like%20the%20Fill%20property%20is%20set%20to%20No%20Shading.%20I%20can%20change%20that%20to%20white%2C%20but%20if%20I%20do%20that%20then%20clearing%20the%20fill%20on%20a%20cell%20returns%20it%20to%20grey%2C%20so%20it's%20not%20ideal.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359421%22%20slang%3D%22en-US%22%3ERe%3A%20Default%2Fno%20fill%20colour%20is%20grey%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359421%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20first%20place%20to%20look%20is%20the%20Normal%20style%20and%20see%20what%20the%20Fill%20property%20is%20set%20to.%26nbsp%3B%20I%20use%20such%20a%20fill%20intentionally%20to%20prevent%20cells%20being%20displayed%20in%20areas%20that%20I%20have%20not%20assigned%20to%20be%20part%20of%20my%20model%20by%20declaring%20ranges%20as%20Input%20(I%20use%20white%20rather%20than%20the%20ginger%20default)%20or%20Calculation%20(also%20white%20fill).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20it%20is%20the%20normal%20style%20then%20the%20jolly%20little%20stripy%20tables%20would%20need%20alternate%20lines%20set%20to%20white%20rather%20than%20no%20fill.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2189891%22%20slang%3D%22en-US%22%3ERe%3A%20Default%2Fno%20fill%20colour%20is%20grey%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2189891%22%20slang%3D%22en-US%22%3E%3CP%3E***UPDATE***%20It%20turns%20out%20I%20had%20manually%20changed%20the%20Window%20section%20of%20the%26nbsp%3BHKEY_CURRENT_USER%5CControl%20Panel%5CColors%20in%20the%20registry%20from%20255%20255%20255%20to%20215%20215%20215.%20Apparently%20Excel%20reads%20this%20item%20in%20the%20registry%20and%20changes%20the%20No%20Fill%20attribute%20color%20accordingly.%20Registry%20editors%20beware!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20this%20issue%20too%20and%20I%20can't%20fix%20it.%20If%20I%20uninstall%20and%20re-install%20Office%20365%20it%20goes%20away%20and%20I%20can%20work%20in%26nbsp%3B%20a%20document%20once%20or%20twice%20with%20the%20%22no%20fill%22%20cells%20showing%20correctly%20but%20then%20after%20I%20close%20and%20re-open%20excel%20it%20comes%20back%20and%20all%20no%20fill%20cells%20are%20now%20grey.%20After%20this%20the%20program%20sometimes%20freezes%20or%20crashes%20when%20I%20use%20the%20pop-up%20menu%20to%20try%20and%20change%20the%20cell%20fill%20color.%20Don't%20know%20what%20to%20do%20anymore.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.

5 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.

best response confirmed by HHDKenyon (New Contributor)
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!

***UPDATE*** It turns out I had manually changed the Window section of the HKEY_CURRENT_USER\Control Panel\Colors in the registry from 255 255 255 to 215 215 215. Apparently Excel reads this item in the registry and changes the No Fill attribute color accordingly. Registry editors beware!

 

I have this issue too and I can't fix it. If I uninstall and re-install Office 365 it goes away and I can work in  a document once or twice with the "no fill" cells showing correctly but then after I close and re-open excel it comes back and all no fill cells are now grey. After this the program sometimes freezes or crashes when I use the pop-up menu to try and change the cell fill color. Don't know what to do anymore.