View Single Post
  #5   Report Post  
Tim Paine Tim Paine is offline
Junior Member
 
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!
Admin
Apps4Rent