Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot table shortcut key Raja Excel Discussion (Misc queries) 4 May 18th 23 11:42 AM
how to create pivot table from existing pivot table in excel 2007 Udayraj Dhulekar Excel Discussion (Misc queries) 2 July 8th 13 08:22 PM
Pivot Table Shortcut Beep Beep Excel Discussion (Misc queries) 1 March 1st 08 04:43 PM
Filter lines containing pivot table and non pivot table data Grover Excel Worksheet Functions 0 September 24th 07 07:20 PM
keyboard shortcut doesn't work on data area of pivot table TrevorM Excel Discussion (Misc queries) 0 February 24th 06 11:48 AM


All times are GMT +1. The time now is 03:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"