Skip main navigation

£199.99 £139.99 for one year of Unlimited learning. Offer ends on 28 February 2023 at 23:59 (UTC). 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

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education