Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic excel training - Pivot table ordering

	98.1 % recommend us
	More live stats...

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

Training information:

basic excel training - Pivot table ordering

Resolved · Low Priority · Version Standard

Reply Wed 19 Sep 2007, 14:44Delegate Liz said...

Liz has attended:
Excel Advanced course

Pivot table ordering

Is there anyway to order pivot table headings alphabetically? I understand that you can do bring to beginning etc, but this maybe quicker.
Or a way to do it desending / ascending based on a particular column or row?

Regards,
Liz

For upcoming training course dates see: Pricing & availability

Reply Mon 1 Oct 2007, 15:41Trainer Amanda said...

RE: Pivot table ordering

Hi Liz

Thank you for your question.

Try the following:

1. Double-click on the field you wish to sort by.
2. Click the Advanced button.
3. You will find AutoSort options on the left of the dialogue box that you can use. Select the field you wish to sort by (if possible) and click OK.

Amanda

Excel articles

· The Best Way To Use Clip Art Images In Excel
· Creating A Clearer Picture With Excel
· How To Create An Excel Formula Using Data From Several Worksheets
· Excel in the Home Office
· Excel Offers A More Relaxing Way To Work Out

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips