Creating a Data Table
This step isn’t necessary to use SUBTOTAL, but it is a good way to set up filtering on a data set. Let’s create one. First, select the table, including the header row that has the data labels.
In the Insert menu tab under the Tables section, click on the Table button to convert the data cells into a table.
In the Create Table dialog that appears, make sure that My table has headers is checked and click OK.
Your data will now be structured in a table, which makes it easy to reference rows, columns, and perform filtering and sorting actions.
Get the latest Excel tips and tricks by joining the newsletter!
Andrew Roberts has been solving business problems with Microsoft Excel for over a decade. Excel Tactics is dedicated to helping you master it. You can read more of his writing on his personal blog at NapkinMath.io.
Join the newsletter to stay on top of the latest articles. Sign up and you'll get a free guide with 10 time-saving keyboard shortcuts!