ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Transition Navigation Keys in Pivot Tables (https://www.excelbanter.com/setting-up-configuration-excel/32359-transition-navigation-keys-pivot-tables.html)

[email protected]

Transition Navigation Keys in Pivot Tables
 
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




All times are GMT +1. The time now is 01:39 AM.

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