Microsoft Excel shortcut keys
Below is a listing of all the major shortcut keys in Microsoft Excel. See the computer shortcut page if you are looking for other shortcut keys used in other programs.Shortcut Keys | Description | ||
F2 | Edit the selected cell. | ||
F5 | Go to a specific cell. For example, C6. | ||
F7 | Spell check selected text or document. | ||
F11 | Create chart. | ||
Ctrl + Shift + ; | Enter the current time. | ||
Ctrl + ; | Enter the current date. | ||
Alt + Shift + F1 | Insert New Worksheet. | ||
Shift + F3 | Open the Excel formula window. | ||
Shift + F5 | Bring up search box. | ||
Ctrl + A | Select all contents of the worksheet. | ||
Ctrl + B | Bold highlighted selection. | ||
Ctrl + I | Italic highlighted selection. | ||
Ctrl + K | Insert link. | ||
Ctrl + U | Underline highlighted selection. | ||
Ctrl + 5 | Strikethrough highlighted selection. | ||
Ctrl + P | Bring up the print dialog box to begin printing. | ||
Ctrl + Z | Undo last action. | ||
Ctrl + F9 | Minimize current window. | ||
Ctrl + F10 | Maximize currently selected window. | ||
Ctrl + F6 | Switch between open workbooks or windows. | ||
Ctrl + Page up | Move between Excel work sheets in the same Excel document. | ||
Ctrl + Page down | Move between Excel work sheets in the same Excel document. | ||
Ctrl + Tab | Move between Two or more open Excel files. | ||
Alt + = | Create a formula to sum all of the above cells | ||
Ctrl + ' | Insert the value of the above cell into cell currently selected. | ||
Ctrl + Shift + ! | Format number in comma format. | ||
Ctrl + Shift + $ | Format number in currency format. | ||
Ctrl + Shift + # | Format number in date format. | ||
Ctrl + Shift + % | Format number in percentage format. | ||
Ctrl + Shift + ^ | Format number in scientific format. | ||
Ctrl + Shift + @ | Format number in time format. | ||
Ctrl + Arrow key | Move to next section of text. | ||
Ctrl + Space | Select entire column. | ||
Shift + Space | Select entire row. |
That’s All. If You Need Any Help Or Have Any Suggestion Just Comment Below.