Sunday, 2 March 2014

Short Cuts 4

Ctrl + Shift + F Activates the Font Tab of the format cells


Ctrl + Shift + O Selects all the cells with comments


Ctrl + Shift + P Activates the Font Size tab of the format cells


Enter Enters the contents of the active cell and moves to the cell below (by default)


Shift + Enter Enters the contents of the active cell and moves to the cell above (by default)


Tab Enters the contents of the active cell and moves one cell to the right


Shift + Tab Enters the contents of the active cell and moves one cell to the left


Alt + = Enters the SUM() function (AutoSum) to sum the adjacent block of cells


Alt + 0128 Enters the euro symbol (€) (using Number keypad)


Alt + 0162 Enters the cent symbol (¢) (using Number keypad)


Alt + 0163 Enters the pound sign symbol (£) (using Number keypad)


Alt + Enter Enters a new line (or carriage return) into a cell


Ctrl + ' Enters the contents from the cell directly above into the active cell


Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell

Ctrl + ; Enters the current date into the active cell


Ctrl + Shift + ; Enters the current time into the active cell


Ctrl + Shift + Enter Enters the formula as an Array Formula


Shift + Insert Enters the data from the clipboard


Alt + Down Arrow Displays the Pick From List drop-down list Esc Cancels the cell entry and restores the original 
contents


Delete Deletes the selection or one character to the right


Backspace Deletes the selection or one character to the left Shift + Delete Cuts the selection to the clipboard


Ctrl + Delete Deletes text to the end of the line Ctrl + - Displays the Delete dialog box


Ctrl + Shift + = Displays the Cells dialog box


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



No comments:

Post a Comment