As you probably know, there are a TON of ways to copy or fill formulas. I am going to show you the technique that works best when you already have the range selected that you want to insert or modify formulas in. This tends to happen when we are modifying formulas or fixing them for errors.
CTRL + ENTER
- Select the cells that the formula will be inserted in.
- Type or insert the formula or text in the active cell.
- Hold the Ctrl key and press Enter.
The formula or text will be copied to all the selected cells.
Note: If you have a single cell selected, then Ctrl+Enter can be used to keep that cell selected after you edit the formula. Typically the next cell will be selected after hitting Enter. Press Ctrl+Enter to keep the same cell selected.
To learn comprehensive Excel Formulae, Click here.