How to create a custom cell style in Excel

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.

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.

How to create a custom cell style in Excel

From the Cell Styles list, you should click on New Cell Style at the bottom.

How to create a custom cell style in Excel

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.

how to add a border to 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.

how to draw borders in excel 2016

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 add a border to cells in Excel


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 2016

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.

  1. First, you need to be in the Home tab.
  2. Then go to the Font group > Click on the drop-down arrow next to the Borders icon. The selection of different borders appears.
  3. 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.

How to create a custom cell style in Excel

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.

  1. Start by going to the Home tab.
  2. Go to the Font group > Click on the drop-down arrow next to the Borders icon. It shows a selection of various borders.
  3. 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.

how to draw borders in excel 2016
  1. Follow the same steps as above by going to the Home tab.
  2. Then click on the drop-down arrow next to the Borders icon.
  3. 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.

how to add a border to cells in Excel

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.

how to draw borders in excel 2016

Read more: How to add a border to a range of cells in Excel »

Conclusion

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.

Leave a Comment