• 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.

Moving/dragging the blue selection bar without mouse

R

RAshar

New Member
hello


Lets say you have values from A1:A5, and you want to sum these in A6. However, in A6 lets say by accident we summed to A4 instead of A5, so we have the formula, =SUM(A1:A4).


NOW, if we want to select A5, the usual way I would do it is highlight A6 with my mouse, then a BLUE SELECTION BAR would show up from A1:A4, and i would usually drag this down with the mouse to A5 to select that.


Another way I could drag it down to A5 is to select A6, press F2 and edit/delete "4" and type in "5", and it would automatically select A1:A5.


I dislike both methods...is there ANY WAY to drag it down using the arrow keys instead? When we first enter the formula THIS IS POSSIBLE, however once we hit enter you cant move the blue selection bar anymore with the arrow keys! so annoying! please help!
 
RAShar


Firstly welcome to the Chandoo.org forums


I don't know why I persisted with this one because although I eventually found a solution

I'm not sure if it adds any value to the Excel community, but hey as long as it helps you, your ahead.


Assuming you have a formula =Sum(A1:A4)

goto Edit Mode using F2

With the cursor keys press left arrow to move inside the )

Hold shift and select the 2 letters A4

Press the F5 key

Press Esc key

now move the Blue Box with the cursor keys


You can do the same with the other corner by first selecting the A1 and then F5


Enjoy...
 
You must log in or register to reply here.
Back
Top