View Single Post
  #5   Report Post  
Old January 6th 21, 11:17 AM
Tim Paine Tim Paine is offline
Junior Member
First recorded activity by ExcelBanter: Dec 2020
Posts: 27
Default how can i change the formula for multiple cells at once in excel

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!