Skip main navigation

New offer! Get 30% off one whole year of Unlimited learning. Subscribe for just £249.99 £174.99. New subscribers only. T&Cs apply

Find out more

6 Reasons to use Tables in Excel

There are many reason to use tables in Excel, in this article, Paula Guilfoyle summarizes the main reasons.
simple table
© paula guilfoyle
  1. Quick totals. If you need to get totals quickly, convert your data into a table and the totals will be calculated for you.

  2. Quick formatting. You can quickly format a table using predefined formats in the Table Styles gallery.

  3. Simple to sort and filter. Excel’s table function automatically applies filters to the tables. This allows you to quickly sort and select the data you need.

  4. Automatic formula fill down. When you use a table in Excel and add a new row for data entry, any formulas in the above rows will automatically fill down.

  5. Dynamic Charts. If you create a chart based on a table, on refresh the chart will update with the new data.

  6. Quick navigation and selection. Using tables you can quickly navigate around and select rows or columns that you need.

© paula guilfoyle
This article is from the free online

Excel Skills to Make an Impression

Created by
FutureLearn - Learning For Life

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now