Buzz
We can change the border color of the table, the background color of the table with the options provided by Excel, or add some creative details to the table. This article will guide you on the detailed steps to format Excel table borders.
Excel Table Borders Formatting Guide
Guide to Formatting Excel Table Borders
- 1. Quick Guide
- Open Excel => Select the table to format => Click on Design => Choose Table Style => Select a suitable formatting template.
2. Detailed Guide
Step 1: Open Excel on your computer, select the table you want to format.
Step 2: In Design, choose Table Style => click the formatting style you want to apply.
- If you prefer not to choose from available formatting templates, you can create your own formatting style by pressing New Table Style.
- The New Table Style dialog box appears, enter
+ Name: Assign a name for the table format.
+ Table Element: Choose the display elements.
- Then press Format to select the formats for the table.
- Click on Border, choose the border format under Style and Border adjustment => press OK.
- The New Table Style table appears, press OK to save.
- Select the table, go to Table Design, and click on the newly created table format.
- The result is as illustrated below.
Formatting borders for Excel tables is quite simple and easy to execute, isn't it? In case you're composing text in Word and want to create professional borders, check out how to create borders right here.
