"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Create 3D Effects In Your Cells

Usually I try to share tips with you that will help you become more productive, however this one may have the opposite effect. But it's a pretty neat trick I thought you might like, and as long as you don't get too carried away with it and waste too much time, a bit of fun won't hurt.

Today, I'd like to show you how to spice up your worksheet by creating cool 3D effects with cell formatting. Try this on a new worksheet.
  1. Microsoft Excel fill color paletteSelect a range of cells (B2:H30) and select a background color (Format, Cells, Pattern or use the 'color bucket' toolbar button). Pick a color (i.e. Light Blue) that also has a lighter and darker color available on the color palette.
  2. Now select a smaller range (C5:G10) within the first range.
  3. Select Format, Cells, and click the Borders tab.
  4. Click the Color dropdown and select the lighter shade (i.e. Pale Blue) of the color you used in Step 1.
  5. Borders dialog box in Microsoft ExcelMake sure the Line Style on the bottom left of the Line Style box is selected (i.e. surrounded by a dotted border). If not, click to select it.
  6. Click on the top border and the left border buttons.
  7. Now, click on the Color dropdown again and select the darker shade (i.e. Dark Blue) of the color you used in Step 1.
  8. Select one of the thicker border styles on the right side of the Line Style section.
  9. Click on the bottom border and the right border.
  10. Now, drum roll please ... Click OK.
3D effects formatting with Microsoft ExcelNow, isn't that cool?

Have fun and experiment with this yourself. There are many variations you can use. Try a light gray background with white and dark gray borders. Put the thick borders on the left and top and the thin borders on the bottom and right to give a sunken effect.

Right-click this link and choose Save As to download my sample worksheet.


P.S. Send me a copy of what YOU come up with.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Want more great Excel tips just like this one?
Subscribe to my FREE
"Spreadsheet Tips From An Excel Addict"
newsletter at the www.TheExcelAddict.com.
Copyright by Francis Hayes (The Excel Addict) All Rights Reserved

If you came to this page from my Excel Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.