Apply Borders to the Cells in MS-Excel

It is necessary to apply colour and style to the borders/lines to a range of cells for certain categorized contents to make the content easy to identify and beautify.

To apply borders to the cells in MS Excel, you can select the Line Color, Line Style or Both you want for a different border format, or otherwise, leave it as it is if you wish to apply the default line styles and colours.

Apply Borders to the Cells in MS-Excel:

  1. On the Home tab, in the Font group, Chick the expand button of the Borders
  2. Under “Draw Borders”, Select one of the Line Colors, and Line Styles to apply the borders to the cells in Excel.
Apply Borders to the Cells in MS-Excel
Apply Borders to the Cells in MS-Excel

Bottom Border:

To apply only the Bottom Border to the currently selected cells, select the “Bottom Border”. To do so, follow the steps below.

  1. Select the cell/range of cells you want
  2. On the home tab, in the font group, click on the drop-down arrow of the border, and then select the Bottom border.

Top Border:

To apply only Top Border Style to the currently selected cell/s, select the “Top Border” option.

Left Border:

To apply only the Left Border to the selected cell/s, select the “Left Border”.

Right Border:

To apply only the Right Border to the selected cells/s, select the “Right Border”.

No Border:

To remove all the Borders Styles to the selected cell/s, which are applied before, select the No Border option.

All Borders:

To apply all the Borders to the selected cell or range of cells, select “All Borders”.

Outside Borders:

To apply only Outside Borders to the selected cell or range of cells, select the “Outside Border”.

Thick Outside Borders:

To apply Outside Borders which is Thick to the selected cell or range of cells, select the “Thick Outside Border” option.

Double Bottom Border:

To apply Double Bottom Border to the currently selected cell or range of cells, select the “Bottom Double Border” option.

Thick Bottom Border:

To apply Thick Bottom Border to the currently selected cell or range of cells, select the “Thick Bottom Border”.

Top and Bottom Border:

To apply the Top and Bottom Border to the currently selected cell or range of cells, select the “Top and Bottom Border”.

Top and Thick Bottom Border:

To apply Thin Top and Thick Bottom Border to the selected cell or range of cells, select the “Top and Thick Bottom Border”.

Top and Double Bottom Border:

To apply the Top Single and Double Bottom Border to the selected cell or range of cells, select the “Top and Double Bottom Border”.

Draw Border:

To draw outside borders to the current cell or range of cells.

Draw border Grid:

Draw all borders to the current cell or range of cells.

Erase Border | apply borders to the cells in MS-Excel:

Remove all borders from the selected gridlines in a worksheet.

Is it possible to apply borders to the cells in Excel?

Yes.

Share