G
GuitrDad
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!
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!