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:

Insert Table in Excel Using Basic Approach

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

Insert Table in Excel Using Basic Approach

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

Insert Table in Excel Using Basic Approach

  • 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:

Insert a Table with Style

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

Insert a Table with Style

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

Insert a Table with Style

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

Insert a Table with Style

  • 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:

Insert a Table and Change the Style

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

Insert a Table and Change the Style

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

Insert a Table and Change the Style

  • 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:

Remove Existing Style of a Table

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

Remove Existing Style of a Table

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

Remove Existing Style of a Table

  • 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


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:

Rename after Inserting Table in Excel

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

Rename after Inserting Table in Excel


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.

Extend the Shape of Existing Table

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

Extend the Shape of Existing Table

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

Extend the Shape of Existing Table

  • 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:

Remove the Table Format in Excel after Inserting

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

Remove the Table Format in Excel after Inserting

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

Remove the Table Format in Excel after Inserting

  • 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:

Sort the Data of Table in Excel

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

Sort the Data of Table in Excel

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

Sort the Data of Table in Excel

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:

Use Filter Option in Table Excel

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

Use Filter Option in Table Excel

  • 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

Tags:

Mukesh Dipto

Mukesh Dipto

Hi there! I am Mukesh Dipto. I graduated with a bachelor's degree in engineering. Currently, I am working as a technical content writer in ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include sports and meeting new people. I also enjoy sports. My favorite sports are football (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo