EXCEL TABLES- A Walk Through of using Tables in Excel!
Tags: exceltutorials, stepstocreateexcelta, excel
Published: 2021-11-15 04:13:58

---
title: EXCEL TABLES- A Walk Through of using Tables in Excel!
published: true
date: 2021-11-10 14:50:00 UTC
tags: ExcelTutorials,StepstoCreateExcelTa,Excel
canonical_url: https://geekexcel.com/create-excel-tables-quickly-in-microsoft-excel-365/
---

## Excel Tables:

Generally,  **Excel tables**  are used to manage and analyze the huge data in spreadsheets. It can convert a list of data into the formatted Excel table to make our work easier. It has many features like formatting, editing, filtering, and sorting. These features help us to organize the data.

Let’s jump into this tutorial and learn how to create the  **Excel Tables**  magnificently using various options provided in Excel 365.

## How to Turn the Data into a Table?

First, you need to enter the data in the Excel spreadsheet to create a table.

- For Example, Here, we are going to create a table with Employee details. To do this, you have to include the details like Employee id, name, age, salary below.

![Employee Details](https://geekexcel.com/wp-content/uploads/2020/07/EXCEL_wKJtrKlG6i.png)
_Employee Details_

- Now, you have to turn the data into a table.
- Select any cell in the data range.
- On the ** Insert**  tab, select  **Table**  under the table selection command.
- Check if your entire data range is selected or not.
- Check  **My Table has a headers**  box.
- Hit the  **Ok**  button.

![](https://geekexcel.com/wp-content/uploads/2020/07/create-table.png)

Now, the data are turned to the table format and it will give the result like below.

![](https://geekexcel.com/wp-content/uploads/2020/07/EXCEL_kTa77fS0aU.png)

## How to Name and Style the Table?

To add name and style to the table, follow these steps:

- Go to the  **Table Design**  tab. ( this tab is visible when the cursor is on the table cells )
- On  **the Properties**  tab, type the table name and click  **Enter**  key.
- On the  **Table Styles**  tab, select any style and click  **Ok**.

![Name and style the table](https://geekexcel.com/wp-content/uploads/2020/07/EXCEL_pJgV45XHS7.png)
_Name and style the table_

That’s it, and we have given the name and style to the formatted table.

## How to Add Summary Statistics to the Table?

Here we are going to see how to add summary statistics to the table. Summary statistics are beneficial to reduce our manual work because you don’t need to type individual functions like sum, mean, average. So we can easily make these kinds of calculations.

To do this, you need to follow the instructions given below.

- On the  **Table Design**  tab, Check the  **Table Row**  option under the  **Table Style Options**.
- At the bottom of the Total table, the row has been created. Select any summary formula from the  **Drop-down**   **List**  as per Your wish.

![Add summary statistics to the table](https://geekexcel.com/wp-content/uploads/2020/07/s1.png)
_Add summary statistics to the table_

## How to Sort and Filter the Table?

To Sort and Filter the data in the table, you have to do the following steps.

- On the **Table Design** tab, check the **Filter**  **Button**.
- **Sort and Filter Toggles** will add to each heading in the table.
- Click the **Toggle** in any one of the headings to use the **Sort and Filter Menu**.

![Sorting and filtering the table](https://geekexcel.com/wp-content/uploads/2020/07/s2.png)
_Sorting and filtering the table_

### Note:

You can use  **CTRL + T** shortcut keys to create a table in Excel.

## Closure:

This tutorial clearly understands the  **Steps to Create a Table in Excel 365**  using various options. Kindly share your  **feedback**  in the comment section. Thanks for visiting [**Geek Excel.**](https://geekexcel.com/) Keep Learning!!