Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-03-2014, 11:21 PM
Aria Aria is offline Clearing format and its effect on background color or a range, Excel 2010 Windows 7 32bit Clearing format and its effect on background color or a range, Excel 2010 Office 2010 32bit
Novice
Clearing format and its effect on background color or a range, Excel 2010
 
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
Reply

Tags
background, excel 2010, formats

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where is false color effect in 2011 Mac version of PowerPoint? mbrown662 PowerPoint 0 09-01-2014 03:37 PM
Changing Word Background Color lrmaps.423 Word 10 02-24-2014 05:22 PM
Clearing format and its effect on background color or a range, Excel 2010 Choose color for different number range secoo140 Excel 9 10-07-2013 12:12 PM
Clearing format and its effect on background color or a range, Excel 2010 Outlook Background Color jill5545 Outlook 2 11-15-2010 09:41 AM
Clearing format and its effect on background color or a range, Excel 2010 Background color Bobcoop103 Word 1 12-20-2009 03:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft