How to Add a Border in Excel

Add a border, border color, or border line style Click Home >, the Borders arrow, and then pick the border option you want . Add a border line style - Click the Borders arrow >, Border Style, and then pick a line style option.

Adding borders in Microsoft Excel can help you emphasize important data in your spreadsheets. There are different ways to add borders in Excel, including drawing them manually and customizing them to fit your preferences. In this article, we’ll go over the steps to add borders in Excel and explore the different features you can use.

To add borders to your Excel spreadsheet, start by selecting the cells you want to apply the borders to. Then, go to the Home tab and look for the Borders button in the Font group. Click on the drop-down arrow to see the different border options available. The most commonly used option is “All Borders,” which adds borders to all sides of the selected cells. Once you’ve made your selection, click away from the cells to see the changes.

If you want to customize your borders further, click on the Borders button again and select “More Borders” at the bottom of the list. This will open a pop-up box where you can choose different line styles, colors, and presets for your borders. You can also select specific borders to apply the changes to, such as only the outline or the inside borders.

Another way to add borders is by drawing them manually. To do this, click on the More Borders button and select “Draw Border.” You can then click and drag to draw borders wherever you want on your spreadsheet. If you need to add borders to a large range of cells, you can use the “Draw Border Grid” option to select a grid and apply borders to all cells within that range.

If you make a mistake while drawing borders, you can use the “Erase Border” button to remove them. To remove all the borders in a selected range, click on the No Border option. If you want to go back to the regular mouse pointer, just tap the Escape key on your keyboard.

In conclusion, adding borders to your Excel spreadsheets can make important data stand out and make your spreadsheet more organized. With the different border options available in Excel, you can customize your borders to fit your preferences. Try out these tips and see how they can enhance your Excel experience.


How do I add a border to a row in Excel?
Select a cell or a range of cells to which you want to add borders. On the Home tab, in the Font group, click the down arrow next to the Borders button, and you will see a list of the most popular border types. Click the border you want to apply, and it will be immediately added to the selected cells.
What is the shortcut key to add a border in Excel?
If you want to apply a border to a range of cells, select the cells and press Ctrl+Shift+7. This will apply a border to the selected cells.
How do you add a border in Excel on a Mac?
On a sheet, select the cell or range of cells where you want to add or change the borders.On the Home tab, under Font, click Border. , and then click the cell border that you want to apply. Tip: To add or remove parts of a border, on the Home tab, under Font, click Border.
Why can't I put borders around cells in Excel?
If your spreadsheet is in the protect mode the borders will not work.... unprotect the worksheet and the borders should work. That only applies if you don't allow users to format cells when you set the protection...