Apply Borders to the Cells in MS-Excel:
Before applying borders to the cells in MS-Excel, you can select the Line Color or Line Style or Both you want for different border format, or otherwise, leave it as it is if you wish to apply the default Line styles and Colors. To do it, follow the steps below:
- On the Home tab, in the Font group, Chick the expand button of the Borders
- Under the “Draw Borders”, Select one of the Line Colors, and Line Styles for Applying Borders to the Cells in Excel.
Read Also Related Post on MS- Word :Table Borders | Border Styles and Painter in MS-Word>>
To apply only Bottom Border to the currently selected cells, select the “Bottom Border” Follow the steps below to apply the bottom border:
- Select the cell/range of cells you want
- On the home tab, in the font group, click on the drop-down arrow of the border, and then select 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 the “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 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 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 border 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.