- 1). Open Microsoft Excel.
- 2). 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. - 3). Right-click anywhere on your selected cells and click "Format Cells...."
- 4). 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.
- 5). 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.
SHARE
