ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using cursor keys to select Pivot Table Source Data Range (https://www.excelbanter.com/excel-discussion-misc-queries/157988-using-cursor-keys-select-pivot-table-source-data-range.html)

GuitrDad

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