Editing formulas in Microsoft Excel 2019

If you need to edit the formula and make changes to its parts, suchas to the range or fixing an error, you can achieve this using more thanone method, as follows:

  • Double-click on the cell that contains the formula to edit. Theformula displays and the cells are highlighted on the worksheet. Notethat if you have used functions in your formula, the function tip popsup under the function used. Edit the formula, then press Enterto update it.
  • Click on the cell that contains the formula to edit. The formuladisplays in the Formula Bar. Click in the Formula Bar to make changes to theformula. Edit the formula, then press Enter to update it.
  • Click on the cell that contains the formula to edit. Press theF2 function key on the keyboard. The cell will display theformula to edit. Edit the formula, then press Enter to updateit.

Leave a Comment