TechSpot

Clearing formats doesn't clear the background color

By abbasi
Apr 26, 2014
Post New Reply
  1. 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.
     

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...