How to Apply a Border in Excel


Microsoft Excel is a spreadsheet software used for data storage and analysis. The main component of Excel is a cell, which can store data like numbers, dates and currencies; the cells are used to analyze trends and compare information. Each cell or range of cells can have borders. Use borders to emphasize cells in groups or to distinctly separate them from other groups of cells. There are several predefined borders with different thicknesses, and you can also customize the borders to use different colors.

  • Open Microsoft Excel.

  • Select the cells to which you want to apply borders.

    To select a range of cells, click and hold on the first cell you want to include in the border, then drag the mouse to the last cell you want to include.

    To select nonadjacent cells, click the first cell then press and hold the "Ctrl" key while clicking the other cells you want to include in the border.

    To select all the cells in a worksheet, click the corner box between row 1 and column A to highlight all cells.

  • Right-click anywhere on your selected cells and click "Format Cells...."

  • Click on the "Border" tab and choose a border style under "Style." Several styles are predefined like dotted lines, thin and thick borders. Then choose the border color under "Color." By default, it's set to "Automatic," which is typically black.

  • Click on the small boxes around the big box that says "Border." The small boxes on the left and below the big box correspond to the borders around the cell. Click "OK" to finish applying the border.


Promoted By Zergnet


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!