Results 1 to 2 of 2

Thread: Clearing formats doesn't clear the background color

  1. #1

    Clearing formats doesn't clear the background color

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,

    This is quote from the "Microsoft Excel 2010 by Jahn 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?


  2. #2
    I was trying and I have the same result than you. I don't know what is all the context of the text in the book. But why don't you try to contact Jahn Walkenbach? Maybe is true with some specials conditions.
    Microsoft Excel Massive Open Online Course.
    Learn all about Microsoft excel in this Online course, with video tutorials, examples of applications and a complete functions and buttons explanation.
    Be part of our community and enjoy learning Excel.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts