• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to select multiple range with arrow key after entering forumula

PP3321

Active Member
Hi all thank you in advance for reading this post.
I want to do sum(range)+sum(range) in 1 cell.

It seems after entering the formula, it does not allow you to add new range by using arrow key.
(Using mouse works)

I want to do this without using mouse.

Is it possible?
 

Attachments

  • screenshot.png
    screenshot.png
    8.3 KB · Views: 8
  • chandoo.xlsx
    10.5 KB · Views: 4
Press F2 again.... Look at the left bottom of Excel. You'll toggle EDIT + ENTER mode. Only with EDIT you can go into POINT mode: where you can leave the cell and "point" or select a cell/range.
 
Back
Top