Sorting data in Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Excel2000 and would like to be able to sort the data elements in the
Row section of the pivot table in the order I choose. For example, if I have
3 elements such as Apple, Orange, Cranberry and want them to show in the
pivot in this order I have to name them in the dataset as A. Apple, B.
Orange, C. Cranberry and sort them ascending. Is there a way to do this
without having to stick the A, B, C in front of the data item?

Thx
 
Presumably now the headers show Apple, Cranberry and Orange. Just select the
cell containing the header "Cranberry" and type Orange. You can put them in
any order you want with this technic.
 
That worked beautifully. Thanks!

Myrna Larson said:
Presumably now the headers show Apple, Cranberry and Orange. Just select the
cell containing the header "Cranberry" and type Orange. You can put them in
any order you want with this technic.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASAP bout pivot table 1
How do I sort the the data within a Pivot table (not sum data) 1
PIVOT Table Sorting - PLEASE Help!!!!! 4
SumProduct 3
Multi-column sort issue in Pivot Table 3
Sorting multiple columns (fields) in a pivot table 1
Need running percentage in pivot table 1
How do I stop a Pivot Table from Sorting my data (Excel 2007) 1

Back
Top