Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Pivot Tables

Resolved · Low Priority · Version 2007

Reply Wed 13 Aug 2008, 16:38Delegate Sarah said...

Sarah has attended:
Excel Advanced course

Pivot Tables

When the report is filtered and there is more than one selection, is it possible to view the selected filters rather than seeing "multiple items" on the report?

For upcoming training course dates see: Pricing & availability

Reply Mon 8 Sep 2008, 11:04Trainer Mark said...

RE: Pivot Tables

Hi Sarah

How are you doing, sorry its taken me a while to get back to you

Now as far as i'm aware its not possible to display the field information as you would like to require it but what i will do is i will ask another trainer just in case they know stuff i dont

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel articles

· Utilise the web's information banks with Microsoft Excel
· Plug Into The Big Grid
· Backstage Management With Excel 2010
· How To Use The Page Layout Features In Excel 2007 And Excel 2010
· Where Are The Form Controls In Different Versions Of Excel

Please browse our web site to find out more about
microsoft excel training courses and other Microsoft training courses.

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips