Borders and Shades in Excel 2010


Apply Borders

MS Excel enables you to apply borders to the cells. For applying border, select the range of cells Right Click » Format cells » Border Tab » Select the Border Style.

Setting Border Style

Then you can apply border by Home Tab » Font group » Apply Borders.

Setting Border

Apply Shading

You can add shading to the cell from the Home tab » Font Group » Select the Color.

Shaded Cell