How to Make a Table in Excel (With Customization)

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.

Here, we will have a data set of products sold in different cities in the month of January with quantity. Data on these sheets are not very significant. We introduced that data so that you can understand it easily.

Download Practice Workbook

Download this practice workbook to exercise while you’re reading this article.

Steps to Make a Table in Excel

We already have an organized range of data and now turn it into a table. Before turning a range of data into a table, remove blank rows and columns, and make sure that a single column doesn’t have different types of data within it. We will show how to make a table and the different facilities of Table.

Step 1:

• Select the cell range that we want to make a table.

Step 2:

• From ribbon select Insert (see point 1 in the following image).
• Then select Table (see point 2 in the following image).
• Tick the My table has headers (see point 3 in the following image).

Step 3:

• Then click OK. And will get the range in Table format.

So, our desired Table is done.

Format an Excel Table Once You Prepare It

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.

Quick Style

We have a quick style option in Table.

Step 1:

• Click on a cell of the table. We will get the Table Design option in the ribbon.

Step 2:

• When clicking on Table Design, we will get Quick Style.
• After clicking Quick Styles we will get a drop-down. From the drop-down select a style.

Table Style Options

We have a quick style option in Table.

Step 1:

• First, click on a cell of the table. We will get the Table Design option in the ribbon.

Step 2:

• When clicking on Table Design, we will get Table Style Options.
• After clicking Table Style Options we will get a drop-down. From the drop-down select different styles.

Read more: How to Edit a Pivot Table in Excel

Table Rename

We can rename our Table from the Table Design tab. The steps are described below.

• First, click on a cell of the table. We will get the Table Design option in the ribbon.
• When clicking on Table Design, we will get Table Name.
• After clicking Table Name, we can change the name and we changed the name to Table1.

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

Similar Readings

• How to Insert A Pivot Table in Excel (A Step-by-Step Guideline)
• Update Pivot Table Range (5 Suitable Methods)
• How to Insert Table in Excel (2 Easy and Quick Methods)
• Insert or Delete Rows and Columns from Excel Table
• How to Sort Multiple Columns of a Table with Excel VBA (2 Methods)

Table Resize

We’ll now resize our Table.

Step 1:

• Click on a cell of the table. We will get the Table Design option in the ribbon.
• When clicking on Table Design, we will get Resize Table.

Step 2:

• After clicking Resize Table we will get a Pop-Up.
• From the Pop-Up change the range. Then press OK.

Filter

We can also apply Filter in Table. Select the Filter button (down arrow sign) and you will get Filter options.

Other Options

We also have the following options like

1. Convert to Range,
2. Export Data,
3. Remove Duplicates

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

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.

Related Articles

• Pivot Table is Not Picking up Data in Excel (5 Reasons)
• Types of Tables in Excel: A Complete Overview
• Convert Table to List in Excel (3 Quick Ways)
• How to Refresh All Pivot Tables in Excel (3 Ways)
• Reference Table Column by Name with VBA in Excel (6 Criteria)
• How to Make an Excel Table Expand Automatically (3 Ways)