How to create a border in Excel

You can watch a video tutorial here.

Excel provides many options for formatting worksheets. One of the options is to create or remove a border for cells or a table. Borders help define the outline of a table and are a good option when formatting your sheet to make it look neater.

Option 1 – Use the preset option 

Step 1 – Choose the button on the ribbon

  • Select the area for which the border has to be created
  • On the Home menu, click the Borders button on the Font section
  • On the drop-down menu, select the All Borders option

Step 2 – Check the result

  • Each cell in the table has a border

Option 2 – Use the Format Cells option

Step 1 – Open the Format Cells window 

  • Select the area for which the border has to be removed
  • Go to Home > Number  and click on the arrow to expand the menu

OR

Right-click and select Format Cells  from the context menu

OR

Go to Home > Cells > Format > Format Cells

OR

Press Ctrl+1

Step 2 – Choose the borders to be created

  • Go to the Border tab
  • Add the borders by clicking the preview diagram or the border buttons

Step 3 – Check the result

  • Depending on the requirement, any or all of the borders can be added to the cells