Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Adding Drop Shadows.
Written by Allen Wyatt (last updated October 24, 2020)
This tip applies to Excel 97, 2000, 2002, and 2003
One helpful drawing tool you can use to format your drawings is known as the Shadow Style tool. Using this tool you can add a drop shadow behind an object. Adding drop shadows can help add more depth to your graphics, making them look like they are raised off the surface of the Excel worksheet.
To apply a drop shadow to an object, start by selecting the object and then click on the Shadow Style tool. (It is very close to the right end of the Drawing toolbar.) Excel displays a number of different shadow types and positions. You can also modify the shadow, once placed, by choosing the Shadow Settings option.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2307) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Adding Drop Shadows.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. Check out Mastering VBA for Microsoft Office 365 today!
Want to get a graphic to just the right position on a worksheet? Sometimes the easiest way is to use the arrow keys on ...
Discover MoreUsing the copy and paste techniques you already know, you can copy and paste drawing objects. In this way, you can ...
Discover MoreAutoShapes can easily contain text—just click on the shape and start typing away. You may want the text in the ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2026 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here:
Comments