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 Excel.

How to create and delete tables in Excel Picture 1

1. Create a table

There are 2 ways to create a table:

Method 1: Create a table by drawing border borders

The easiest way to create a table is by creating a border for the data area to create the table. You just need to select the data area you want to create the table -> go to the Home tab -> click the Border icon -> All Border to draw the table:

How to create and delete tables in Excel Picture 2

The result you have created the table:

How to create and delete tables in Excel Picture 3

Method 2: Create a table using the Table feature

Step 1: Highlight the data area to create a table -> go to the Insert tab -> Tables -> Table:

How to create and delete tables in Excel Picture 4

Step 2: The Create Table dialog box appears if you want to make the first row the title of the check box and select My table has headers -> OK:

How to create and delete tables in Excel Picture 5

The result is that you have created a table. However, if your header column contains a cell, the resulting table structure is not what you expected:

How to create and delete tables in Excel Picture 6

So you need to adjust the table structure before using the table creation method this way:

How to create and delete tables in Excel Picture 7

After creating the table, the header row contains an arrow to filter the data. Want to remove the arrow filter data you just go to the Data tab -> Fillter:

How to create and delete tables in Excel Picture 8

The result you have created the table:

How to create and delete tables in Excel Picture 9

So there are 2 ways to create tables. In case the table needs to create a header row with a cell you should use method 1 to create the table.

2. How to delete a board

2.1 How to create a table using the Insert / Table feature:

To delete a table, just select the table you want to delete -> right-click and select Delete -> Table Columns or Table Rows:

How to create and delete tables in Excel Picture 10

Results of the entire table content has been deleted:

How to create and delete tables in Excel Picture 11

2.2 How to create a table using the body borders

Select the entire table to be deleted -> go to the Home tab -> click the Border icon -> No Border:

How to create and delete tables in Excel Picture 12

As a result the entire border is removed:

How to create and delete tables in Excel Picture 13

If you want to delete all contents in the table, select all the data to delete -> right-click and select Clear Contents:

How to create and delete tables in Excel Picture 14

Above are some ways to help you create and delete tables in Excel.

Good luck!