EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Tables in Excel
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Tables in Excel

By Madhuri ThakurMadhuri Thakur

Excel Table

Table of Contents

  • Introduction to Excel Table
  • How to Create Tables in Excel?
  • Steps for Customizing Excel Table

Introduction to Excel Table

Tables in Excel are beneficial for giving a structure to data sets. It has handy features from arranging the data, providing the headers along with applied filters. We can access tables from the Insert menu tab or select shortcut key Ctrl + T. For this, we just need to select the range of cells that we need to include in the table. We can even change Table styles from the Design tab, which will appear once we select the table.

Steps need to be done before creating tables in Excel:

  • First, remove all blank rows and columns from the data.
  • All the column headings should have a unique name.

How to Create Tables in Excel?

It is effortless and easy to create. Let’s understand the working of the tables with some examples.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

You can download this Excel Table Template here – Excel Table Template

Let’s take company employee data.

Excel Table Employer table

Check the data as it should not have any empty rows or columns. Put the cursor anywhere in the data and press the shortcut keys CTRL+T. It will open a dialog box.

press the shortcut keys

Make sure that checkbox My table has headers is ticked. It considers the first row as a header. And then click, Ok.

Excel Table Example 1-3

After clicking on OK, it will create a table like the below screenshot.

create details

As we can see that along with the table, it will also open a separate Table tools design window. With the help of this, we can customize our table.

customize data

Steps for Customizing Table in Excel

  • Table Name

Automatically excel provides a default name. If it’s the first table, it will assign the table name as Table1. In our example, Excel gives the table name as Table2.

Design Table 2

We can change this name according to the data so that we can use it further.

Go to the Table Names field in the Design window.

Design window

Write the name of the table.

In our example, we are giving the table name as Emp_Data. Refer to the below screenshot:

Excel Table emp data

  • Table Color

We can add the colour to the table. Click on the Table Styles section under the Design tab and choose the colour accordingly. Refer to the below screenshot:

Excel Table (click o n table styles)

So the Output will be:

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,768 ratings)

Excel Table Step 2-2

Benefits of Excel Table

  • If we have more than one Table, we can easily navigate between them. The Name Box drop-down shows all the table names here, and we can choose accordingly.

Emp data

  • When new rows or columns are added to the table, It automatically expands with the existing feature.
  • It gives an additional feature, Total Row. The Total Row option can be easily performed SUM, COUNT etc., operations.

For this facility, click anywhere in the table and press shortcut key CTRL+SHIFT+T… Refer to the below screenshot:

press shortcut key

  • Click on Total. It will show a drop-down list of various mathematical operations.

mathematical operations

Note: In our example, there is no numeric data; hence it’s showing the total no. of records in the table.

  • With the help of an Excel table, we can easily create a Pivot Table. Click anywhere in the table and choose the Summarize with Pivot Table option under the Tools section. Refer to the below screenshot:

Summarize with Pivot Table

  • After clicking on this, It will open a dialog box “Create Pivot Table”.

create pilot table

It provides all the facilities of the Pivot Table.

Things to Remember

When assigning the table name, the below points should be kept in mind.

  • There should be no space in the table name.
  • The table name can be the combination of words, but only underscore can be used while joining the words.
  • Table name should not start with any special character.
  • The table name should be unique if there are more than two tables.
  • It should start with alphabetic, and the maximum length should be within 255 characters.

Recommended Articles

This has been a guide to Tables in Excel. Here we discuss its uses, advantages, and how to create Excel Tables along with an example and downloadable excel template. You can also go through our other suggested articles –

  1. Lookup Table in Excel
  2. Compare Dates in Excel
  3. Excel Merge Two Tables
  4. Excel Conditional Formatting in the Pivot Table
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Excel Table Template

EDUCBA

Download Excel Table Template

EDUCBA

डाउनलोड Excel Table Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more