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.

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:

The result you have created the table:

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:

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:

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:

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

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:

The result you have created the table:

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:

Results of the entire table content has been deleted:

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:

As a result the entire border is removed:

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

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

Good luck!