Entering
= | Start a Formula. |
Enter | Enters the contents of the active cell and moves to the cell below. |
Alt + Enter | Enters a new line (or carriage return) into a cell. |
Shift + Enter | Enters the contents of the active cell and moves to the cell above (opposite direction to Enter). |
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 (opposite direction to Tab). |
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 + 0165 | Enters the yen symbol (¥) (using Number keypad). |
Ctrl + (" ) | Enters the value from the cell directly above into the active cell. |
Ctrl + (') | Enters the formula 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 and applies the default regional setting date format. |
Ctrl + Enter | Enters the contents of the active cell to the selected region. |
Ctrl + Shift + (;) | Enters the Current Time into the active cell and applies the time format hh:mm in 24 hour notation. |
Ctrl + Shift + Enter | Enters the formula of the active cell to the selected region 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 or closes full screen view. |
= Start a Formula. |
Enter Enters the contents of the active cell and moves to the cell below. |
Alt + Enter Enters a new line (or carriage return) into a cell. |
Shift + Enter Enters the contents of the active cell and moves to the cell above (opposite direction to Enter). |
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 (opposite direction to Tab). |
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 + 0165 Enters the yen symbol (¥) (using Number keypad). |
Ctrl + (" ) Enters the value from the cell directly above into the active cell. |
Ctrl + (') Enters the formula 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 and applies the default regional setting date format. |
Ctrl + Enter Enters the contents of the active cell to the selected region. |
Ctrl + Shift + (;) Enters the Current Time into the active cell and applies the time format hh:mm in 24 hour notation. |
Ctrl + Shift + Enter Enters the formula of the active cell to the selected region 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 or closes full screen view. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext