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

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.


Download Practice Workbook

You can download the workbook to practice yourself.


2 Simple Ways to Make a Table in Excel

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 same type of data within a column and remove blank cells before converting your 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 in Table. You can use it to choose different types of table formats. Go through the steps to do that.

Steps:

  • Firstly, click on a 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.

Read more: How to Edit a Pivot Table in Excel


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.

Read More: How to Rename a Table in Excel (5 Ways)


Similar Readings


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 in 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

Read more: How to Use Slicers to Filter a Table in Excel 2013


Practice Section

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

Practice Section


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 which we might have missed here. Also, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Tags:

Alok

Alok

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo