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
Excel 07 Stopped Printing in Color
Iím not spreadsheet savvy but I can do pretty basic ones in Excel 07. I don't use it often, but when I do, I usually would like a specific cell, or just one word in phrase in a cell to be in color, usually Red. Recently, however, it stopped printing in color. Bolding still works. I...
Microsoft Office
Excel cell formats changed after Windows Update
Hi. After getting my wife's laptop with Win 7 Pro to run it's updates again after a week's worth of struggling with that, she opened an existing LARGE spreadsheet to find that all the green cell contents were now blue, and the cells with $ formatting were now general format again !! Not a happy...
Microsoft Office
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
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

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 19:44.
Twitter Facebook Google+