![]() |
Using cursor keys to select Pivot Table Source Data Range
Am I missing something, or is it no longer possible to use the cursor keys to
change your Pivot Table's source data range? No rocket science here. I have a data range on one sheet containing 9,000 rows and approximately 30 columns. I create the Pivot Table on another sheet in the same workbook - works fine. If I attempt to change the data range via the Pivot Table Wizard, however, I cannot use the cursor keys to select the new range. Obviously, with 9,000 rows and 30 columns, I would retire before selecting the data range. (I am a BIG user of CTRL+Home, Shift+End, Shift+Home to highlight a large data range) Help! ---- Joe |
All times are GMT +1. The time now is 01:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com