Excel > Excel 2007 Foundation > Formatting a worksheet

Borders and Shading

Borders and fill colours can be added to a cell or range of cells to make them more appealing and also to distinguish data such as totals.

Adding a border

  1. Select the cell(s)
  2. Click the Borders button in the Font group of the Home tab
  3. Applying a border to a cell
  4. Select the type of border you desire from the list
  5. The border is applied to the cells

To customise the border such as changing the line type or colour, select More Borders from the list. The Format Cells dialogue box opens on the Border tab.

Customising cell borders

Removing a border

  1. Select the cell(s) with the border you wish to remove
  2. Click the Borders button in the Font group of the Home tab
  3. Select No Border from the list

Adding a fill colour

  1. Select the cell(s) you wish to add a background colour to
  2. Click the Fill Color list arrow in the Font group of the Home tab
  3. Format the cell colour

  4. Select the fill colour of your choice from the list

Adding a pattern or fill effect

It is also possible to add a pattern or fill effect to the background of a cell.

  1. Select the cell(s) to add the pattern or fill effect to
  2. Click the Dialogue Box Launcher arrow in the bottom corner of the Font group of the Home tab
  3. Click the Fill tab
  4. Select a Pattern Color and Pattern Style, or click the Fill Effects button for options on setting gradients to colours
  5. Applying a pattern to cell shading

  6. Click Ok and the pattern or fill effect is applied to the cell(s)

Follow us on

Facebook  Twitter  You Tube