ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot Table Shortcut (https://www.excelbanter.com/excel-programming/406949-pivot-table-shortcut.html)

Beep Beep

Pivot Table Shortcut
 
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


Mark Ivey[_2_]

Pivot Table Shortcut
 
Pilot table or pivot table?

The shortcut for the find dialog box is "CTRL-F".

Mark Ivey


"Beep Beep" wrote in message
...
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


Beep Beep

Pivot Table Shortcut
 
Hi Mark: I know about the "CRTL-F" that we use in the normal excell mode,
however there is another shortcut for when you are working in a pivot table
with the drop down box in the results section (its where you can "SHOW ALL"
or "CANCEL"

THANKS


"Mark Ivey" wrote:

Pilot table or pivot table?

The shortcut for the find dialog box is "CTRL-F".

Mark Ivey


"Beep Beep" wrote in message
...
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



All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com