MERCENIE TEAM
May 9, 2017
Useful Shortcut Keys for Excel
Useful shortcut key for Excel which help you in day to day life, as a professionally many of us usages Excel for their office work and waste their time to format their spreadsheets. We have some useful shortcut keys for Excel which is very useful for you.
| F2 | Edit selected cell. |
| F4 | Repeat last edit. |
| F9 | Recalculate all worksheets. |
| F12 | Display the Save as dialog. |
| Ctrl + F1 | Display or hide the Ribbon. |
| Ctrl + PgDn | Switch between worksheet tabs. |
| Ctrl + PgUp | Switch between worksheet tabs, moving right to left. |
| Ctrl+Shift+; | Enter the current time. |
| Ctrl+; | Enter the current date. |
| Ctrl+A | Select all contents of the worksheet. |
| Ctrl+B | Bold selection. |
| Ctrl+I | Italic selection. |
| Ctrl+S | Save the open worksheet. |
| Ctrl+U | Underline selection. |
| Ctrl+P | Print option. |
| Ctrl+Z | Undo last action. |
| Ctrl+F3 | Open Excel Name Manager. |
| Ctrl+F6 | Switch between open workbooks or windows. |
| Ctrl+F9 | Minimize current window. |
| Ctrl+Tab | Switch between two or more open Excel files. |
| Ctrl+Shift+1 | Format number in comma format. |
| Ctrl+Space | Select entire column. |
| Ctrl+- | Delete the selected column or row. |
| Ctrl+Home | Move to cell A1. |
| Alt+Shift+F1 | Insert New Worksheet. |
| Alt+Enter | Multiple lines of text in one cell. |
| Shift+F3 | Open the Excel formula window. |
| Shift+F5 | Bring up search box. |
See Also:- Shortcut Key For Windows 7
Last Updated On: October 4th, 2018