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 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.

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 + Home	Selects all the text from the cursor to the end.
Shift + End	Selects 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.