F2 | Edit the selected cell |
F5 | Go to a specific cell |
F7 | Spell check selected text and/or document |
F11 | Create chart |
Ctrl + Shift +; | Enter the current time |
Ctrl + ; | Enter the current date |
Aft + Shift + F1 | Insert new worksheet |
Shift + F3 | Open the Excel" formula window |
Shift + F5 | Bring up search box |
Ctrl + A | Select all contents of worksheet |
Ctrl + B | Bold highlighted selection |
Ctrl +1 | Italicize highlighted selection |
Ctrl + C | Paste |
Ctrl + D | Fill |
Ctrl+K | Insert link |
Ctrl + F | Open find and replace options |
Ctrl + G | Open go-to options |
Ctrl + H | Open find and replace options |
Ctrl + U | Underline highlighted selection |
Ctrl + Y | Underline selected text |
Ctrl + 5 | Strikethrough highlighted selection |
Ctrl + 0 | Open options |
Ctrl + N | Open new document |
Ctrl+ P | Open print dialog box |
Ctrl + S | Save |
Ctrl + Z | Undo last action |
Ctrl + F9 | Minimize current window |
Ctrl + F10 | Maximize currently selected window |
Ctrl + F6 | Switch between open workbooks/windows |
Ctrl + Page up | Move between Excel* worksheets in the same document |
& Page Down | |
Ctrl + Tab | Move between two or more open Excel files |
Alt+= | Create formula to sum all of above cells |
Ctrl+` | Insert value of above cell into current cell |
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 m percentage format |
Ctrl + Shift + ^ | Format number in scientific format |
Ctrl+ Shift+@ | Format number in time format |
Ctrl + left arrow key | Move to next section of text |
Ctrl + Space | Select entire column |
Shift + Space | Select entire row |
Ctrl + W | Close document |
Excel Shortcut Keys
Subscribe to:
Posts (Atom)