+ Reply to Thread
Results 1 to 6 of 6

Use arrow keys to move highlighted rows?

  1. #1
    Registered User
    Join Date
    02-07-2012
    Location
    Leawood, KS
    MS-Off Ver
    Excel 2003
    Posts
    5

    Use arrow keys to move highlighted rows?

    If I hist Shift Space in a cell then I can highlight an entire row.

    If I then hit shift arrow I can move up or down and highlight the additional rows (so I have 1,2,3,4 etc. rows highlighted).

    I would like to be able to arrow down or up and MOVE the highlighted row. Is this possible?

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Use arrow keys to move highlighted rows?

    Hi Bryan S,

    Welcome to the forum.

    As in step 2, after Selecting rows 1,2,3,4... if you want them to move somewhere else, just ctrl+X them here and go to desired location and right click -> insert cut cells because moving with arrow up / down will not move the highlighted rows. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    02-07-2012
    Location
    Leawood, KS
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Use arrow keys to move highlight in highlighted rows?

    I don't think I was clear in what I wanted. I don't really want to move the highlighted row, just to move the highlight.

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Use arrow keys to move highlighted rows?

    Ok..

    You can move the highlighted selection using shift and arrow key combination... up and down..!!

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    02-07-2012
    Location
    Leawood, KS
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Use arrow keys to move highlighted rows?

    Yes, that works but can I actually MOVE the highlight down one row. So if I have Row 24 highlighted I would like to be able to use the arrow keys (or some other key) to move down to row 25, unhighlighting row 24, and highlighting row 25, and then move down again, unhighlighting 25, and highlighting 26, etc.

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Use arrow keys to move highlighted rows?

    Hi Bryan,

    As per my knowledge, one cant do this. Thanks.

    Regards,
    DILIPandey

    <click on below stat if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1