HomeApplicationOffice informationThe most detailed way to format borders for Excel tables

The most detailed way to format borders for Excel tables

Instructions for formatting borders for Excel tables

2. Detailed instructions
Step 1 : Open Excel on your computer, select the table you want to format.
Step 2 : At Design, select Table Style  => click the format style you want to apply.

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.

4 ★ | 2 Vote
excel. excel

You should read it

May be interested

  • How to type angle symbols in Word simply and quicklyPhoto of How to type angle symbols in Word simply and quickly
    if you are using word and want to insert mathematical expressions and are having difficulty not seeing the angle symbol. follow this article to quickly draw angle symbols in word with just a few simple steps.
  • The most effective way to number pages in Word 365 as desiredPhoto of The most effective way to number pages in Word 365 as desired
    page numbering in word 365 is an important task when you are drafting or doing a thesis on microsoft word tool. if you don't know how to number pages in word 365, please follow tipsmake's instructions below!
  • IFS function in Excel, usage and specific examplesPhoto of IFS function in Excel, usage and specific examples
    what is the ifs function in excel? how to use the ifs function in excel 2016? here's everything you need to know about the ifs function in excel.
  • How to create tables in Word on computersPhoto of How to create tables in Word on computers
    how to create a table in word will help you easily list and summarize data in documents. this is one of the basic word skills that everyone needs to know, so you should master how to create word tables to start getting acquainted with this software.
  • How to download Office 365 100% freePhoto of How to download Office 365 100% free
    currently, there are many general office toolkits that have high security features and help connect and share quickly. including office 365, follow the steps to download office 365 100% free with tipsmake below.
  • Install Office 2010, Word and Excel office suitePhoto of Install Office 2010, Word and Excel office suite
    installing office 2010 helps you own one of the tools for editing word documents, creating excel spreadsheets and creating professional powerpoint presentation slides. we will guide you how to install office 2010, the word and excel office suite in the most detail

Office information