bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Graphics > Understanding Fill Effects

Understanding Fill Effects

Summary: Adding drawing objects to a worksheet is a common task in Excel. If you apply the techniques in this tip, you can fill those drawing objects in all sorts of different ways. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Excel is not a specialized graphics program, by any stretch of the imagination--it is a spreadsheet program. However, you can insert drawing objects which may be beneficial to the information you are trying to convey in the worksheet. You can apply a few fancy effects to your drawing objects when you fill them with a color. To see the available effects, follow these steps:

  1. Select the drawing object you want to modify.
  2. Click on the down-arrow next to the Fill Color tool on the Drawing toolbar. Excel displays a color menu.
  3. From the color menu, click on Fill Effects. Excel displays the Fill Effects dialog box. (Click here to see a related figure.)

You can use the tools in the dialog box to change how the filling in the drawing object is rendered. The tabs in the dialog box allow the following:

  • Gradient. This tab is used to modify the density of the color used in various parts of the drawing object. You should experiment with these to get the desired effect.
  • Texture. This tab displays many different surface textures you can use to fill your drawing object. There are some great marble, fabric, and wood textures provided with Excel.
  • Pattern. This tab presents many different patterns you can use in conjunction with whatever fill color you have used. Many of the patterns are reminiscent of the patterns you can use in designing your Windows desktop.
  • Picture. This tab allows you to pick a picture that is used to fill your drawing object. Depending on the picture you use, this can create some very interesting special effects.

Tip #2824 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Got the Time? If you work with either times or dates in Excel, you really need ExcelTips: Times and Dates. Everything you need to know about slicing, dicing, and generally working with times and dates.

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)