Shortcut Keys

Alt + EnterEnters a new line (or carriage return) inside a cell.
Ctrl + " Enters the value from the cell directly above into the active cell.
Ctrl + ' Enters the formula from the cell directly above into the active cell.
Ctrl + 1Displays the Format Cells dialog box.
Ctrl + BackspaceSelects the current active cell (scrolling if necessary).
Ctrl + Down ArrowMoves to the last row in the current region.
Ctrl + EndMoves to the last "used" cell in the active worksheet. This cell is only updated when the workbook is closed.
Ctrl + EnterFills the selection with the current value.
Ctrl + HomeMoves to the first cell in the active worksheet (i.e. "A1").
Ctrl + Shift + 2Enters the value from the cell directly above into the active cell.
Ctrl + Shift + 8Selects the current region (block of contiguous cells).
Ctrl + Shift + EndExtends the selection to the last used cell on the worksheet.
Ctrl + Shift + SpacebarSelects all the objects on the worksheet when an object is selected or selects the whole worksheet.
Ctrl + SpacebarSelects the current column when the active cell is inside a table. When pressed again the entire column is selected. If the selection spans multiple columns all these table columns are selected.
Ctrl + CCopies the current selection to the clipboard.
Ctrl + DEnters the value from the cell directly above into the active cell.
Ctrl + REnters the value from the cell directly to the left into the active cell.
Ctrl + VPastes the entry from the clipboard. You can also use Enter to paste the entry.
Ctrl + XCuts the current selection to the clipboard.
End + HomeMoves to the last "used" cell on the active worksheet. This cell is only updated when the workbook is closed.
EscCancels the cell entry and restores the original contents.
F2Edits the active cell, putting the cursor at the end.
F4Repeats the last action.
F8Toggles whether to extend a selection with the arrow keys.
Shift + SpacebarSelects the current row.
Ctrl + Right ArrowMoves to the last column in the current region or one word to the right.
Ctrl + Left ArrowMoves to the first column in the current region or one word to the left.
Ctrl + Up ArrowMoves to the first row in the current region.
Ctrl + Down ArrowMoves to the last row in the current region.

© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

PrevNext