| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display top ten items in an Office 2007 pivot table
In previous versions of Excel there was a sort and top ten feature. Ihave
been able to sort my pivot tabel in 2007, but I cannot find the top ten. Is it still available in this version? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display top ten items in an Office 2007 pivot table
Hi,
It's part of the filtering. Click the dropdown on Row field. Value Filters... Top 10 Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "JaneH" wrote in message ... In previous versions of Excel there was a sort and top ten feature. Ihave been able to sort my pivot tabel in 2007, but I cannot find the top ten. Is it still available in this version? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display top ten items in an Office 2007 pivot table
Thanks Andy,
I searched high and low through all of the ribbons, didn't think to look there!!!! Regards JaneH "Andy Pope" wrote: Hi, It's part of the filtering. Click the dropdown on Row field. Value Filters... Top 10 Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "JaneH" wrote in message ... In previous versions of Excel there was a sort and top ten feature. Ihave been able to sort my pivot tabel in 2007, but I cannot find the top ten. Is it still available in this version? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table - old items | Excel Discussion (Misc queries) | |||
| Display version of Windows office 2007 | Excel Discussion (Misc queries) | |||
| where are the recently viewed items in office 2007? | Excel Discussion (Misc queries) | |||
| how do i display chart equations in office 2007 | Charts and Charting in Excel | |||
| Pivot Table Office 2007 Beta show Top/Bottom features | Excel Discussion (Misc queries) | |||
Linear Mode
