Quick Tip: How to add borders in excel

Excel allows you to organize your data; sometimes, you will need to add borders to cells to distinguish sections. The form of how to add borders in excel is simple and fast; in addition, there are different types of borders for your cells.

Adding borders will help you emphasize and highlight data like total rows, columns, headers, etc. It will make your spreadsheets look more professional, attractive, and organized. Below you will learn how to add borders in excel and highlight specific sections.

How to add borders in excel in simple steps?

This feature will allow you to learn how to add borders in excel 2016 safely and quickly. If you want to create a border, you'll need to apply one of the options that are built-in from the ribbon:

1. Select a cell or a range of cells to which you want to add borders. Then, on the Home tab, in the Font group, you will need to click the down arrow next to the Borders button, and you will be presented with a list of the most popular types of borders.

You will then need to click on the border of your choice, which will be added to the selected cells automatically. If you want to learn how to add borders in excel mac, you can also follow these steps.

How to Create a Custom Border Style in Excel?

If the default borders in Excel aren't your liking, you can customize them and enhance your spreadsheet. To learn how to add borders in excel and create a custom border style, you will need to perform the following steps:

1. On the Home tab in the Styles group, you will need to click on Cell Styles. If you don't see the Cell Styles button, click the More button in the lower right corner of the Styles box.

2. At the bottom of the dropdown menu, you must click on New Cell Style.

3. In the Style Name box, you will need to type a name for your new cell style and click Format. In this step of how to add borders in excel 2019, the Format Cells dialog will open. Switch to the Border tab and select the line style, the borders of interest, and the line color. When you have finished these settings, you must click OK.

5. In the Style dialog, you will need to clear the boxes for any formatting you don't want to include in the new style and press OK.

How to add custom borders in excel?

If you want to apply your custom border style, do the following:

1. Select the cells you want to format. It is the Home tab; in the Border group, you will need to click on the new style. Sometimes it will appear in the upper left corner of the Styles box. If you can see your custom style, you need to click More, find your new style under Custom, and click on it.

2. By clicking OK, your custom style will be applied correctly to the selected cells.

The process of how to add borders in excel online is easy and will help you highlight different sections of your worksheet.

Were you able to learn how to add borders in excel? With Excel, you can get a more organized and attractive worksheet. If you want to learn new Excel features, you can also follow WPS Academy.

Also, it will let you download WPS Office to create, edit and process Excel, PowerPoint, and Word documents for free.