Skip to main content.

Applying 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):

 

  • Select the cell(s) to configure.

               borders

  • Navigate to the Borders And Shading group in the Formatting Palette.

              borders

  • Choose the appropriate settings (color, size, and style of cell border).

                borders

  • Click OK.

              borders