Microsoft Excel Shortcuts Keys
Below is a Listing of all the major shortcut keys usable in Microsoft Excel.See the computer shortcut page if user are looking for shortcut keys used in other programs.
SHORTCUTS | DESCRIPTION |
---|---|
F2 | Edit the selected cell. |
F3 | Aftera name has been created,F3 wil paste names. |
F4 | Repeat last action.For example,C6. |
F5 | Go to specific cell.For example ,C6 |
F7 | Spell check selected data. |
F11 | Create chart from selected data. |
Ctrl+Shift+: | Enter the current time. |
Ctrl+: | Enter the current date |
Alt+Enter | While typing text in a cell,pressing Alt+Enter will move to the next line,allowing for multiple lines of text in one cell. |
Shift+F3 | Open the Excel formulla window. |
Shift+F5 | Bring up search box. |
Ctrl+1 | Open the Format Cells |
Ctrl+A | Selected all contents of the worksheet |
Ctrl+B | Bold highlighted selectection. |
Ctrl+I | Italic Highlighted selection |
Ctrl+K | Insert link |
Ctrl+S | Save the open worksheet . |
Ctrl+U | Underline highlighted selection . |
Ctrl+P | Bring up the print dsialog box to begin the printing the printing process. |
Ctrl+Z | Undo last action. |
Ctrl+F3 | Open Excel Name Manager. |
Ctrl+F9 | Minimize current window. |
Ctrl+F10 | Maximize current window. |
Ctrl+Page up | Move between work sheets in the same document. |
Ctrl+Page down | Move between work sheets in the same document. |
Ctrl+Tab | Move between Two or more open Excel files. |
Alt+= | Create a formula to sum all of the above cells. |
Ctrl' | Insert thae value of the above cell into the cell currently selected. |
Ctrl+Arrow key | Move to next section of text. |
Ctrl+Space | Select Entire coloumn |
Ctrl+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 |
Get more important gk topic
in your mailbox
Subscribe to our mailing list and get interesting stuff and updates to your email inbox.