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

Master those Excel Short Keys, and let me know of your progress.
Later! :D

#excelshortkeys #excelshortcuts

Follow Us
  • Twitter Basic Square
  • Google+ Basic Square
Recent Posts