pivot table

J

James

I have a question on Excel. When I update a pivot table,
I used to be able to hold down the shift and ctrl keys
and highlight the area, but lately I found that I cannot
use this short cut method. Is there another short cut
method? Thanks for your help.
 
D

Debra Dalgleish

In step two of the Pivot Wizard, you should be able to select a starting
cell on the worksheet, then hold the Shift key, and tap the End key,
then the Down or Right arrow key, to select a range of cells.

Or, base the pivot table on a dynamic range, which will expand
automatically as new records are added. There are instructions here:

http://www.contextures.com/xlPivot01.html
 
Top