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

  • That does not look like Excel... – Scott Craner May 20 '19 at 18:12
  • Just highlight the range in the formula bar, then select the new range. No keyboard required. – Scott Craner May 20 '19 at 18:13
  • When I select the new range, the initial cell gets deselected – TSR May 20 '19 at 18:24
  • I thought that is what you want. A way to change the range with only the mouse, at least that is how I read your question. – Scott Craner May 20 '19 at 18:27
  • Yes that what I want but it does not work. Your suggestion deselected the cell itself but the range is still the same. Instead, it selects the cells of the new range – TSR May 20 '19 at 18:31
  • try CTRL + H
  • select specific range if its only in one cell
  • and also select within formulas


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.