10 Most Useful Keyboard Shortcuts
Shortcut to Insert / Delete - Row & Column
F6 Key:
| Function key | Usage |
|---|---|
| F6 | If you are working in split window in current sheet of excel workbook then “F6” key will be used to switch between the panes of excel workbook. F6 will shift between each screen one by one. |
| Ctrl + F6 | While working on multiple workbooks we can use “Ctrl + F6” keys to switch to previous excel workbook. |
| Shift + F6 | “Shift + F6” this will work same as “F6” key. |
| Ctrl + Shift + F6 | “Ctrl + Shift + F6” keys work same as “Ctrl + F6” key. |
a) F6:
b) Ctrl + F6: We use it into switch the previous same windows file. For eg.: - We have opened 3 Excel’s file A, B and C. If you had been working on B file and then you started work A and then you press the key F6 then you again will be on B file.
c) Shift + F6: These keys will work same as “F6” key.
d) Ctrl + Shift + F6: These keys will work same as “Ctrl + F6” key.
F7 Key:
| Function key | Usage |
|---|---|
| F7 | This will check the Spelling in excel; this will work similar to as you click on Review tab & then click on Spelling button. |
| Ctrl + F7 | “Ctrl + F7” keys will move the current excel workbook if it is in restored window. |
| Shift + F7 | “Shift + F7” opens the “Research” task pane in your excel workbook. It provides the same output as you get by navigating to “Review” Tab on top of excel ribbon and then clicking on “Research” button. |
F8 Key:
| Function key | Usage |
|---|---|
| F8 | “F8” key is used to select multiple cells from starting cell to any direction (left, right, up or down). It enables & disables Extend Mode selection in excel. |
| Alt+F8 | “Alt + F8” keys are used to open the Macro dialog box |
| Ctrl + F8 | “Ctrl + F8” keys will re-size the current excel workbook if it is in restored window. The functionality is similar to “Ctrl + F7” keys. |
| Shift + F8 | “Shift + F8” keys you can selection multiple cells with arrow keys. |
F9 Key:
| Function key | Usage |
|---|---|
| F9 | This key will recalculates all the formulas in current excel workbook in all the sheets. |
| Ctrl + F9 | With “Ctrl + F9” keys you can minimize the excel window. If you try to maximize with these keys again then it will not work. |
| Shift + F9 | This will recalculate all the formula in the active workbook contains multiple worksheets. The functionality of “Shift + F9” keys is similar to F9 key. |
| Alt + Ctrl + F9 | This will recalculate all the formula in the active workbook contains multiple worksheets. The functionality of “Alt + Ctrl + F9” keys is similar to “F9” key or “Shift + F9” keys. |
| Alt + Ctrl + Shift + F9 | With “Alt + Ctrl + Shift + F9” keys we can recheck all the dependent formulas in all cells in all open workbooks. While calculating the cells this will include cells not marked as require to be calculated. |
F10 Key:
| Function key | Usage |
|---|---|
| F10 | With F10 key we can select the Menu Bar. This shortcut will open all the submenu at same time. The functionality is similar to pressing “Alt” key. |
| Alt+F10 | “Alt + F10” keys will open up the selection window in excel. |
| Ctrl + F10 | “Ctrl + F10” keys will resize or restore the current excel window if it is open in maximum window. If you press these keys again then it will maximize the current excel window. |
| Shift + F10 | “Shift + F10” keys is similar to selecting a cell then pressing these keys will display the options of right click menu. |
| Alt + Shift + F10 | “Alt + Shift + F10” keys will display the menu for Smart Tag; if there are many Smart Tags in the excel workbook then it will toggles to next Smart Tag & display its menu. |
| Ctrl + Shift + F10 | “Ctrl + Shift + F10” keys is similar to “Shift + F10” keys. |
F11 Key:
| Function key | Usage |
|---|---|
| F11 | “F11” key will insert chart for the selected cells in the new Chart Sheet; this key will immediately create a default chart style i.e. Column Chart. |
| Alt+F11 | “Alt + F11” keys will open up the Visual Basic Editor screen. In case the VB screen is already open then using these keys will toggle between excel & editor screen. |
| Ctrl + F11 | “Ctrl + F11” keys will create a new worksheet with name like Macro1, Macro2 & so on. These were used in Excel 97 version to store the macros but they are not used these days in new versions. |
| Shift + F11 | “Shift + F11” keys will insert a New Sheet on the left hand side of the current worksheet in active workbook. |
| Alt + Shift + F11 | “Alt + Shift + F11” will open the Microsoft Script editor also known as MSE in the current excel workbook. This is a tool introduced in older version MS Office 2000 to 2007 by Microsoft. It helps you in large variety of codes in office products. The Microsoft Script Editor is Office 2003 version is an optional tool and is found in "C:\Program Files\common files" directory. It allows you to work with HTML code, DHTML objects, and script in an Office document from within an Office application. If someone is using with Internet Explorer then it will allow you to debug JavaScript and VBScript with the editor in case "Disable Script Debugging" Internet Explorer preference option is not checked. |
F12 Key:
| Function key | Usage |
|---|---|
| F12 | “F12” key will open the “Save As” dialog box for saving active workbook. The functionality of F12 key is similar to using “Alt + F2” keys. Both will do the same. |
| Ctrl + F12 | With “Ctrl + F12” the File Open Dialog Box will be open. This is similar to using “Ctrl + O” keys. |
| Shift + F12 | With “Shift + F12” keys we can save the workbook. This is same as using “Ctrl + S” keys or “Alt + Shift + F2” for saving the excel file. Both are similar to Shift + F12 keys. |
| Ctrl + Shift + F12 | “Ctrl + Shift + F12” keys will open the print options. These keys are similar to “Ctrl + F2” keys and “Alt + Ctrl + Shift + F2” keys. |
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
Thanks for sharing the cheat sheet. It is really nice guys.
liked CTRL+F6....i didn't know about this shortcut...there are many more...a big thank you guys...