"How To Excel" Mini-Tutorials|
"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.
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.
Why not print (CTRL+P) this tip and share it with your friends and associates?