5 May 2017 ... Click on the Tick in the Formula Bar OR hold down the CTRL key and press Enter. Whichever way you prefer. Just as long as you remain in the cell ...