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.

(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


" 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.