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
Franky

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
Ranger4

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
Franky

windows 7 32-bit
 
 

Thanks for your opinion.
My System SpecsSystem Spec
.

26 Apr 2014   #4
TanyaC

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
Franky

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
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?
Customization
background color for Wallpaper
Hi I did research and read this http://www.sevenforums.com/tutorials/282-window-color-appearance-change.html but I got lost. All I want is to have a plain blue background for my wallpaper..
Customization
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...
Customization
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.
Customization


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:22.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App