How to make borders 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 borders 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 borders have to be made
- 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