Follow these steps below to change formula for multiple cells
Click the cell with the formula to select it.
Press Ctrl + C to copy the formula.
Select a cell or a range of cells where you want to paste the formula (to select non-adjacent ranges, press and hold the Ctrl key).
Press Ctrl + V to paste the formula.
Press Enter to complete the pasted formulas.
I hope this is helpful!