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.
You can Download around 200 excel shortcuts in PDF
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 |
Usefull and helpfull information.
ReplyDelete