Note that the 'Analyze' tab is only visible if you have clicked into the interior of PivotTable1. Make sure the background is dark grey by clicking on 'Field List'. If you still don't see the PivotTable fields, you need to check the 'Show' group of the 'Analyze' tab to make sure 'Field List' is selected. If you do not see this, click into the interior of the PivotTable on the left-hand side of the worksheet. This is where you will find your available PivotTable fields and the four areas you can place them. You should also see something new on the right edge of this worksheet. It might not look like much, but we have created our PivotTable. Then leave the PivotTable placement option on the default 'New Worksheet' and click OK.Įxcel then opens a new worksheet and places our PivotTable there. That is why we make sure there are no blank rows before we start. You can change this if necessary, but as long as your source data is an adjacent range, it should be correct. Note that it pre-selects your data and shows the range in the top section of the wizard. The Create PivotTable wizard should appear. Once there, find the 'Tables' group and click 'PivotTable'. Now simply click on one of the cells in the source data and click on the 'Insert' tab. To quickly remove these go to Home > Find> GoTo Special > Blanks > Delete Rows. We need to prep our worksheet to make sure it consists of adjacent data. In the above spreadsheet, the blank row at line 17 would be a problem. That is not to say you cannot have some blank cells, but an entire blank row will cause problems. Make sure your source data has no blank rows. Though you can filter data in this table, we're about to see how PivotTable can make things much more efficient. Notice that all the rows do not fit on the current page – now imagine there were even more columns. This is a simple data set, but large enough with which to work. We've also provided the worksheet shown in the examples so you can follow each step as you read.įirst, imagine a simple dataset like the following.
#How to use filters in pivot tables in excel 2013 how to
We will also cover the basics of how to view the same data in different ways using the PivotTable feature. (Note: PivotTable is the trademarked term for Microsoft Excel's pivot table function)īy the time you finish this article, you should have a firm grip on how to create a pivot table in Excel. If you have never used pivot tables in Excel or would like to build on your basic knowledge, you're in the right place. It allows you to analyse and visualise data in various ways that can provide deep insights. The PivotTable function is one of the most widely used features of Microsoft Excel.