Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Excel, Clearing formats doesn't clear the background color

26 Apr 2014   #1

windows 7 32-bit
Excel, Clearing formats doesn't clear the background color

Hi all,

This is quote from the "Microsoft Excel 2010 by John Walkenbach" book:

"Clearing formats doesn't clear the background color in a range that has been designated as a table unless you replace the table style background colors manually".

But, When I create a table and right click -> format cells -> Fill -> background color and then chose a color then OK.
After that I chose all cells of that table (which now has a background color) and the Clear->clear formats.
But the background color also will be cleared. Why? The wrong is with my work or the book's text please?


My System SpecsSystem Spec
26 Apr 2014   #2

Windows 7 Home Premium 64 bit sp1

I cannot see why Clearing cell formats would not clear the Colour formats as well. This would be the logical approach & also why would you want the cell colour remaining if you have cleared the cell format.

I suspect that your 2010 manual may have an error & not your work.
My System SpecsSystem Spec
26 Apr 2014   #3

windows 7 32-bit

Thanks for your opinion.
My System SpecsSystem Spec

26 Apr 2014   #4

Linux Mint 17 Cinnamon | Win 7 Ult x64


Perhaps the reference is to the "Table Style". When clearing formatting on table styles, the style remains and that includes background colors.

Create a table and then click on a cell. From the "Table Styles" ribbon option, you can select a table style. Click the down arrow for a full list of styles.

What you describe doing yourself was to manually modify the properties of the cells; That is; the background color.

When you clear formatting in that case, you clear the manually formatted cell backgrounds.

My System SpecsSystem Spec
26 Apr 2014   #5

windows 7 32-bit

Hi Tanyac,
I also tried that (although the meaning of the author hadn't been this I think) but clear format again removes the style and its color!
My System SpecsSystem Spec

 Excel, Clearing formats doesn't clear the background color

Thread Tools

Similar help and support threads
Thread Forum
Windows 7 Log Screen Font Color/Background Color
Hey all, I have a question regarding the font/background colors on the Windows 7 log screen. I just accepted a position with a school and a few computers have customized log screen font colors/backgrounds. The Windows 7 classic background is there, but the username and password boxes have been...
General Discussion
right click background color
Hi ,i want to change default background color on right klick menu only for items "copy " and "paste" . Default background and when mouse on top(hover). Also text color. Is this possible?
background color for Wallpaper
Hi I did research and read this but I got lost. All I want is to have a plain blue background for my wallpaper..
Background color or what?
Hi. From the attachment you can see my problem. I very often have this, and it is very difficult to see the fields where to put in information. The shown attachment is even better than the reality. How can I get a better showing background ? I have tested with different, but no color...
IE8 Background color
Does anyone know how to make the IE8 background black? Can you do this without having to apply a whole theme?
Browsers & Mail
Help change background color
I've attached a image. Where or how can I change the background color (or gradient preferably) of the stuff pointed to by the 3 red arrows? Thanks for any help.

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 14:42.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App