![how to put filters on pivot tables in excel 2013 how to put filters on pivot tables in excel 2013](https://www.techonthenet.com/excel/pivottbls/images/top10_2013_001.gif)
You will notice two new tabs appear in the ribbon, an Analyze and Design tab.Place the active cell cursor anywhere in the Blank Pivot Table.You will now have a new blank Pivot Table. You can select where you want to create the new pivot table, either in a New Worksheet or you can choose the location in an Existing Worksheet.Your data should be pre-selected and display the name of our table that we named SalesData.Press the Pivot Table button from under the Tables section.Now we can create a Pivot Table based on our data. Under the Properties section type in your new Table Name and press Enter.A new Table Tools tab called Design will appear in the ribbon.The default name of your new table will be Table1, so it’s a good idea to rename it to something more descriptive. Make sure your entire range of your data is selected and ensure the My table has headers option is checked since our data has column headings.Īlternatively, you can avoid using the ribbon commands and use the Ctrl + T keyboard shortcut to create a table.You can read more about the benefits of Excel Tables here.
HOW TO PUT FILTERS ON PIVOT TABLES IN EXCEL 2013 UPDATE
This will make it easier to add data at a later time and update your pivot table in addition to the many other benefits of tables. It’s generally a good idea to turn the data for your pivot table into a Table first. In this tutorial, we’ll take you through the steps to create a new Pivot Table.