| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change order of rows in pivot table?
The excel pivot table tutorial shows regions as rows in alphabetical order.
I understand I can use the sort command to reverse that order, but how do I specify the order of the regions as north, south, east, west? Thanks. - greg |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change order of rows in pivot table?
click on south, hold the left key on the mouse and drag South below North and
release the key. Now South should be below north. hope this helps. Nikki "greghenry" wrote: The excel pivot table tutorial shows regions as rows in alphabetical order. I understand I can use the sort command to reverse that order, but how do I specify the order of the regions as north, south, east, west? Thanks. - greg |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change order of rows in pivot table?
Oh. That was too easy, huh? Thanks!
-- - greg "Nikki" wrote: click on south, hold the left key on the mouse and drag South below North and release the key. Now South should be below north. hope this helps. Nikki "greghenry" wrote: The excel pivot table tutorial shows regions as rows in alphabetical order. I understand I can use the sort command to reverse that order, but how do I specify the order of the regions as north, south, east, west? Thanks. - greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select all subtotal rows on Pivot Table | Excel Worksheet Functions | |||
| Pivot Chart won't save order change of data | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| Pivot Tables & not printing blank rows (revisited) | Excel Discussion (Misc queries) | |||
| Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
Hybrid Mode
