-1

I want to move the selector (3 cells selected in the example below) with arrow keys. It is possible to move with one cell selected, can I do it with more than one cells? Thanks. Note: I don't want to move or copy contents of the cells. I just want to move the selector (big rectangular box) as easy as moving a single cell selector. (The question in the link is not answered yet either, and the offered solutions what I was not looking for).

enter image description here

5
  • To move it left or right, you can use Shift-Arrow, Tab, then Shift-Arrow again. Not sure if there is a way to move up and down. Aug 17 '17 at 22:11
  • @Bandersnatch – you reminded me that it worked that way! I already found out a way for vertical movement, too.
    – miroxlav
    Aug 17 '17 at 22:46
  • Actually I tried Shift+Arrow tab before posting the question, and other alternatives too, but it didn't work. and I still can't move it. it is resized.
    – user761065
    Aug 17 '17 at 22:49
  • 1
    Possible duplicate of How to move selection in Excel? The OP found it after answering. I should have seen it earlier.
    – miroxlav
    Aug 17 '17 at 23:08
  • Downvoting for originally misleading question.
    – miroxlav
    Aug 17 '17 at 23:14
0

Based on the above image: If you mean moving selection of C3:C5 to become D3:D5, then it is possible in somewhat cumbersome way as shown in Bandersnatch's comment.

enter image description here

Moving N cells right [left]: (follow either normal text or text in [brackets])

  1. Highlight a cell in leftmost [rightmost] column of selection using Tab or Shift+Tab if not already done.

  2. Press Shift+ [Shift+] N times.

  3. Press Shift+Tab [Tab] once.

  4. Press Shift+ [Shift+] N times again.

Moving N cells down [up]: (follow either normal text or text in [brackets]

  1. Highlight a cell in top [bottom] row of selection using Enter or Shift+Enter if not already done.

  2. Press Shift+ [Shift+] N times.

  3. Press Shift+Enter [Enter] once.

  4. Press Shift+ [Shift+] N times again.

8
  • This command for resizing, I guess. What I am seeking is moving the selector which is the size of C3:C5 here without moving its content or changing it size across the data.
    – user761065
    Aug 17 '17 at 22:34
  • @user761065 – these sequences use resizing for moving, that's the trick. Position of highlighted cell in selection is important when you are doing this, it affects behavior of arrows. If you have a problem in any step, let me know.
    – miroxlav
    Aug 17 '17 at 22:52
  • I found similar question superuser.com/questions/238449/how-to-move-selection-in-excel and there they suggest using ASAP Utilities which I downloaded and tried already. It does what I say, it would be nice to have an excel way of doing this too actually.
    – user761065
    Aug 17 '17 at 22:55
  • @user761065 – I added a video for you. It shows how the selection is moving. Are you sure you were following the steps (including work with highlighted cell) correctly?
    – miroxlav
    Aug 17 '17 at 23:02
  • yes I know this. but it is not really practical as moving a single cell selector.
    – user761065
    Aug 17 '17 at 23:10

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.