Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2005

Tip: Looking for answers? Try searching our database.

Transition Navigation Keys in Pivot Tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
consulttech2004@hotmail.com - 24 Jun 2005 18:22 GMT
In Excel 2003, I have set Tools > Options > Transition > Transition
Navigation Keys to "on".  The shortcut keys for highlighting a
contiguous range of data work fine EXCEPT for when I am in the pivot
table wizard.

If I have already created a pivot table, and I decide to change the
range of my data, and I hit the "Back" button in the wizard to change
the data range that the pivot table draws from, I cannot use the arrow
key shortcuts (although I can use the mouse.)  When I am not in the
pivot table wizard, the shortcut navigation keys work correctly.

Does anyone else experience this issue?

Please feel free to respond to me directly.  Thank you.

David
consulttech2004@hotmail.com
Debra Dalgleish - 25 Jun 2005 12:39 GMT
If you right-click on the PivotTable, and choose Wizard, the arrow keys
won't work.

However, if you click the PivotTable button on the Pivot toolbar, and
choose PivotTable Wizard, the shortcut keys WILL work when selecting the
range.

> In Excel 2003, I have set Tools > Options > Transition > Transition
> Navigation Keys to "on".  The shortcut keys for highlighting a
[quoted text clipped - 13 lines]
> David
> consulttech2004@hotmail.com

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.