What keystroke(s) drill-down in a PivotTable?

G

Guest

I have been unable to find a keyboard shortcut in Excel for drilling-down in
a PivotTable. I am trying to address accessibility issues, and I believe this
is the last one I have. I have checked the on-line help and the Website. Any
help will be most appreciated.
 
D

Debra Dalgleish

There's no built-in shortcut, but you can do the following:

Using the keyboard, select the item for which you want detail

(You could record a macro, and assign a keyboard shortcut, to make the
following steps easier to repeat later.)

Press the F10 key, to activate the menu bars
Press Ctrl + Tab until the PivotTable menu bar is activated
Use the arrow keys to move to the Show Detail button
Press the Enter key
 

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

How do I use a keyboard to change a PivotTable or delete a field? 1
Difference column in PivotTable 1
VB Error when AutoFiltering a Pivottable 1
Creating a PivotTable w/o selecting data in an existing PivotTable 6
Drill Down in PivotTables 2
Drill-Down 2
Convert a square of data into a PivotTable? 1
Drill Down Features 2

Top