25 Excel Short Keys To Improve Speed
If you want to be Bob Munden at Excel, use the Keyboard.. As simple as that!
If you observe most of the people that are good with Excel, you would hardly find them using the mouse, that’s because, the mouse slows you down.. Way more than you think!
Well, lets be honest! You cant avoid using the mouse completely, but you can surely keep its use to a minimum by learning some of the most used Excel Short Keys.
Excel has hundreds of Short Keys, probably thousands, and memorizing them all is impossible, and honestly speaking memorizing them all isn’t really necessary.
The key is, only memorize those that are used by you regularly.
I have prepared a list of 25 such Excel Short keys which according to me will be used by any Excel user in any given arrangement.
Crtl + C/X/V – Copy/Cut/Paste
Shift + Space Bar – Selects the Whole Row
Crtl + Space Bar – Selects the Whole Column
Ctrl + -/+ – Delete/Insert Row or Column
F2 – To Edit Active Cell
Alt + N > V > T – Inserts Pivot Table (Changed to Alt + N > V in Excel 2013 Version)
Alt + O > D – Displays Conditional Formatting Rules Manager Dialogue Box
Ctrl + T – Activates the Table Feature
Ctrl + Enter – Populates same data/formula in selection of cells
Ctrl + Z/Y – Undo/Redo last action
Ctrl + F/H – Displays the Find/Replace dialog box
Ctrl + G – Displays the GoTo dialog box
Ctrl + F2 – Print Preview
Ctrl + D/R – Copies the Uppermost/leftmost cell in the selection to the bottom/right
Ctrl + 1 – Displays Format Cells Dialogue Box
Alt + Enter – When in Edit Mode, enters a new line in the cell
Ctrl + ; – Enters the current date into the active cell
Ctrl + Shift + ; – Enters the current time into the active cell
Ctrl + PgUp/PgDown – Moves Up & Down between worksheets of a workbook
Ctrl + Shift + F3 – Create names from selection
F3 – Paste Names
Ctrl + Shift + L – Activates/De-activates Auto Filter
Alt + D > L – Displays Data Validation Dialogue Box
Alt + = – Auto Sum
F12 – Displays Save As Dialogue Box