HomeApplicationOffice information

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 create and delete tables in ExcelHow to create and delete tables in Excel
    how to create and delete tables in excel. excel is a great tool for calculating, it supports many calculation functions, logical functions ... but for the numbers to be presented scientifically and beautifully you need to create tables for data. this article helps you to create and delete tables in the table
  • 11 double-click tricks in Excel you shouldn't miss11 double-click tricks in Excel you shouldn't miss
    to process excel data tables, in addition to excel functions or formulas, we also have many tips to use, such as the double-click trick to quickly manipulate or quickly process data in excel tables.
  • How to hide, show notes in tables on ExcelHow to hide, show notes in tables on Excel
    the feature of commenting and commenting on excel data sheet will help viewers better understand, more detailed information about the content in the row or column.
  • How to insert tables, format tables in wordHow to insert tables, format tables in word
    show you how to insert tables and format tables easily.
  • How to create spaces between letters and cell borders in ExcelHow to create spaces between letters and cell borders in Excel
    adding spaces between text and cell borders in excel makes it easier to read the document.
  • How to Create Pivot Tables in ExcelHow to Create Pivot Tables in Excel
    pivot tables are interactive tables that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. they can sort, count, and total the data, and are available in a variety...
  • MS Word - Lesson 8: Creating a tableMS Word - Lesson 8: Creating a table
    table is used to display data in a tabular format. how to create a table in word, how to format word 2007 tables? please follow the instructions below.
  • Steps to create relationships between multiple tables using Data Model in ExcelSteps to create relationships between multiple tables using Data Model in Excel
    excel is a powerful tool for data analysis and automation after processing large data sets. you can spend considerable time analyzing tons of data using vlookup, index-match, sumif...
  • How to add units to cells in ExcelHow to add units to cells in Excel
    in addition to the available units, users can completely add other units in the excel box.
  • Table in HTMLTable in HTML
    what does it take to create a table in html? is it complicated? want to add color to the table border, how to add the background color to the text in the table? in this article tipsmake.com will answer those questions and guide you to basic operations with tables on html, in addition to adding alternate color schemes for rows in the html table. invite you to follow along.

Office information