Tuesday, March 10, 2009

Excel shortcut of the day - Pivot Tables

How to change a pivot table data field from a "Count Of" to "Sum Of":

1: Alt+P
2: N
3: Tab
4: Up Arrow
5: Enter

No comments:

Tuesday, March 10, 2009