General
Starts a new line in the same cell
|
Alt + ⤶ Enter
|
General
Displays the Microsoft Visual Basic Editor
|
Alt + F11
|
General
Displays the Macros dialog box to run, edit or delete macros.
|
Alt + F8
|
General
Displays the Control menu for the program window
|
Alt + Space
|
General
Move one cell up, down, left, or right in a worksheet.
|
← ↑ → ↓
|
General
Clears the content of the active cell to reedit cell content
|
⬅ Backspace
|
General
Enters the current time.
|
Ctrl + '
|
General
Enters the current date.
|
Ctrl + ;
|
General
Displays the Format Cells dialog box
|
Ctrl + 1
|
General
Moves to the edge of the current data region in a worksheet
|
Ctrl + ← ↑ → ↓
|
General
Applies or removes bold formatting
|
Ctrl + B
|
General
Copies the selected cells
|
Ctrl + C
|
General
Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below
|
Ctrl + D
|
General
Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column
|
Ctrl＋End
|
General
Fills the selected cell range with the current entry
|
Ctrl + ⤶ Enter
|
General
Displays the Find dialog box
|
Ctrl + F
|
General
Displays the Task Pane on the right side of the program window
|
Ctrl + F1
|
General
Displays the Go To dialog box
|
Ctrl + G
|
General
Displays the Replace dialog box
|
Ctrl + H
|
General
Moves to the beginning of a worksheet
|
Ctrl + Home
|
General
Applies or removes italic formatting
|
Ctrl + I
|
General
Displays the Hyperlink dialog box to insert new hyperlinks or edit existing hyperlinks
|
Ctrl + K
|
General
Selects multiple ranges of cells
|
Ctrl + Mouse left click
|
General
Creates a new, blank workbook
|
Ctrl + N
|
General
Displays the Open dialog box to open or find a file
|
Ctrl + O
|
General
Displays the Print dialog box
|
Ctrl + P
|
General
Switches between worksheet tabs, from right-to-left
|
Ctrl + Page Down
|
General
Switches between worksheet tabs, from left-to-right
|
Ctrl + Page Up
|
General
Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right
|
Ctrl + R
|
General
Saves the active file with its current file name, location and file format
|
Ctrl + S
|
General
Enters the current time
|
Ctrl + ↑ Shift + '
|
General
Enters the current time
|
Ctrl + ↑ Shift + ;
|
General
Displays the Insert dialog box
|
Ctrl + ↑ Shift + =
|
General
Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell
|
Ctrl + ↑ Shift + ← ↑ → ↓
|
General
Extends the selection of cells to the beginning of the worksheet.
|
Ctrl + ↑ Shift + Home
|
General
Goes to previous worksheet tab
|
Ctrl + ↑ Shift + ⭾ Tab
|
General
Goes to next worksheet tab
|
Ctrl + ⭾ Tab
|
General
Applies or removes underlining
|
Ctrl + U
|
General
Inserts the contents of the Clipboard at the insertion point and replaces any selection
|
Ctrl + V
|
General
Closes the selected workbook window
|
Ctrl + W
|
General
Cuts the selected cells
|
Ctrl + X
|
General
Repeats the last command or action, if possible
|
Ctrl + Y
|
General
Uses the Undo command to reverse the last command or to delete the last entry you typed
|
Ctrl + Z
|
General
Moves one cell down in a selected cell range
|
⤶ Enter
|
General
Help
|
F1
|
General
Insert chart
|
F11
|
General
Displays the Save As dialog box to save the file with a different name, type or location
|
F12
|
General
Edits the active cell and positions the insertion point at the end of the cell contents
|
F2
|
General
Repeats the last action of adding or deleting the whole row/column
|
F4
|
General
Displays the Spelling dialog box to check spelling in the active worksheet or selected range
|
F7
|
General
Calculates all worksheets in all open workbooks
|
F9
|
General
Moves to the cell in the upper-left corner of the window
|
Home
|
General
click Selects one range of cells
|
←
|
General
Selects the cells in the next screen in the same column(s)
|
Page Down
|
General
Selects the cells in the previous screen in the same column(s).
|
Page Up
|
General
Extends the selection of cells by one cell, or row/column
|
↑ Shift + ← ↑ → ↓
|
General
Moves one cell up in a selected cell range
|
↑ Shift + ⤶ Enter
|
General
Displays context menu for a selected item
|
↑ Shift + F10
|
General
Extends the selection of cells to the first row of this window in this column
|
↑ Shift + Home
|
General
Inserts the contents of the Clipboard at the insertion point and replaces any selection
|
↑ Shift + Insert
|
General
Selects the area from the active cell to the clicked cell
|
↑ Shift + Mouse left click
|
General
Selects the cell range from the current cells to the next screen of the same column(s)
|
Shift + Page Down
|
General
Selects the cell range from the current cells to the previous screen of the same column(s)
|
Shift + Page Up
|
General
Moves to the previous cell in a worksheet, or moves one cell to the left in a selected range
|
↑ Shift + ⭾ Tab
|
General
Moves one cell to the right in a worksheet
|
⭾ Tab
|