How to Make a Table in Excel (2 Simple Ways)

Get FREE Advanced Excel Exercises with Solutions!

In Excel, we need to make a table where we must arrange a data range in a structured form. So that we don’t need to format each cell every time. In the table, all data will be in the same format as per the given instruction.


Make a Table in Excel: 2 Simple Ways

Here, we will have a data set of Products sold in different Towns with their Sales values. Data on these sheets are not very significant. We introduced that data so that you can understand it easily.

How to Make a Table in Excel

Now, we will use this organized dataset to show you how to create a table in Excel. However, make sure to have the same type of data within a column and remove blank cells before converting data range to a table.


1. Use Format as Table Feature to Make a Table in Excel

In the first method, we will use the Format as Table feature from the Home tab to make a table. Follow the steps given below to do it on your own dataset.

Steps:

  • Firstly, select your desired cell range. Here, we will select cell range B4:D9.
  • Secondly, go to the Home tab >> click on Format as Table >> select any table from there according to your choice.

Ways to Make a Table in Excel

  • Now, the Create Table box will open, where you will see that the data has already been selected.
  • After that, turn on My table has header option.
  • Lastly, click on OK.

Use Format as Table Feature to Make a Table in Excel

  • Thus, you can make a table using your dataset.


2. Utilize Table Feature from Insert Tab to Create Table

You can also make a table utilizing the Table feature from the Insert tab in Excel.

Here are the steps.

Steps:

  • In the beginning, select the cell range that you want to make a table.
  • After that, go to the Insert tab >> click on Table.

Utilize Table Feature from Insert Tab to Make a Table in Excel

  • Next, the Create Table box will appear.
  • Then, turn on My table has header option.
  • In the following step, click on OK.

Opening Create Table Box to Make a Table in Excel

  • Finally, you will get a table using your dataset.

How to Make a Table in Excel


How to Format Table in Excel

There are many options available on the table. Let’s go through the options below and have a look at the screenshots to get a detailed idea of how to format an Excel table with some user-defined structures.


1. Use Quick Styles Feature

We have a quick style option on Table. You can use it to choose different types of table formats. Go through the steps to do that.

Steps:

  • Firstly, click on the cell of the table.
  • Now, we will get the Table Design option in the ribbon.

Use Quick Styles Feature to Format Table in Excel

  • Then, go to the Table Design tab >> click on Quick Styles.
  • After clicking Quick Styles we will get a drop-down.
  • From the drop-down, select a style.
  • Here, we selected the Light Blue, Table Style Light 16 style.

  • Finally, you can use the Quick Styles feature to style a table in Excel.


2. Utilize Table Style Options

Additionally, you can also change the table format utilizing the Table Style option.

Steps:

  • Firstly, open the Table Design tab by clicking on any cell of the table.
  • After that, clicking on Table Design, we will get Table Style Options.
  • Thus, you can format your rows and columns in the table using the given options.


3. Rename Table from Table Design Tab

Moreover, we can rename our table from the Table Design tab. The steps are described below.

Steps:

  • To start with, go to the Table Design tab >> expand the Properties option.
  • Now, we will get the Table Name.
  • Then, you can change the name of the table according to your wish.


4. Resize Table Using Table Design Tab

We’ll now show you how to resize your Table.

Steps:

  • In the beginning, click on a cell of the table to get the Table Design option in the ribbon.
  • Then, go to the Table Design tab >> expand Properties option >> click on Resize Table.

  • Now, we will get the Resize Table box.
  • After that, you can change the data range if you want.
  • Lastly, click on OK.


5. Filter Data from Table

We can also apply Filter in Table. Here are the steps to do that.

Steps:

  • Firstly, select the Filter button (down arrow sign) and you will get Filter options.
  • After that, turn on or off options according to your wish.
  • Here, we filtered only the data for Chicago and Dallas.

  • Thus, you can filter your data from a table in Excel.

6. Use Other Additional Tools

Additionally, you can also use other tools on your table. Here are the steps to find those tools.

Steps:

  • In the beginning, go to the Table Design option >> expand Tools.
  • Then, you will have the following options like:
    • Summarize with PivotTable
    • Remove Duplicates
    • Convert to Range


Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Section


Download Practice Workbook

You can download the workbook to practice yourself.


Conclusion

Here we showed how to make a Table in Excel. We also showed different options of Table in brief so that users get an idea of which things are possible to do with Table. Lastly, feel free to comment if something seems difficult to understand. Additionally, let us know any other approaches that we might have missed here. Thank you!


Make Table in Excel: Knowledge Hub

<< Go Back to Excel Table | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo