Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I can't remember the shortcut for when you are in a pilot table (results) and
you pull up the drop down box that says (show all) fields. It seems that there is a shortcut starting with the shift key that opens up a find box so you just type in the one you are looking for |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you select a cell that contains a pivot table field button, you can
press Alt and the Down arrow key to open the list. Then, use the navigation keys to move through the list. Use the space bar to add or remove check marks Press Enter or Esc to close the list Beep Beep wrote: I can't remember the shortcut for when you are in a pilot table (results) and you pull up the drop down box that says (show all) fields. It seems that there is a shortcut starting with the shift key that opens up a find box so you just type in the one you are looking for -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pivot table shortcut key | Excel Discussion (Misc queries) | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
keyboard shortcut doesn't work on data area of pivot table | Excel Discussion (Misc queries) |