How To Make Pivot Table In Excel?

Select your data range

Make sure your data has headers

Click the Insert tab

Click PivotTable

Choose the table or range

Select where to place the PivotTable

Click OK

In the PivotTable Fields pane, drag fields to Rows, Columns, Values, and Filters

Adjust value settings if needed

Format the PivotTable as desired

Suggested for You

Trending Today