Software

Make Excel spreadsheets easier to read with 3-D effects

Microsoft Excel spreadsheets are a fantastic way to organize data; however, sometimes your spreadsheets may get a bit cluttered and become hard to read. Find out how you can use 3-D effects in Excel to make your spreadsheets much easier to read.

Microsoft Excel spreadsheets are not only supposed to be a useful way to store data, but also, help users read the data in a way that makes sense. Ironically, sometimes there's so much data in a spreadsheet that it ultimately becomes difficult to read.

A great way to make your data easier to read is to use Excel's Borders and Shading feature, which let's you add 3-D effects to your spreadsheet. For example, you can use Borders and Shading to create alternating 3-D formatted columns: one column formatted as a raised button, and the other column formatted as a pressed in button. To add these effects to your spreadsheet, follow these steps:

  1. Select a cell on an empty worksheet, such as C5.
  2. Go to Format | Cells.
  3. On the Border tab, select the 5th line in the second column in the Line box.
  4. Select Automatic or Black in the Color drop-down box.
  5. Click the right-hand border button, then click the bottom border button.
  6. With the 5th line still selected, select white in the Color drop-down box.
  7. Click the left-hand border button, then click the top border button.
  8. Select the Patterns tab, select light gray, and then click OK.

C5 is now formatted with a raised button effect. To create the format for the alternate row, select D5 and repeat the steps above, only make the bottom and right borders white, and the left and top borders black. D5 is now formatted with a pressed in button effect.

To create the alternating 3-D pattern, follow these steps:

  1. Select C5 and D5, click on the Format Painter button, and click and drag C6:D20 to copy the format to those cells.
  2. Select C5:D20, click the Format Painter button, and then click and drag the next set of columns E5:F20 to copy the format to those cells.
  3. Continue copying the format with the Format Painter button until all desired cells are formatted.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

0 comments

Editor's Picks