pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables

Pivot tables

resolvedResolved · Medium Priority · Version 2007

Kevin has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Pivot tables

What is the sequence for building a pivot table.

RE: Pivot tables

Hello Kevin

Thank you for your question.

To create a pivot table:
1. Click within the columns of data you wish to be able to use within the pivot table once it has been created (including headings in the first row of the columns).
2. Go to Insert and click PivotTable and Pivot Table again.
3. Select the range of cells you want to include in the pivot table.
5. Select whether you want to create the pivot table in a new worksheet, or in the same worksheet as the data you have selected.
6. The pivot table areas appear on the page.
7. Tick/check the field/s you wish to include in the pivot table.
The fields will appear in the boxes underneath - you can drag and drop the field into different areas of the pivot table by moving fields into different boxes. Fields can be removed by unchecking them in the list of fields provided.

Amanda


 

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips


Server loaded in 0.09 secs.