Keyboard Shortcuts in Excel to Sort, Add, Hide Pivot Table Items and Fields

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

Comments (5)

Prepare Dashboard Using Excel : Shortcuts in Excel

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

Comments