Shortcut Keys

This is a list of all the shortcut keys related to cells and ranges.

Alt + Enter	Enters a new line (or carriage return) inside a cell.
Alt + Shift + Page Down	Extends the selection right one screen.
Alt + Shift + Page Up	Extends the selection left one screen.
Ctrl + Up Arrow	Moves to the first row in the current region.
Ctrl + Down Arrow	Moves to the last row in the current region.
Ctrl + Left Arrow	Moves to the first column in the current region or one word to the left.
Ctrl + Right Arrow	Moves to the last column in the current region or one word to the right.
Ctrl + '	Enters the formula from the cell directly above into the active cell.
Ctrl + "	Enters the value from the cell directly above into the active cell.
Ctrl + 1	Displays the Format Cells dialog box.
Ctrl + Backspace	Selects the current active cell (scrolling if necessary).
Ctrl + C	Copies the current selection to the clipboard.
Ctrl + D	Copies the value from the cell directly above into the active cell.
Ctrl + R	Copies the value from the cell directly to the left into the active cell.
Ctrl + V	Pastes the entry from the clipboard. You can also use Enter to paste the entry.
Ctrl + X	Cuts the current selection to the clipboard.
Ctrl + End	Moves to the Last Used Cell in the active worksheet. This cell is only updated when the workbook is closed.
Ctrl + Enter	Fills the selection with the current value.
Ctrl + Home	Moves to the first cell in the active worksheet (i.e. "A1").
Ctrl + Shift + 2	Enters the value from the cell directly above into the active cell.
Ctrl + Shift + 8	Selects the current region (block of contiguous cells).
Ctrl + Shift + Up Arrow	Extends the selection to the next non blank cell above in the same column. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys).
Ctrl + Shift + Down Arrow	Extends the selection to the next non blank cell below in the same column. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys).
Ctrl + Shift + Left Arrow	Extends the selection to the next non blank cell on the left. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys).
Ctrl + Shift + Right Arrow	Extends the selection to the next non blank cell on the right. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys).
Ctrl + Shift + End	Extends the selection to the Last Used Cell on the worksheet. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys).
Ctrl + Shift + Home	Extends the selection to the beginning of the worksheet. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys). Does not work on all keyboards though.
Ctrl + Shift + Spacebar	Selects all the objects on the worksheet when an object is selected or selects the whole worksheet.
Ctrl + Spacebar	Selects 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.
End, Shift + Arrow Keys	Switches End Mode on and extends the selection to the next non-blank cell in that direction.
End, Shift + Home	Switches End Mode on and extends the selection to Last Used Cell on the worksheet.
Esc	Cancels the cell entry and restores the original contents.
F2	Edits the active cell, putting the cursor at the end.
F4	Repeats the last action.
F8	Toggles whether to extend a selection with the arrow keys. You will see the text "Extend Selection" appear in the status bar.
Shift + Arrow Keys	Extends the selection by one cell in that direction.
Shift + F8	Toggles between switching Add Mode on or off. This allows you to select non contiguous blocks of cells using the keyboard arrow keys. You will see the text "Add to Selection" appear in the status bar.
Shift + Home	Extends the selection to the first column.
Shift + Page Up	Extends the selection up one screen.
Shift + Page Down	Extends the selection down one screen.
Shift + Spacebar	Selects the current row.
Ctrl + Alt + V, V	Displays the Paste Special dialog box with Values selected.
Alt + E, S, V	Displays the Paste Special dialog box with Values selected.

Alt + Enter Enters a new line (or carriage return) inside a cell.
Alt + Shift + Page Down Extends the selection right one screen.
Alt + Shift + Page Up Extends the selection left one screen.
Ctrl + Up Arrow Moves to the first row in the current region.
Ctrl + Down Arrow Moves to the last row in the current region.
Ctrl + Left Arrow Moves to the first column in the current region or one word to the left.
Ctrl + Right Arrow Moves to the last column in the current region or one word to the right.
Ctrl + ' Enters the formula from the cell directly above into the active cell.
Ctrl + " Enters the value from the cell directly above into the active cell.
Ctrl + 1 Displays the Format Cells dialog box.
Ctrl + Backspace Selects the current active cell (scrolling if necessary).
Ctrl + C Copies the current selection to the clipboard.
Ctrl + D Copies the value from the cell directly above into the active cell.
Ctrl + R Copies the value from the cell directly to the left into the active cell.
Ctrl + V Pastes the entry from the clipboard. You can also use Enter to paste the entry.
Ctrl + X Cuts the current selection to the clipboard.
Ctrl + End Moves to the Last Used Cell in the active worksheet. This cell is only updated when the workbook is closed.
Ctrl + Enter Fills the selection with the current value.
Ctrl + Home Moves to the first cell in the active worksheet (i.e. "A1").
Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell.
Ctrl + Shift + 8 Selects the current region (block of contiguous cells).
Ctrl + Shift + Up Arrow Extends the selection to the next non blank cell above in the same column. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys).
Ctrl + Shift + Down Arrow Extends the selection to the next non blank cell below in the same column. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys).
Ctrl + Shift + Left Arrow Extends the selection to the next non blank cell on the left. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys).
Ctrl + Shift + Right Arrow Extends the selection to the next non blank cell on the right. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys).
Ctrl + Shift + End Extends the selection to the Last Used Cell on the worksheet. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys).
Ctrl + Shift + Home Extends the selection to the beginning of the worksheet. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys). Does not work on all keyboards though.
Ctrl + Shift + Spacebar Selects all the objects on the worksheet when an object is selected or selects the whole worksheet.
Ctrl + Spacebar Selects 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.
End, Shift + Arrow Keys Switches End Mode on and extends the selection to the next non-blank cell in that direction.
End, Shift + Home Switches End Mode on and extends the selection to Last Used Cell on the worksheet.
Esc Cancels the cell entry and restores the original contents.
F2 Edits the active cell, putting the cursor at the end.
F4 Repeats the last action.
F8 Toggles whether to extend a selection with the arrow keys. You will see the text "Extend Selection" appear in the status bar.
Shift + Arrow Keys Extends the selection by one cell in that direction.
Shift + F8 Toggles between switching Add Mode on or off. This allows you to select non contiguous blocks of cells using the keyboard arrow keys. You will see the text "Add to Selection" appear in the status bar.
Shift + Home Extends the selection to the first column.
Shift + Page Up Extends the selection up one screen.
Shift + Page Down Extends the selection down one screen.
Shift + Spacebar Selects the current row.
Ctrl + Alt + V, V Displays the Paste Special dialog box with Values selected.
Alt + E, S, V Displays the Paste Special dialog box with Values selected.