Categories
Excel

Create 3D Effects in Tables or Cells

Whenever you see a nifty 3D effect in a program or application such as Excel, you are actually seeing an illusion created by specific formatting. It is easy to create this illusion yourself by applying formatting to a cell or range of cells.

Raised Effect

To start off with a simple example, we’ll give a cell a 3D effect so that it appears raised, like a button. On a clean worksheet follow these steps to create the effect:

  1. Select cell D5 (because it’s not on an edge).
  2. Select Home » Format » Format Cells.
  3. Go to the Border tab and from the Line box, choose the second thickest line style.
  4. Ensure that the color selected is Black (or Automatic, if you haven’t changed the default for this option).
  5. Now click the righthand border and then click the bottom border.
  6. Select white from the color drop-down.
  7. The second thickest border still should be selected, so this time click the two remaining borders of the cell, the top border and the left border.
  8. Click the Fill tab on the Format Cells dialog and make the cell shading Gray.
  9. Click OK and deselect cell D5.

Cell D5 will have a raised effect that gives the appearance of a button. You did it all with borders and shading.

Pushed or indented Effect

If, for fun or diversity, you want to make a cell look indented or pushed in, follow these steps:

  1. Select cell E5 (because it’s next to D5 and it makes the next exercise work).
  2. Select Home » Format » Format Cells.
  3. Go to the Border tab and from the Line box, choose the second thickest line style. Ensure that the color selected is Black (or Automatic, if you haven’t changed the default for this option).
  4. Apply the formatting to the top and left border of the cell.
  5. Select white from the color drop-down.
  6. The second thickest border still should be selected, so this time click the two remaining borders of the cell, the bottom border and the right border.
  7. Click the Fill tab on the Format Cells dialog and make the cell shading Gray.
  8. Click OK and deselect cell E5.

Cell E5 should appear indented. This works even better in contrast with cell D5, which has the raised effect.

Using a 3D Effect on a Table of Data

Next, we’ll experiment with this tool to see the sorts of effects you can apply to your tables or spreadsheets to give them some 3D excitement.

  1. Select cells D5 and E5
  2. click the Format Painter tool (the paintbrush icon) on the Home tab.
  3. While holding down the left mouse button, click on cell F5, drag across to cell J5 and release.
  4. Now select cells D5:J5 and again click the Format Painter tool on the Home tab.
  5. While holding down the left mouse button, select cell D6 and drag it across and down to cell J15, then release.
  6. This should produce the effect shown in the figure.

We have used a fairly thick border to ensure that the effect is seen clearly; however, you might want to make this a little subtler by using a thinner line style. You also could use one of the other line styles to produce an even greater effect. The easiest way to find good combinations is to use trial and error on a blank worksheet to create the effect you want. You are limited only by your imagination and, perhaps, your taste.

Understanding Workbooks and Worksheets: