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

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