Skip to main content.

Apply Borders


To distinguish among different data in a worksheet, you can apply borders to cells, shade cells with a background color, or shade cells with a color pattern. As with other types of formatting, cell borders may be applied to all or part of your spreadsheet.

To define a border for a cell(s):

  1. Format Cells Drop Down Menu
  2. Select the cell(s) to configure.
  3. Navigate to the Home Tab/Font Group pull down arrow.
  4. Click on the Border tab.
  5. Choose the appropriate settings (color, size, and style of cell border).
  6. Click OK.

EXCEL EXTRAS

You may also use the Borders Icon on the Home Tab/Font Group to apply a border to a cell.