What are Excel Tables and why are they Awesome?

April 14, 2020



If you use Excel to store data, you know about worksheets and how you can organize information with columns and rows.


Did you know Excel has a feature that makes your information easier to navigate with a few clicks?



The awesomeness (aka benefits) of Excel Tables:

What it does

So you can…

Creates filters for each column Quickly sort or filter information


Recognizes data as a set range Automatically expand your data range and formulas when you add new columns and rows
Provides an option to show a total row Make quick calculations in a toggle (e.g., Sum, Average)
Names your Excel table Easily reference data in other worksheets and workbooks


Are you sold?


Here’s the steps to create an Excel table:

  1. Select a cell somewhere in your table
  2. Click Insert > Table (keyboard shortcuts: Ctr+T (Windows) or Cmd + T (Mac))
  3. Confirm the table range (i.e., the cell range to include in the table)
  4. Confirm if your data range includes a header row (i.e., column labels)
  5. Click “ok”
  6. With your table active (i.e., select a cell in the table) use the ‘table’ ribbon to format your table design


To convert back to a data range:

  1. Select a cell somewhere in your table
  2. Click Table > Convert to range

Written By


Director of Evaluation