Selecting

Alt + ;Selects the visible cells in the current selection.
Ctrl + \Selects all the cells in the current selection that do not match the value in the active cell. Select the cells first and then use the Tab key to change the active cell.
Ctrl + /Selects all the cells that are part of the Same Array Formula which has been entered into the active cell.
Ctrl + Shift + (8 or *)Selects the Current Region (surrounded by blank rows and columns).
Ctrl + *Selects the Current Region (using the * on the number keyboard).
Ctrl + [Selects all the cells that are directly referred to by the formula in the active cell (precedents).
Ctrl + Shift + [Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell.
Ctrl + ]Selects all the cells that directly refer to the active cell (dependents).
Ctrl + Shift + ]Selects all the cells that directly (or indirectly) refer to the active cell.
Ctrl + Shift + Left ArrowSelects one word to the left.
Ctrl + Shift + Right ArrowSelects one word to the right.
Ctrl + Shift + Page DownSelects the active worksheet and the one after it.
Ctrl + Shift + Page UpSelects the active worksheet and the one before it.
Ctrl + Shift + SpacebarSelect the Whole Table.
Selects all the objects on the worksheet when an object is selected or selects the whole worksheet.
Ctrl + Shift + EndSelects all the text after the cursor in the formula bar.
Ctrl + BackspaceSelects the current active cell (scrolling if necessary).
Ctrl + SpacebarSelects the entire column when the active cell is not inside a table.
Selects the current column (without headers) when the active cell is inside a table. When pressed again the selection will include the table header row. When pressed again the entire column is selected.
Shift + Arrow keysSelects the active cell and the cell in the given direction.
Shift + BackspaceSelects the active cell when multiple cells are selected.
Shift + SpacebarSelects the entire row when the active cell is not inside a table.
Selects the current row when the active cell is inside a table. When pressed again the entire row is selected.
Shift + HomeSelects all the cells in the current row between the active cell and the first column.
Alt + ;
Selects the visible cells in the current selection.
Ctrl + \
Selects all the cells in the current selection that do not match the value in the active cell. Select the cells first and then use the Tab key to change the active cell.
Ctrl + /
Selects all the cells that are part of the Same Array Formula which has been entered into the active cell.
Ctrl + Shift + (8 or *)
Selects the Current Region (surrounded by blank rows and columns).
Ctrl + *
Selects the Current Region (using the * on the number keyboard).
Ctrl + [
Selects all the cells that are directly referred to by the formula in the active cell (precedents).
Ctrl + Shift + [
Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell.
Ctrl + ]
Selects all the cells that directly refer to the active cell (dependents).
Ctrl + Shift + ]
Selects all the cells that directly (or indirectly) refer to the active cell.
Ctrl + Shift + Left Arrow
Selects one word to the left.
Ctrl + Shift + Right Arrow
Selects one word to the right.
Ctrl + Shift + Page Down
Selects the active worksheet and the one after it.
Ctrl + Shift + Page Up
Selects the active worksheet and the one before it.
Ctrl + Shift + Spacebar
Select the Whole Table.
Selects all the objects on the worksheet when an object is selected or selects the whole worksheet.
Ctrl + Shift + End
Selects all the text after the cursor in the formula bar.
Ctrl + Backspace
Selects the current active cell (scrolling if necessary).
Ctrl + Spacebar
Selects the entire column when the active cell is not inside a table.
Selects the current column (without headers) when the active cell is inside a table. When pressed again the selection will include the table header row. When pressed again the entire column is selected.
Shift + Arrow keys
Selects the active cell and the cell in the given direction.
Shift + Backspace
Selects the active cell when multiple cells are selected.
Shift + Spacebar
Selects the entire row when the active cell is not inside a table.
Selects the current row when the active cell is inside a table. When pressed again the entire row is selected.
Shift + Home
Selects all the cells in the current row between the active cell and the first column.

Selecting Data (inside a cell)

Shift + HomeSelects all the text from the cursor to the end.
Shift + EndSelects all the text from the beginning to the cursor.
Shift + Home
Selects all the text from the cursor to the end.
Shift + End
Selects all the text from the beginning to the cursor.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext