by TheExcelAddict.com
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.
-
Select 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. - Now select a smaller range (C5:G10) within the first range.
- Select Format, Cells, and click the Borders tab.
- Click the Color dropdown and select the lighter shade (i.e. Pale Blue) of the color you used in Step 1.
-
Make 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. - Click on the top border and the left border buttons.
- Now, click on the Color dropdown again and select the darker shade (i.e. Dark Blue) of the color you used in Step 1.
- Select one of the thicker border styles on the right side of the Line Style section.
- Click on the bottom border and the right border.
- Now, drum roll please ... Click OK.
Now, 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.
|
"Spreadsheet Tips From An Excel Addict" newsletter at the www.TheExcelAddict.com. |