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

pivot table

ResolvedVersion 2003

Tope has attended:
Excel Intermediate course
Excel Advanced course

PIVOT TABLE

kindly remind me what to click if I want details of transactions in my pivot table to show on seperate sheets and the sheets to be rightly named.

RE: PIVOT TABLE

From the Pivot Table toolbar, click the PivotTable dropdown and select Show Pages

Tue 9 Dec 2008: Automatically marked as resolved.

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

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.11 secs.