by Allen Wyatt
(last updated January 17, 2018)
When formatting the data in your worksheet, you may wonder if there is a way to add a drop shadow to a single cell. There is a very simple way to do it; just follow these steps:
That's it. What Excel technically does is to add a text box, the exact same size as the cell you selected in step 1, over the top of the cell. This text box is transparent so that the cell contents show through, but it has borders applied so that you see the drop shadow.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3407) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
When creating custom formats, you can employ a wide range of codes to define your formatting pattern. This tip focuses on ...Discover More
There are any number of reasons to format different cells in different colors. Excel allows you to easily change the ...Discover More
When you create workbooks for others to use, you might want to make sure that they can't change the formatting and paper ...Discover More
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.