Skip to content

DigiRuns

Surpass Technical Knowledge

Menu
  • Home
  • Fundamentals
  • Digital Marketing
    • WordPress
    • Web Design and Development
  • Microsoft Office
    • Microsoft Word
    • Microsoft Excel
    • Microsoft PowerPoint
Menu

Apply Borders to the Cells in MS-Excel

Posted on 14/04/201901/01/2022 by DigiRuns

To apply borders to the cells in Excel, you can select the Line Color or 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 colors.

  1. On the Home tab, in the Font group, Chick the expand button of the Borders
  2. Under the “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

Related Post on MS- Word: Table Borders | Border Styles and Painter in MS-Word>>

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 Bottom border.

Top Border:

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

See also  How to Add Zeros Before a Number in Excel - 2022's Best

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.

See also  How to Freeze Panes (Rows and Columns) in Excel - 2022

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 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.

Related Posts:

  1. Table Style Options and Table Styles in MS-Word
  2. What are the Keyboard Navigation keys?
See also  How to Allow Edit Ranges in Excel - 2022's Priceless

FAQ:

How to Apply Borders to the Cells in Excel?

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 to Apply Borders to the Cells in Excel.

How to apply bottom borders to the cells in Excel?

To apply only the 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.

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

Yes.

Recent Posts

  • How to Hide Featured Image On a WordPress Post/Page – 2022
  • YouTube Floating Window for Windows, Mac, and Mobiles
  • A Table Generator for Word and Office 360 – Shortcut Trick
  • How to Enable Missing Theme Editor and Plugin Editor in WP
  • (A-Z) Change Text Direction (Rotate, Flip or Mirror) in Word
  • How to Select Objects That are Behind Text in Word – 2022