How can I activate the pivot table list field with the keyboard?

Question

How can I activate the pivot table list field with the keyboard?

Anonymous

Hi!!

Does anybody know which is the shortcut for activating the pivot table list field to check or uncheck fields with space bar.

Thanks for your time

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

3 additional answers

Answer 1

To view the field list you need to click on any of the cell (data cell) within the pivot table and then use the key board shortcut alt+jt+L

To add or remove the fields to the report under the pivot table field list, you have to click on any of the field and use the space bar.

For more help regards to pivot table you may also post in the below forum:

http://social.technet.microsoft.com/Forums/en/excel/threads

Answer 2

Anonymous

Hi Deepa,

Whats JT stand for in your keyboard shortcut.

thanks

0 comments

Answer 3

To view the field list you need to click on any of the cell (data cell) within the pivot table and then use the key board shortcut alt+jt+L

To add or remove the fields to the report under the pivot table field list, you have to click on any of the field and use the space bar.

For more help regards to pivot table you may also post in the below forum:

http://social.technet.microsoft.com/Forums/en/excel/threads

hI DEEPA,

i DONT WANT TO USE MOUSE WHILE WORKING ON PIVOT TABLE..

IF CURSOR IS ON PIVOT TABLE FIELD LIST THEN HOW IT CAN MOVE WITHOUT USE OF MOUSE TO FIELD LIST..

Answer 4

Anonymous

Thank you very much, Deepa. I really appreciate your help.

0 comments

Share via

How can I activate the pivot table list field with the keyboard?

3 additional answers