Keep Active Cell on the same cell
This combination of keyboard keys is really useful. If you enter data, a function or formula and you wish the active cell to remain on the cell you are entering in, hold the Ctrl key down and press Enter.
Enter a replica of text, numbers, formulas or functions across a selected range
Select the required range of cells and then enter the data in the active cell (the white one in the range) hold the Ctrl key down and press Enter.
Simple but effective use of the Ctrl and Enter keys