How To

How to Use the Pivot Table Wizard in Excel 2003

Contributor
By eHow Contributing Writer
(0 Ratings)

Excel 2003's "PivotTable Wizard" can organize hundreds of rows of data in seconds. The wizard will set up a pivot table in several easy steps, described here.

Difficulty: Moderately Easy
Instructions

Things You'll Need:

  • Microsoft Excel 2003
  1. Step 1

    Open your Excel worksheet. Under “Data” on the toolbar, select “PivotTable” in the dropdown menu.

  2. Step 2

    In the “PivotTable Wizard” box, select the data you want to analyze by clicking on the corresponding radio buttons. Click “Next.”

  3. Step 3

    In the next screen, select the "range" you want to analyze. To define the range, drag your left mouse over the cells you want sorted. Click “Next.”

  4. Step 4

    In the final screen, select whether you want the pivot table to appear in a new worksheet or an existing one.

  5. Step 5

    Click “Finish” to insert the pivot table. Save your work.

Tips & Warnings
  • Before creating a pivot table, select the cells you want to organize.

Post a Comment

Post a Comment
  • Have you done this? Click here to let us know.
I Did This

Related Ads

Computers
Alexia Petrakos,

Meet Alexia Petrakos eHow's Computers Expert.

Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US

eHow Computers
eHow_eHow Technology and Electronics