Entering

=Start a Formula.
EnterEnters the contents of the active cell and moves to the cell below.
Alt + EnterEnters a new line (or carriage return) into a cell.
Shift + EnterEnters the contents of the active cell and moves to the cell above (opposite direction to Enter).
TabEnters the contents of the active cell and moves one cell to the right.
Shift + TabEnters 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 + 0128Enters the euro symbol (€) (using Number keypad).
Alt + 0162Enters the cent symbol (¢) (using Number keypad).
Alt + 0163Enters the pound sign symbol (£) (using Number keypad).
Alt + 0165Enters 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 + 2Enters 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 + EnterEnters 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 + EnterEnters the formula of the active cell to the selected region as an Array Formula.
Shift + InsertEnters the data from the clipboard.
Alt + Down ArrowDisplays the Pick From List drop-down list.
EscCancels the cell entry and restores the original contents or closes full screen view.

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