How do I use a keyboard to change a PivotTable or delete a field?

[burtinh@atac.com]

I am trying to test the accessibility of Excel for manually working with
PivotTables. I can't find a way to manipulate the tables using just the
keyboard, and if I place a field (using keyboard or mouse) in a PivotTable, I
can't find a way to delete it or put it back into the PivotTable Field List.
Using the Data menu wasn't any help, either.

And the on-line help doesn't list a way to do either manually.

Any help will be most appreciated.

[Debra Dalgleish]

(As answered at your previous post)

Using the keyboard, select the field button for the field that you want to
hide.

(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 menubars
Press Ctrl + Tab until the PivotTable menubar is activated
The PivotTable menu should be active
Press the right arrow key to open the menu
Press d, to hide the selected field.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


"burtinh@atac.com" wrote:

> I am trying to test the accessibility of Excel for manually working with
> PivotTables. I can't find a way to manipulate the tables using just the
> keyboard, and if I place a field (using keyboard or mouse) in a PivotTable, I
> can't find a way to delete it or put it back into the PivotTable Field List.
> Using the Data menu wasn't any help, either.
>
> And the on-line help doesn't list a way to do either manually.
>
> Any help will be most appreciated.