Sunday, 2 March 2014

Short Cuts 6

Ctrl + Shift + \ Selects the cells in a selected column that do not match the value in the active cell


Ctrl + / Selects the array containing the active cell ??


Alt + ; Selects the visible cells in the current selection


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 + 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 Selects all the objects on the worksheet when an object is selected or selects the whole 
worksheet


Ctrl + Spacebar Selects the current column


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 current row


Ctrl + Shift + Arrow Key Extends the selection to the next cell adjacent to a blank cell in that direction


Ctrl + Shift + End Extends the selection to the last used cell on the worksheet


Ctrl + Shift + Home Extends the selection to the beginning of the worksheet


Shift + Arrow Keys Extends the selection by one cell in that direction


Shift + Home Extends the selection to the first column


Shift + Page Down Extends the selection down one screen


Shift + Page Up Extends the selection up one screen


End + Shift + Arrow Keys Extends the selection to the next non-blank cell in that direction


End + Shift + End Extends the selection to the last cell in the current row*


End + Shift + Home Extends the selection to last used cell on the worksheet


Alt + ' Displays the Style dialog box


Ctrl + Shift + ( ' or ) Applies the Time format "hh:mm" to the selection



No comments:

Post a Comment