iYogi, Inc. BBB Business Review

jeanie-engles

I need help in creating a Pivot Table on a work sheet in Microsoft Excel 2007. Please help.

asked on 12th Aug 2011 | 1 Answers | Answer It!


uttam

Its quite simple to create a Pivot table. Please follow these steps:

• First select any cell in the worksheet that contains the data you want to create the report on. Then under the Insert tab click on the PivotTable button.
• The PivotTable dialog box opens and the table or data range we already selected will show in that field. The PivotTable Field List opens up and the PivotTable tools become available.
• Select the fields you want to include in the table by dragging them to the different boxes
• You can arrange the view of the PivotTable Field list so it works best for you


Here’s to Good Karma

More Q & A, Solutions and Videos
will answer your tech questions for FREE
Here's to Good Karma

I have problem with:


LaptopDesktopPeripherals