| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What keystroke(s) drill-down in a PivotTable?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What keystroke(s) drill-down in a PivotTable?
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 wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error ExportPicture in PivotTable | Excel Discussion (Misc queries) | |||
| PivotTable Data Series Formatting | Charts and Charting in Excel | |||
| PivotTable woes | Excel Discussion (Misc queries) | |||
| Sorting in PivotTable | Excel Discussion (Misc queries) | |||
| How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Linear Mode
