Pinterest Pixel

How to Insert an Excel Table

Excel Tables are very powerful and have many advantages when using them.  You should start using them... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

How to Insert an Excel Table | MyExcelOnline How to Insert an Excel Table | MyExcelOnline

Excel Tables are very powerful and have many advantages when using them.  You should start using them asap regardless of the size of your data set, as their benefits are HUUUGE:

1. Structured referencing;
2. Many different built in Table Styles with color formatting;
3. Use of a “Total Row” which uses built in functions to calculate the contents of a particular column;
4. Drop down lists that allows you to Sort & Filter;
5. When you scroll down from the Table, its Headers replace the Column Letters in the worksheet;
6. Remove Duplicate Rows automatically;
7. Summarize the Table with a Pivot Table;
8. Supports calculated Columns so you can create dynamic formulas outside the Table;

How to Insert an Excel Table | MyExcelOnline

Download excel workbookInserting-a-Table1.xlsx

 

STEP 1: Select a cell in your table

How to Insert an Excel Table

STEP 2: Let us insert our table! To do that press Ctrl + T or go to Insert > Table:

How to Insert an Excel Table

 

STEP 3: Click OK.

See also  Dynamic Data Validation List

How to Insert an Excel Table

Your cool table is now ready!

How to Insert an Excel Table

 

Helpful Resource:

Data Bars, Color Scales & Icon Sets

If you like this Excel tip, please share it
How to Insert an Excel Table | MyExcelOnline How to Insert an Excel Table | MyExcelOnline
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...