Creating 3D Formatting for a Cell in Excel

1)Select the cell that you want to format.
2)Choose Cells from the Format menu. Excel displays the Format Cells dialog box.
3)Make sure the Patterns tab is selected.
4)From the colors available, pick the lightest gray color you can see. This forms the background for the cell.
5)Display the Border tab.
6)In the Style list of the Line area, click on the second-widest solid line.
Make sure the Color drop-down is set to either Automatic or Black.
7)In the Border area, click the buttons for both the right border and the bottom border.
8)Using the Color drop-down, choose White. It will look like all the line styles disappeared, but don't worry--they are still there, and the second-thickest line style should still be selected.
9)Click the buttons for both the left border and the top border. You shouldn't see anything in the preview area, since white-on-white doesn't show up well. However, the buttons for the left and top borders should show as selected.
10)Click OK.


Author: Mark25 Apr 2010 Member Level: Bronze   Points : 1

Found an easy guide here -

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: