Step 1. Make sure your pivot table is updated with any changes made in the data table by clicking the "!" button (exclamation point button) on the pivot table toolbar. Video of the Day. Click inside the pivot table to display the field list. If it doesn’t pop up, right-click the pivot table and choose Show Field List from the bottom of the resulting submenu. In the field list Learn what a PivotTable is, how to create and use it in all versions of Excel, and see examples of how to summarize, filter, sort, and format data with Pivot Tables. Follow the step-by-step guide with screenshots and tips to make and customize your own Pivot Table reports. Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel. Pivots allow you to quickly explore and analyze raw data in Excel, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you're exploring product sales, analyzing which marketing tactics drove First, go to the Insert Tab > Tables > Pivot Table > From Table/Range. Or you can also use the keyboard shortcut Alt > N > V > T. It will open the “PivotTable from table or Range” dialog box to select the range or table. When you open the dialog box, it automatically selects the range or the table. As soon as you click the above option, Excel selects the Entire Pivot Table. Press “Ctrl + C” to copy the selected Pivot Table. You can also Right-click on the Pivot Table and select the “Copy” to copy the Pivot Table. When you copy the Pivot Table, you’ll see green color dotted lines go around the Pivot Table. nYgZV.
