View Single Post
 
Old 11-03-2014, 11:21 PM
Aria Aria is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Oct 2014
Posts: 1
Aria is on a distinguished road
Default 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.
Reply With Quote