Subscribe for New Post Notifications

Microsoft Excel Shortcut keys

MS Excel shortcuts keys, when starting with Microsoft Excel, knowing a few MS excel shortcut keys will reduce your work time and make it easier to work on Excel. Using the mouse to do the entire task reduces your productivity.

Here are a Top 50 shortcuts to use when you just begin working with Microsoft Excel. These MS Excel shortcuts for beginner works with all versions of MS Excel 2003, MS Excel 2007, MS Excel 2010, MS Excel 2013.

In this blog, you will learn how to use basic excel shortcuts. Also you can download around 200 excel shortcuts in PDF.

Below is a listing of shortcuts keys and key combinations usable in Microsoft Excel.


Excel Shortcut To do this
F2 Edit the selected cell
F5 Go to a specific cell
F7 Spelling check selected text or document
F12 Save As option
Ctrl + 9 Hide Rows
Ctrl + 0 Hide Columns
Ctrl + + Inserts a new cell, column or row
Ctrl + - Deletes the selected column or row
Ctrl + A Select all contents of a worksheet
Ctrl + B Bold all cells in the highlighted section
Ctrl + C Copy all cells in the highlighted section
Ctrl + F Open find and replace options
Ctrl + I Italicize on all cells in the highlighted selection
Ctrl + N Creates a new workbook
Ctrl + O Open a workbook option
Ctrl + P Open print dialog box
Ctrl + S Save the open workbook
Ctrl + T Create table
Ctrl + U Underline all cells in the highlighted selection
Ctrl + V Paste everything copied
Ctrl + X Cuts all cells in the highlighted section
Ctrl + Z Undo the last action
Ctrl + ; Enter the current date
Ctrl + Shift + ; Enter the current time
Shift + F10 Display shortcut menu
Shift + F12 Save the open workbook
Alt + F1 Insert Chart
Alt + F2 Save As option
Alt + F11 Open the Visual Basic Editor
Alt + = Create formula to sum all of above cells
Alt + Downarrow Display Cell List
Ctrl + Shift + L Filter
Ctrl + Shift + ) Unhide columns
Ctrl + Shift + ( Unhide rows
Ctrl + Alt + V Paste Special option
Alt + A + A Sort A -> Z
Alt + A + D Sort Z -> A
Alt + A + E Text to Column
Alt + A + M Remove Duplicates
Alt + E + A + A Clear All
Alt + H + FP Format Painter
Alt + H + W Wrap Text
Alt + H + A + C Align text to Center
Alt + H + B + A Border All
Alt + H + L + H + D Highlight Duplicates
Alt + N + V + C Insert Pivot Chart
Alt + N + V + T Insert Pivot Table
Alt + O + C + A Adjust Column width accoedingly
Alt + R + C Insert New Comment
Alt + W + F + F Freeze Panes

You can Download around 200 excel shortcuts in PDF
Download

2 comments: