Posted on 03 December 2009
Here are some quick keyboard shortcuts in Excel to help you survive in the
pivot table jungle.
Keyboard shortcut to Sort Fields and Items in a Pivot Table
Thought that you would have to drag the field or the item across the pivot table using the mouse. Hold on - you can use the keyboard too.
Simply type the field or the item ...
Continue Reading
Posted on 22 August 2008
Also useful would be to arm yourself with some shortcuts, they can be a ton of help when working with large amounts of data. The idea is to just work with the keyboard without having to use the mouse....things work much faster that way.
Basic (and necessary)
Cut Ctrl + x
Copy = Ctrl + c
Paste = Ctrl + v
Minimize all = WinKey + m
Move to first row = Home
Move to last row = End
Ctrl + ...
Continue Reading