Google-sheets – How to change cell range without deleting it

google sheetskeyboard shortcuts

In a function, let's say the SUM function, I have a range H25:H37 I want to change this range to H23:H40 using the mouse. The only way I could find is to delete the initial value, then I can drag the mouse to select the new value. Is there a shortcut or some keyboard trick that allows me to change the range without deleting it?

enter image description here

Best Answer

  • try CTRL + H
  • select specific range if its only in one cell

  • and also select within formulas

    0

Related Topic