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

Tips.Net > ExcelTips Home > Graphics > Adding a Drop Shadow to a Text Box

Adding a Drop Shadow to a Text Box

Summary: Text boxes on a printed page can appear “flat,” almost without definition. You can make them stand out more by applying shadows to the text box. In this way they almost appear to “pop” off the page. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Text boxes are a graphic element you can use in your workbooks to hold information that is ancillary to the main data in the workbook. For instance, you might use a text box to create a sidebar or other text object. To enhance your layout design using text boxes, you can add a drop shadow so the text box appears to float about the actual printed page.

To add a drop shadow to a text box, follow these steps:

  1. Make sure the Drawing toolbar is displayed. (You can click on the Drawing tool on the standard toolbar to display the Drawing toolbar.)
  2. Select the text box you want to format. Small selection handles should appear around the perimeter of the text box.
  3. Click on the Shadow tool on the Drawing toolbar. Excel displays a palette of available shadows.
  4. Click on the shadow desired.

Users of Excel 2007 will note that there is no longer a Drawing toolbar available. Instead, Excel 2007 users should follow these steps:

  1. Select the text box you want to format. Small selection handles should appear around the perimeter of the text box.
  2. Select the Format tab on the ribbon. (This tab is available only when you select the text box in step 1.)
  3. Click Shape Effects in the Shape Styles group. Excel displays a list of effects you can apply to the text box.
  4. Highlight the Shadow option and you will see a palette of available shadows.
  5. Click on the shadow desired.

Tip #2505 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.
 
Check out ExcelTips: Filters and Filtering today!

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.)