In the previous article, you learned how to add a border around a range of cells in Excel. Did you know that you can also create a custom cell style in Excel? You will learn to create and insert a custom border around cells in Excel. You will also learn another way to add a cell border in an Excel worksheet. Read and follow the steps to draw borders in Excel 2016 or later.
Table of contents
- Create a custom border style around a range of cells
- How to insert a custom cell style in Excel
- How to draw borders in Excel
Create a custom border style around a range of cells
You can choose from many different table styles that include borders when you create or format an Excel table. This way, you don’t need to add a cell border in Excel. Read about how to remove table formatting to see the different table styles.
You can also create a custom border and save it in Cell Styles in the ribbon. It means that you can use the same custom cell border again by clicking on it. If you don’t like the custom cell border, you can easily delete it afterward. Let’s take a look at how to create a custom border around cells in Excel.
1 – New Cell Style
First, you need to click on the Home tab. Then go to the Styles group in the ribbon > Click on the Cell Styles icon. It will open a selection of different cell styles.
From the Cell Styles list, you should click on New Cell Style at the bottom.
2 – Type new name in the Style dialog box
Now the Style box opens up in your worksheet. On the white line, you have to type a new name for your custom border style. In our example, we have named it BestStyle. Then click on Format to create a custom border style around cells in Excel.
3 – Create custom cell style in Format Cells dialog box
It will open the Format Cells box, where you can start to create the custom cell border.
- Click on the Borders tab.
- Then choose which line Style you like best by clicking on it.
- Choose which color you want to use by clicking on the arrow next to it. You can select any color from this selection > Click on a color.
- Select the border buttons you want. In our example, we have chosen the top and bottom line. Look at the preview to see if you like the custom cell border style.
- Click OK to confirm.
4 – Make changes in the Styles dialog box
Now you will be directed back to the Styles dialog box, where you should tick off the small boxes you don’t want to include in the cell style. In our example, we have ticked off the first three boxes. If you look carefully, you notice that the information next to the small Border box has changed. It says that there are Top and Bottom Borders. It is because we chose the top and bottom borders in the previous step. So if you select other border styles, then it will write something else.
Then click OK. Now, you have successfully created a custom cell style.
How to insert a custom cell style in Excel
You can insert a custom border in Excel by clicking on the Cell Styles icon under the ribbon’s Styles group.
Steps to apply a custom cell style:
- Select the cells where you want to insert a custom cell style.
- Then go to the Home tab > Go to the Styles group in the ribbon.
- Click on the Cell Styles icon > Now, you can find your new style on top of the list under Custom. You can recognize it by the style name you have typed. In our example, we named it BestStyle.
- Click on the name (e.g., BestStyle) > It will insert your custom cell style into the selected cells.
How to draw borders in Excel
You can draw a border directly on your Excel worksheet without selecting any cells. It is possible to draw a border in Excel in three steps.
- First, you need to be in the Home tab.
- Then go to the Font group > Click on the drop-down arrow next to the Borders icon. The selection of different borders appears.
- Go to the bottom of the selection to Draw Border. Your mouse cursor changes into a pen, and now you can click on any cell line to add a simple black line border.
Create a custom cell Line Color and Style
You can also change the Line Color and Line Style of the border before you draw a border. This is another way to draw borders in Excel 2016 or later.
- Start by going to the Home tab.
- Go to the Font group > Click on the drop-down arrow next to the Borders icon. It shows a selection of various borders.
- Now go to the bottom of the selection and choose Line Color to select the color you like to use. We have chosen a standard color (purple), but you can choose any color you like. If you want other colors, then click on More Colors at the bottom.
- Follow the same steps as above by going to the Home tab.
- Then click on the drop-down arrow next to the Borders icon.
- The selection opens > Click on Line Style, to select a border style. Choose any line you want to use, and the mouse cursor automatically changes into a pen. Now, you can add a cell border to your Excel worksheet by clicking on a cell line.
Difference between Draw Border and Draw Border Grid
Once you decide on the line color and style, you create a custom cell style in Excel. Your mouse cursor changes into a pen, and you can start making borders.
The difference between Draw Border or Draw Border Grid is quite simple. If you want to draw borders and click on each cell line to add a border, then it does not make any difference which one you choose.
When you draw borders, you can also select a cell and drag it outside. It is the same as selecting a range of cells.
- If you select Draw Border, you will only get a border around the selected range of cells.
- Once you click on Draw Border Grid, you will see borders around every single cell in that selected area.
The difference is shown in the below picture.
You can create your own custom border style in Excel in Cell Styles under the Styles group on the Home tab. It is easy to draw borders in Excel 2016 or later, as you do not need to select any cells beforehand. It is a way to avoid inserting borders, and you can also decide on a custom line color and style.