Excel cell borders allow you to draw lines around the cells and between cells. Cell borders are useful for visually separating information, and can be customized to set different line styles, thicknesses, and colors.
Please do not mess up cell boundaries and gridlines. You must manually apply cell boundaries to the spreadsheet since they do not automatically appear.
For example, you may need to add a border to the page to focus user attention on grand totals or other KPI data.
How to add a Border in Excel
You can use the excel border command in Font section to add or remove borders of the cells in excel.
Steps to use Excel border command to add borders in excel
- Select the range of cells A1:M11
- Go to the Home Tab, In the Font group section select the Borders icon, and you can see a list of border types.
- Select the border type All borders to apply, it will add the borders to the selected range A1:M11
How to add a Border with Format Cells dialog box
You have more options in the Excel format cells dialog box to add or remove borders to the selected cell. It gives options to change the borders line color, style, and thickness to align with your template.
Please follow the below steps to add a border in excel with format cells dialog box
- Select a range of cells A1:M11, and Go to the Home Tab, In the Font group section, Click the More button, to open the Format cells dialog box
- Go to Border Tab
- Select the Outline and Inside icons in the Presets section to add borders to top, left, right and bottom of the cell.
- Select the border style
- Choose the color you need to add to the cells
- Press OK, and it will add the borders to the selected range A1:M11
How to Remove all borders in Excel
Select the range of cells A1:M11, and Go to the Home Tab. In the Font group section select the Borders icon, and select No borders in the border type list.
Ctrl + Shift + _ is the shortcut key to remove all cell borders
Conclusion
You can change the border styles, thicknesses, and colors of cell borders in excel in a few clicks. It helps the stack holder to easily understand the data and pattern.
If you have any questions, please leave a comment below and I will get back to you as soon as possible.
