Technology

Create borders in excel quickly

Creating frames in Excel helps you present data in a simple and organized way. Let FPT Shop guide you through the process of creating frames in Excel.

Administrator

29 November, 2023

191

1. How to create borders in Excel using the Borders tool quickly

Step 1: Select the data range you want to create borders for, then go to the Home tab > Borders Tool and choose More Borders.

You can also select the data range you want to create a data table for > Then right-click and select Format Cells or use the CTRL + SHIFT + F shortcut

Step 2: The Format Cells dialog box will appear on the screen > Select the Border tab and customize it to your liking > Click OK to complete the border setup.

There are many options for you to choose from. You can choose to create borders for the entire range by selecting All Borders.

Step 3: The desired border will appear on the screen.

2. How to choose line style to create borders in Excel

Step 1: Select the data range you want to select, then go to the Home tab > Borders Tool and select More Borders.

Step 2: The Format Cells dialog box will appear > Select the Border tab, then customize it to your liking > Press OK to complete the setup.

Step 3: Finally, the desired border settings will appear as you want them.

3. How to draw borders in Excel

Step 1: From the Home tab, click on the Borders button as the settings above, scroll down and you will see the Draw Borders command group, allowing you to set the drawing mode, color, and line style you want.

Step 2: Here you can choose the color (Line Color) and line style (Line Style) for the border. Excel will automatically activate the drawing mode (Draw Border) and the cursor will become a pencil when the operation is completed.

Step 3: Click on the Border button on the interface to stop drawing the border.

4. How to resize and color borders in Excel

Step 1: Select File on the toolbar, then select Options

First, open Excel. In the Excel interface, click on the File icon, then click on Options.

Step 2: Continue to select the Advanced item In the next interface, click on the Advanced section. Then scroll to the right and drag the mouse to the Display options for this worksheet. In the Gridline Color box, select the appropriate color for Excel gridlines. With this operation, you have colored the appropriate color for the gridlines.

After you have made your selection, press the OK button below to save.

Step 3: Select Format Cells to create a display range

After choosing the color, we will see that the old gridline color has been replaced with a new color as shown below.

To create a display range for Excel, you can select the range of cells and then right-click, select Format Cells.

Step 4: Perform the steps on the Border tab

Next, the Format Cells dialog box will appear. You click on the Border to proceed with the next steps.

In the Style box, you can choose different border styles for the table. To add color to the table, click on the Color box and choose any color you want.

After the above operations, you will create a colorful worksheet according to your preferences.

5. How to quickly delete borders in Excel

5.1. Delete all borders in excel

Step 1: Select one or more cells that you want to delete borders

Step 2: On the toolbar, select Home, then select Borders > No Border.

5.2. How to delete each border separately

Step 1: In the Home tab, in the Font group, click on the down arrow next to the Borders option, then select Erase Border.

Step 2: You can click on each border to delete each border or you can choose to delete all borders. To do this, click on the Erase Border button and drag the tool to delete the cells.

Step 3: To exit the erase mode, press the Border button again.

Conclusion

Above are the steps to quickly and effectively create borders in Excel. Creating borders will make your documents more professional. If you have any questions related to this article, please comment below for clarification.