Keyboard Shortcuts for Microsoft Excel
Ctrl + O | Open existing file |
---|---|
Ctrl + N | Create new workbook |
Ctrl + S | Save current workbook |
Ctrl + F4 | Close current workbook |
Ctrl + Z | Undo last action |
Ctrl + Y | Redo last action |
Ctrl + C | Copy selection |
Ctrl + X | Cut selection |
Ctrl + V | Paste selction |
Ctrl + P | Print (displays print menu and options) |
Ctrl + S | Save file |
F12 | Save file as |
Enter | Complete cell data entry and move to cell below. |
---|---|
Ctrl + Shift + Enter | Enter/create array formula |
Alt + Enter | Start new line in the same cell. |
Ctrl + Enter | Fill selected cell range with current entry. |
Shift + Enter | Complete cell data entry and move to cell directly above current cell. |
Tab | Complete cell data entry and move to the cell to the right. |
Shift + Tab | Complete cell data entry and move to the cell to the left. |
Esc | Cancel a cell entry and go back to what was there before. |
Arrow Keys | Move one cell left, right, up, or down. |
Home | Move to the first column (A). |
F4 / Ctrl + Y | Repeat last action. |
Ctrl + Shift + F3 | Create names for row and column labels. |
Ctrl + D | Fill down. |
Ctrl + R | Fill to the right. |
Ctrl + F3 | Define a name for a cell or range of cells. |
Ctrl + K | Insert a hyperlink. |
Enter (after insertion of hyperlink) | Activate a hyperlink. |
Ctrl + ; | Enter the current date. |
Ctrl + Shift + : | Enter the current time. |
Alt + Down Arrow | Display a drop-down list of the values in the current column of a list. |
Ctrl + Z | Undo the last action. |
Alt + F8 | Displays macro dialog box. |
Alt + F11 | Displays the visual basic editor. |
Ctrl + F11 | Inserts an Excel 4.0 macro sheet. |
F2 | Edit highlighted cell - cursor is at the end of cell contents. |
---|---|
Alt + Enter | Start a new line in the same cell. |
Backspace | When cell is highlighted, deletes cells contents. |
Delete | Deletes cells contents if cell is highlighted. |
Ctrl + Delete | Deletes text to the end of the line. |
F7 | Runs spell-check. |
Shift + F2 | Inserts and edits comments. |
Enter | Completes cell entry and moves to cell below. |
Ctrl + Z | Undo last action. |
Esc | Cancel a cell entry, previous contents are restored. |
Ctrl + Shift + Z | When the autocorrect smart tags is displayed, undo or redo the last automatic correction. |
Ctrl + C + Ctrl + C | Displays the clipboard (where copied items are). |
Ctrl + - | Removes/deletes selected cells from the sheet. |
Ctrl + Shift + "+" | Inserts blank cells. |
Alt + ' | Display style dialog box. |
---|---|
Ctrl + 1 | Display format cells dialog box. |
Shift + Spacebar | Highlight row |
Ctrl + Spacebar | Highlight column |
Ctrl + Shift + ~ | Apply the 'general number' format to selected cells. |
Ctrl + Shift + $ | Apply the 'currency number' format with two decimal places and negative numbers showing in parentheses to selected cells. |
Ctrl + Shift + % | Apply the 'percentage' format with no decimal places to selected cells. |
Ctrl + Shift + ^ | Apply the 'exponential number' format with two decimal places to selected cells. |
Ctrl + Shift + # | Apply the 'date' format with the day, month, and year to selected cells. |
Ctrl + Shift + @ | Apply the 'time' format with the hour, minute, and AM or PM to selected cells. |
Ctrl + Shift +! | Apply the 'number' format with two decimal places, thousands seperator, and minus sign for negative numbers to selected cells. |
Ctrl + B | Apply/remove bold format to selected cells. |
Ctrl + I | Apply/remove italic format to selected cells. |
Ctrl + U | Apply/remove underline to selected cells. |
Ctrl + 5 | Apply or remove 'strikethrough' to selected cells. |
Ctrl + 8 | Displays or hides the outline of symbols. |
Ctrl + 9 | Hide row. |
Ctrl + Shift + 9 | Unhide row. |
Ctrl + Shift + ( | Unhide any hidden rows within the selection. |
Ctrl + 0 | Hide the selected columns. |
Ctrl + Shift + ) | Unhide any columns within the selection. |
Ctrl + Shift + & | Apply the 'border outline' to selcted cells. |
Ctrl + Shift + _ | Remove the 'border outline' from selected cells. |
Alt + Shift + Right Arrow | Groups selected rows or columns. |
Alt + Shift + Left Arrow | Ungroups selected rows or columns. |
Alt + F8 | Displays macro dialog box. |
---|---|
Alt + F11 | Displays the visual basic editor. |
Ctrl + F11 | Inserts an Excel 4.0 macro sheet. |
Click above to see Keyboard Shortcuts for Microsoft Excel