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.

Dataset how ta make table in Excel


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

Ribbon options to make table

Step 3:

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

Table created

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.

How to go quick style option

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.

Quick style options


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.

How to table style option

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.

Table style options

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.

Rename in table

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


Similar Readings


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.

How to table resize option

Step 2:

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

Table resize process


Filter

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

Filter option in table

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

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