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

2002 excel microsoft training - excel pivot tables

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Excel pivot tables

2002 excel microsoft training - Excel pivot tables

ResolvedVersion Standard

Maxime has attended:
Access Intermediate course
Excel Advanced course

Excel pivot tables

Dear all
Is that possible to add more than 6 items in a pivot table?

Thanks for your response

Maxime Bensadoun

RE: excel pivot tables

Yes, just drag the fields onto the Pivot Table

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.