| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in excel - arrow keys won't work & cursor will not select a cell | Excel Discussion (Misc queries) | |||
| Increasing the Source Data range for an existing Pivot Table | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
| Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
| Cursor keys move active cell or scroll screen, how do I select whi | Excel Discussion (Misc queries) | |||
Linear Mode
