Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
When you have created a drawing object, you can fill it with a color of your choosing. This is easy to do by following these steps if you are using Excel 2007:
If you are using an older version of Excel, follow these steps instead:
Once you select a color, Excel removes the color menu and fills the interior of the shape with the color selected. To remove a color you previously used, you can repeat the same steps, but in step 4 or 3 (depending on your version of Excel) choose No Fill.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2823) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.