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?

Thanks.

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
 
 

Hi,

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.

hth
Tanya
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
Reply

 Excel, Clearing formats doesn't clear the background color




Thread Tools



Similar help and support threads for2: Excel, Clearing formats doesn't clear the background color
Thread Forum
Axcrypt doesn't clear closed file from memory Software
Solved background color for Wallpaper Customization
More than one Color Management/Clear Type Profile (work vs home) Customization
Background color or what? Customization
IE8 Background color 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 12:04 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33