close

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.

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:
gt; I have been unable to find a keyboard shortcut in Excel for drilling-down in
gt; a PivotTable. I am trying to address accessibility issues, and I believe this
gt; is the last one I have. I have checked the on-line help and the Website. Any
gt; help will be most appreciated.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()