How to Insert Table in Excel (2 Easy and Quick Methods)

Excel Table allows us to work independently with a range of data from the rest of the worksheet. In this article, we will show you the insert table excel process from a range value. The Excel table covers a lot of features that help to make the work more convenient while working with a large dataset.

Download Practice Workbook

You can download the practice workbook from here.

2 Easy Methods to Insert Table in Excel

In this article, we will demonstrate 2 easy methods to insert a table in excel. We have a dataset of people who traveled to different cities of the USA from London airport for January, February, and March.

1. Insert Table in Excel Using Basic Approach

First and foremost, we have the following dataset of excel range. We will insert a table by using the following dataset. Just go through the following steps to perform this action:

• In the beginning, select any cell from the range dataset. In our case, we are selecting cell B4.
• Next, go to the Insert tab and select the option Table.

• Then, a new window will open. We can see that the range of the dataset gets selected by default.
• Do not forget to check the option “My table has headers”.
• Press OK.

• Finally, we get the range of data converted into a table. We can see the table icon in the headings of the dataset.

Read more: How to Insert A Pivot Table in Excel

2. Use Excel Styles Group to Create Table

We can style an excel table to make the dataset more attractive. With the use of styling, we can also differentiate between the different parts when our dataset is large.

2.1 Insert a Table with Style

In this example, we will insert a table with style whereas we didn’t do any kind of style in our previous example. Let’s see how we can do this:

• Firstly, select a cell from the data range. In this example, we will select cell B4.

• Next, go to the Home tab and select the Format as Table.

• Now we can see a drop-down of styles. We can choose any style from the available list for our table.
• We select the second one from the medium section.

• Then, a new window will open. We can see that the range of the dataset gets selected automatically.
• Check the option “My table has headers”.
• Press OK.

• So, we can see our existing table with a new style.

2.2 Insert a Table and Change the Style

Suppose, we have the following table with a particular style. Now we need to change the style of the table. In this example, we will demonstrate to you how we can change the existing style of our table. Go through the following instruction to do this:

• Firstly, select any cell from the data range. Here, we will select cell B4.

• Next, go to the Table Design tab.
• Select the drop-down option in the Table styles section.

• Then, we can see the available style lists.
• After that, we will select the list that we have marked in the image. You can pick any style from the list which seems convenient to you.

• Finally, we can see the new style of our table.

2.3 Remove Existing Style of a Table

Sometimes, while working we might need to remove the style of our table. We can do this by going through some easy steps. In this example, we will remove the style of the following dataset. Let’s see how we can do this:

• First, select any cell from the data range of our worksheet.

• Go to the Table Design tab.
• Click on the drop-down under the Table Styles section.

• Then, we will see the available style options.
• After that, select the first option that represents no style.

• Lastly, we can see that there is no style in our table.

Similar Readings

• Create Table in Excel Using Shortcut (8 Methods)
• How to Make a Table in Excel (With Customization)
• Edit a Pivot Table in Excel (5 Methods)
• How to Update Pivot Table Range (5 Suitable Methods)

Rename after Inserting Table in Excel

In the time of working, we will deal with so many tables in a single worksheet. So, we might need to use a specific name for each table. We can rename a table easily after inserting it. Now we will change the name of the following table. Let’s see the necessary steps regarding this process:

• In the beginning, select any cell from the data range of the worksheet. In this example, we select cell B4.
• Next, go to the Table Design tab.
• Then we get a section for Table Name. We will input the new name for this table in this section.
• Finally, we used the name New_Table as the new name for the table.

Extend the Shape of Existing Table

Suppose, we have inserted a table. Now for our work, we need to extend our table. The extension may be towards rows, columns, or both. In this example, we will see how we can extend the following table by going through some simple steps.

• First, we will select any cell from the data range.
• Next, go to the Table Design tab.
• Select the option Resize Table.

For this example, we will extend the table by one row and one column.

• Now, we can see the Resize Table window. Select the cell range ($B$4:$F$11) for the table.
• Press OK.

• Finally, we get the extended table. We can see a new row and a new column added to the table.

Remove the Table Format in Excel after Inserting

For the convenience of our work, sometimes we need to remove the table format. We can do this easily by following some steps. In this example, we will remove the table format for the following dataset. Let’s see how we can do this:

• Firstly, select cell B4 from the date range of the dataset.
• Next, go to the Table Design tab.
• Select the option Convert to Range.

• A new window will pop up. Click on Yes.

• Finally, we get the dataset without table format.

Table Management in Excel

Excel tables include a lot of cool capabilities that make it easy to calculate, modify, and update data in your worksheets. The majority of these options are simple and intuitive. A basic overview of the most important ones can be found here.

1. Sort the Data of Table in Excel

We can sort the data of a table easily. We will follow some simple steps to perform this action for the following table:

• Firstly, to sort a table by a certain column click on the drop-down in the header cell City.
• Next, select the sorting option Sort A to Z.

• Finally, we get the sorted value of the column City by A to Z.

We can also sort numerical values in a table. To demonstrate this we will sort the value of the first month of January in our dataset.

• Click on the drop-down arrow in the column January.
• Select the option “Sort Smallest to Largest”.

• So, we get the sorted value for January from smallest to largest.

2. Use Filter Option in Table Excel

Filtering a default option for a table in excel. We can easily use the filter option in our dataset if we use the data in a table format. To illustrate this to you we will filter the values of column city in the following dataset. Let’s see how we will do this:

• In the beginning, click on the drop-down arrow in the heading cell City.
• Then, from the drop-down uncheck the options Manhattan, New Jersey, and Texas.
• Press OK.

• Finally, we get the filtered dataset. We can see that only New York, Los Angeles, and California are visible.

Conclusion

Inserting a table in Excel is not only makes data management easy and effective but also saves time. In this article, we have tried to make the insert table excel process easier for you. So, download the practice workbook added to this article and try yourself. If you feel any confusion just leave a reply in the below box. Stay tuned with us for more interesting solutions to excel problems.

Further Readings

• How to Insert or Delete Rows and Columns from Excel Table
• Refresh All Pivot Tables in Excel (3 Ways)
• How to Auto Refresh Pivot Table in Excel (2 Methods)
• Pivot Table Custom Grouping: With 3 Criteria