Mar 7, 2011

Create 3D effect for cells in Excel 2007

You can play around with borders and apply suitable colors to the borders so that the cell appears with 3D effect. In the figure to the right, you will see two cells B2 and D2. These cells appear as buttons. You can create this effect by performing the following:

1. Color the background for cells A1 to E3: Click cell A1. Press the SHIFT key. Keeping the SHIFT key in pressed state, click cell E3. On the Home tab, in the Font group, click the arrow in the Fill Color command and click Blue, Accent1, Lighter 80%.
2. Click cell B2. Press the CTRL key. Keeping the CTRL key in pressed state, click cell D2. Click the Fill Color command and click Tan, Background 2, Darker 10% (It is second left from the Blue, Accent1, Lighter 80% color).

3. Click cell B2, press CTRL key. Keeping the CTRL key in pressed state, click cell D2. Open Format Cells dialog box by pressing CTRL + 1 (or) on the Home tab, in the Font group, click the DOWN arrow in the Borders command and click More Borders...

4. In the Format Cells dialog box, click the Border tab and do the following:
Under Style:, click the line as shown in the figure with the label 1.
Under Color:, click Automatic. It is labeled 2 in the figure.
Under Border, click the Bottom Border button (labeled 3) and click Right Border button (labeled 4).
Under Color:, click White, Background 1 (labeled 5).
Under Border, click the Left Border button (labeled 6) and click Top Border button (labeled 7).

5. Click OK.

0 comments:

Post a Comment