Clearing format and its effect on background color of a range, Excel 2010
Hi all,
In book Excel 2010 Bible by John Walkenbache in page 35 the following writing has been written:
Clearing formats doesn't clear the background colors in a range that has been designated as a table unless you replace the table style background colors manually.
But in practice, When I select a range and insert a table and then clear format (by Home -> Editing -> Clear formats), the clear formats does clear the background color of that range (of the table)!
Why please?
Last edited by Aria; 11-04-2014 at 02:51 AM.
|