Click and Drag to highlight the data you want to include in your pivot table.
2
Click on Insert
3
Click on PivotTable Show More Options
4
Click on From Table/Range
5
Click on Existing sheet or New Sheet if you'd like your pivot table to show on a new sheet.
6
Click on Insert
7
click to select which data you want to include in your pivot table.
8
Select from the pulldown menu where you want to put your selected data. These are your choices.
9
Continue selecting any more data you want to include.
10
And indicating where you would like that data place in your pivot table.
Well done!
Create how-to guides like this in a snap. Get Tango now.
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key
