ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table shortcut key (https://www.excelbanter.com/excel-discussion-misc-queries/233143-pivot-table-shortcut-key.html)

mrmnz

Pivot Table shortcut key
 
When I am in a Pivot Table, and I select a dropdown box showing all our
customers, is there a way of putting a tick in the box of the selected
customer using shortcut keys? I have tried alt+down arrow but all that does
is close the dropdown box.

It is annoying having to keep getting the mouse and clicking to put a tick
in the box.

Thanks.

Marian

Jacob Skaria

Pivot Table shortcut key
 
Try space-bar..

(Do you have another post)..

If this post helps click Yes
---------------
Jacob Skaria


"mrmnz" wrote:

When I am in a Pivot Table, and I select a dropdown box showing all our
customers, is there a way of putting a tick in the box of the selected
customer using shortcut keys? I have tried alt+down arrow but all that does
is close the dropdown box.

It is annoying having to keep getting the mouse and clicking to put a tick
in the box.

Thanks.

Marian



All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com