Excel: Which Table Should I Use?

Excel Range Tables and Data Tables – Pros and Cons of Each

Range Table: this is the default table that is available when you create a new workbook and add data and numbers to cells. With this method, the user needs to work a bit harder to create formulas, sort, or filter. Although there may be one or more steps to conduct when using a Range Table, it will provide the user with complete control of every cell they wish to manage.

Data Table: A data table is a range of cells that shows how changing one or two variables in your formulas will affect the results of those formulas. Data tables provide a shortcut for calculating multiple results in one operation and a way to view and compare the results of all the different variations together on your worksheet. Although there are benefits to formatting, sorting, filtering, and working with formulas, the user must be aware of the behavior of Data Tables; otherwise, frustration may occur. To learn more about why Data Tables are beneficial, click here.

Click here to learn how to convert a Data Table to a Range Table.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.