Excel Shortcuts Complete List

The most comprehensive list of Excel Shortcuts

This Excel Shortcuts Complete list  is to help you become save time and use Excel like a Master level user.  Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.

I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.

The most comprehensive list of Excel Shortcuts



Shortcut key                                   Action


 Ctrl+A                                              Select All


Ctrl+B                                             Bold


Ctrl+C                                             Copy


Ctrl+D                                             Fill Down


Ctrl+F                                              Find


Ctrl+G                                             Goto


Ctrl+H                                             Replace


Ctrl+I                                               Italic


Ctrl+K                                             Insert Hyperlink


Ctrl+N                                             New Workbook



Ctrl+O                                             Open


Ctrl+P                                              Print


Ctrl+R                                             Fill Right


Ctrl+S                                              Save


Ctrl+U                                             Underline


Ctrl+V                                             Paste


Ctrl W                                             Close


Ctrl+X                                             Cut


Ctrl+Y                                             Repeat


Ctrl+Z                                              Undo



F1                                                     Help


F2                                                     Edit


F3                                                     Paste Name


F4                                                     Repeat last action


F4                                                     While typing a formula, switch between absolute/relative refs


F5                                                     Goto


F6                                                     Next Pane



F7                                                     Spell check


F8                                                     Extend mode


F9                                                     Recalculate all workbooks


F10                                                   Activate Menubar


F11                                                   New Chart


F12                                                   Save As


Ctrl+:                                               Insert Current Time


Ctrl+”                                              Copy Value from Cell Above


Ctrl+’                                               Copy Formula from Cell Above


Shift                                                 Hold down shift for additional functions in Excel’s menu


Shift+F1                                          What’s This?


Shift+F2                                          Edit cell comment



Shift+F3                                          Paste function into formula


Shift+F4                                          Find Next


Shift+F5                                          Find


Shift+F6                                          Previous Pane


Shift+F8                                          Add to selection


Shift+F9                                          Calculate active worksheet


Ctrl+Alt+F9                                    Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.


Ctrl+Alt+Shift+F9                          Rechecks dependent formulas and then calculates all cells in all open workbooks,including cells not marked as needing to be calculated.


Shift+F10                                        Display shortcut menu



Shift+F11                                        New worksheet


Shift+F12                                        Save


Ctrl+F3                                            Define name


Ctrl+F4                                            Close


Ctrl+F5                                            XL, Restore window size


Ctrl+F6                                            Next workbook window


Shift+Ctrl+F6                                 Previous workbook window


Ctrl+F7                                            Move window


Ctrl+F8                                            Resize window


Ctrl+F9                                            Minimize workbook


Ctrl+F10                                          Maximize or restore window


Ctrl+F11                                          Inset 4.0 Macro sheet


Ctrl+F12                                          File Open



Alt+F1                                             Insert Chart


Alt+F2                                             Save As


Alt+F4                                             Exit


Alt+F8                                             Macro dialog box


Alt+F11                                           Visual Basic Editor


Ctrl+Shift+F3                                 Create name by using names of row and column labels


Ctrl+Shift+F6                                 Previous Window


Alt+Shift+F1                                   New worksheet


Alt+Shift+F2                                   Save


Alt+=                                                AutoSum


Ctrl+`                                               Toggle Value/Formula display


Ctrl+Shift+A                                   Insert argument names into formula



Alt+Down arrow                            Display AutoComplete list


Alt+’                                                 Format Style dialog box


Ctrl+Shift+~                                    General format


Ctrl+Shift+!                                    Comma format


[email protected]                                  Time format


Ctrl+Shift+#                                    Date format


Ctrl+Shift+$                                    Currency format


Ctrl+Shift+%                                  Percent format


Ctrl+Shift+^                                   Exponential format


Ctrl+Shift+&                                  Place outline border around selected cells


Ctrl+Shift+_                                    Remove outline border



Ctrl+Shift+*                                    Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report.


Ctrl++                                              Insert


Ctrl+-                                               Delete


Ctrl+1                                              Format cells dialog box


Ctrl+2                                              Bold


Ctrl+3                                              Italic


Ctrl+4                                              Underline



Ctrl+5                                              Strikethrough


Ctrl+6                                              Show/Hide objects


Ctrl+7                                              Show/Hide Standard toolbar


Ctrl+8                                              Toggle Outline symbols


Ctrl+9                                              Hide rows


Ctrl+0                                              Hide columns


Ctrl+Shift+(                                    Unhide rows


Ctrl+Shift+)                                    Unhide columns


Alt or F10                                        Activate the menu


Ctrl+Tab                                         In toolbar: next toolbar


Shift+Ctrl+Tab                               In toolbar: previous toolbar


Tab                                                  Next tool


Shift+Tab                                        Previous tool



Enter                                                Do the command


Alt+Enter                                        Start a new line in the same cell.


Ctrl+Enter                                      Fill the selected cell range with the current entry.


Shift+Ctrl+F                                   Font Drop Down List


Shift+Ctrl+F+F                              Font tab of Format Cell Dialog box


Shift+Ctrl+P                                   Point size Drop Down List


Ctrl+Spacebar                                Select the entire column


Shift+Spacebar                               Select the entire row


CTRL+/                                           Select the array containing the active cell.


CTRL+SHIFT+O                          Select all cells that contain comments.



CTRL+\                                           In a selected row, select the cells that don’t match the formula or static value in the active cell.


CTRL+SHIFT+|                             In a selected column, select the cells that don’t match the formula or static value in the active cell.


CTRL+[                                          Select all cells directly referenced by formulas in the selection.


CTRL+SHIFT+{                            Select all cells directly or indirectly referenced by formulas in the selection.


CTRL+]                                          Select cells that contain formulas that directly reference the active cell.


CTRL+SHIFT+}                            Select cells that contain formulas that directly or indirectly reference the active cell.


ALT+;                                             Select the visible cells in the current selection.



SHIFT+BACKSPACE                  With multiple cells selected, select only the active cell.


CTRL+SHIFT+SPACEBAR       Selects the entire worksheet. If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet. When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet


Shortcut key                                   Action


Ctrl+A                                             Select All


Ctrl+B                                             Bold


Ctrl+C                                             Copy


Ctrl+D                                             Fill Down


Ctrl+F                                              Find


Ctrl+H                                             Replace


Ctrl+I                                               Italic


Ctrl+K                                             Insert Hyperlink


Ctrl+N                                             New Workbook


Ctrl+O                                             Open


Ctrl+P                                              Print


Ctrl+R                                             Fill Right


Ctrl+S                                              Save



Ctrl+U                                             Underline


Ctrl+V                                             Paste


Ctrl W                                             Close


Ctrl+X                                             Cut


Ctrl+Y                                             Repeat


Ctrl+Z                                              Undo


F1                                                     Help


F2                                                     Edit


F3                                                     Paste Name


F4                                                     Repeat last action


F4                                                     While typing a formula, switch between absolute/relative refs


F5                                                     Goto


F6                                                     Next Pane



F7                                                     Spell check


F8                                                     Extend mode


F9                                                     Recalculate all workbooks


F10                                                   Activate Menubar


F11                                                   New Chart


F12                                                   Save As


Ctrl+:                                               Insert Current Time


Ctrl+;                                               Insert Current Date


Ctrl+”                                              Copy Value from Cell Above


 Ctrl+’                                               Copy Formula from Cell Above


Shift                                                 Hold down shift for additional functions in Excel’s menu


Shift+F1                                          What’s This?


Shift+F2                                          Edit cell comment


Shift+F3                                          Paste function into formula


Shift+F4                                          Find Next


Shift+F5                                          Find



Shift+F8                                          Add to selection


Shift+F9                                          Calculate active worksheet


Ctrl+Alt+F9                                    Calculate all worksheets in all open workbooks, regardless of whether they have                                                                    changed since the last calculation.


Ctrl+Alt+Shift+F9                          Rechecks dependent formulas and then calculates all cells in all open workbooks,                                                                including cells not marked as needing to be calculated.


Shift+F10                                        Display shortcut menu


Shift+F11                                        New worksheet


Shift+F12                                        Save



Ctrl+F3                                            Define name


Ctrl+F4                                            Close


Ctrl+F5                                            XL, Restore window size


Ctrl+F6                                            Next workbook window


Shift+Ctrl+F6                                Previous workbook window


Ctrl+F7                                            Move window



Ctrl+F8                                            Resize window


Ctrl+F9                                            Minimize workbook


Ctrl+F10                                          Maximize or restore window


Ctrl+F11                                          Inset 4.0 Macro sheet


Ctrl+F12                                          File Open


Alt+F1                                             Insert Chart


Alt+F2                                             Save As


Alt+F4                                             Exit


Alt+F8                                             Macro dialog box


Alt+F11                                           Visual Basic Editor




Ctrl+Shift+F3                                 Create name by using names of row and column labels


Ctrl+Shift+F6                                 Previous Window


Ctrl+Shift+F12                               Print


Alt+Shift+F1                                   New worksheet


Alt+Shift+F2                                   Save


Alt+=                                                AutoSum


Ctrl+`                                               Toggle Value/Formula display


Ctrl+Shift+A                                   Insert argument names into formula


Alt+Down arrow                            Display AutoComplete list


Alt+’                                                 Format Style dialog box


Ctrl+Shift+~                                    General format


Ctrl+Shift+!                                    Comma format




Ctrl+Shift+#                                    Date format


Ctrl+Shift+$                                    Currency format


Ctrl+Shift+%                                  Percent format


Ctrl+Shift+^                                   Exponential format


Ctrl+Shift+&                                  Place outline border around selected cells


Ctrl+Shift+_                                    Remove outline border


Ctrl+Shift+*                                    Select current region


Ctrl++                                              Insert


Ctrl+-                                               Delete


Ctrl+1                                              Format cells dialog box


Ctrl+2                                              Bold


Ctrl+3                                              Italic



Ctrl+4                                              Underline


Ctrl+5                                              Strikethrough


Ctrl+6                                              Show/Hide objects


Ctrl+7                                              Show/Hide Standard toolbar


Ctrl+8                                              Toggle Outline symbols


Ctrl+9                                              Hide rows


Ctrl+0                                              Hide columns


Ctrl+Shift+(                                    Unhide rows


Ctrl+Shift+)                                    Unhide columns


Alt or F10                                        Activate the menu


Ctrl+Tab                                         In toolbar: next toolbar


Shift+Ctrl+Tab                           In toolbar: previous toolbar


Ctrl+Tab                                         In a workbook: activate next workbook


Shift+Ctrl+Tab                            In a workbook: activate previous workbook


Tab                                                    Next tool


Shift+Tab                                        Previous tool


Enter                                                Do the command


Alt+Enter                                        Start a new line in the same cell.


Ctrl+Enter                                      Fill the selected cell range with the current entry.


Shift+Ctrl+F                                   Font Drop Down List


Shift+Ctrl+F+F                              Font tab of Format Cell Dialog box


Shift+Ctrl+P                                   Point size Drop Down List



Spending too much time in excel? Find out how you can save time with these handy keyboard shortcuts




Our Other Services




Read Free Ebooks

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!



Buy Excel Course

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788



Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!


Download Excel Crash Course


This Excel Crash Course contains the list of topics that cover the most important and used features and formula of Excel . This Excel Crash Course lists 43 major topics in Excel so that you can start using Excel like a pro in the shortest possible time.


How To Earn Money Online


Download Free Ebook


Download Full list of Excel Shortcuts


This Excel Shortcuts Complete list is to help you become save time and use Excel like a Master level user. Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.

I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.




Full List of Excel Formulas

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on www.Myelesson.org




Convert Numbers to Text in Excel

Now easily convert numbers to Text in Excel with this inbuilt sheet from myelesson.org .  Many times we need the amount in figures to be converted into words. This is a typical requirement for writing checks or any other financial reports. Microsoft Excel does not have standard function available for this requirement. Just download this sheet and then you can convert any number to text in Excel.




List of Most Commonly Asked Excel Questions in Interviews

Here is the list of most asked excel related questions in interviews.  Prepare for this excel questions and you would be able to most of the excel interviews. This list of excel questions covers excel formula, excel analysis, excel reporting, excel charts and more.





Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok