The most detailed way to format borders for Excel tables Picture 1
- If you do not want to choose the available formatting templates, you can create your own formatting style by pressing New Table Style .
The most detailed way to format borders for Excel tables Picture 2
- New Table Style dialog box appears , enter
+ Name : Name the table format.
+ Table Element : Select display elements.
The most detailed way to format borders for Excel tables Picture 3
- Then click Format to select formats for the table.
The most detailed way to format borders for Excel tables Picture 4
- Click Border , select border format at Style and Border editing => click OK .
The most detailed way to format borders for Excel tables Picture 5
- The New Table Style panel appears, click OK to save.
The most detailed way to format borders for Excel tables Picture 6
- Select the table , go to Table Design and click to format the newly created table.
The most detailed way to format borders for Excel tables Picture 7
- The results are as illustrated below.
The most detailed way to format borders for Excel tables Picture 8
Formatting borders for Excel tables is quite simple and easy to do, right? In case you edit documents on Word and want to create professional borders, please refer to creating borders here.