tech on the net
Home About Us Feedback Site Map


Access Excel Word


SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker


C Language


ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

MS Excel: Create a pivot table in Excel 2003/XP/2000/97

See solution in other versions of Excel:

Question: How do I create a pivot table in Microsoft Excel 2003/XP/2000/97?

Answer: We'll start by creating a very simple pivot table. The example that follows has been done in Excel 2000, so the screen may look different if you are using a different version of Excel. Either way, it will give you a basic understanding of pivot tables.

First, our data that we want to use to populate the pivot table resides on Sheet1.

Microsoft Excel

Under the Data menu, select "PivotTable and PivotChart Report".

Microsoft Excel

A PivotTable wizard should appear. Make sure that the "Microsoft Excel list or database" and "PivotTable" options are chosen. Click on the Next button.

Microsoft Excel

Select the range of data for the pivot table and click on the Next button. In this example, we've chosen data from Sheet1.

Microsoft Excel

Select the position to create the new pivot table. It will automatically default to the cell that was highlighted when you started this process. In this example, we want to create our pivot table on Sheet2 in cell A1.

Click on the Layout button.

Microsoft Excel

Now drag the fields that you want to appear in the Page, Row, Column, and Data sections of the pivot table. In this example, we've dragged the Order ID field to the Row section and the Quantity to the Data section.

Click on the OK button to continue.

Microsoft Excel

Now click on the Finish button.

Microsoft Excel

Your pivot table should now appear on Sheet2. What this pivot table displays is the total quantity for each order ID.

Microsoft Excel