F2 | Edit the selected cell |
F3 | After a name has been created F3 will paste names |
F5 | Go to a specific cell. For example, C6 |
F7 | Spell check selected text or document |
F11 | Create chart from selected data |
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 section |
Ctrl + I | Italic highlighted section |
Ctrl + K | Insert link |
Ctrl + U | Underline highlighted section |
Ctrl + 1 | Change the format of selected cells |
Ctrl + 5 | Strike through highlighted section |
Ctrl + P | Bring up the print dialogue box to begin printing |
Ctrl + Z | Undo last action |
Ctrl + F3 | Open Excel Name Manager |
Ctrl + F9 | Minimize current window |
Ctrl + F10 | Maximize currently selected window |
Ctrl + F6 | Switch between open work books or windows |
Ctrl + Page up | Move between Excel work sheets in the same Excel document |
Ctrl + page down | Move between Excel worksheets in the same Excel document |
Ctrl + Tab | Move between two or more open Excel document |
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 the next selection on text |
Ctrl + Space | Select entire column |
Shift + Space | Select entire row |
Ctrl + – | Delete the selected column or row |
Ctrl + shift + = | Insert a new column or row |
Ctrl + Home | Move to cell A1 |
Ctrl + ~ | Switch between showing Excel formulas or their values in cells |
Papers Asked Questions
Total Hits
Sunday, 21 February 2016
MS Excel Shortcut keys
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment