+ Reply to Thread
Results 1 to 6 of 6

Ctrl + arrow key not working

  1. #1
    Registered User
    Join Date
    02-02-2017
    Location
    Buffalo, NY
    MS-Off Ver
    2007
    Posts
    3

    Ctrl + arrow key not working

    I came across this website doing a Google search. Forgive me if i don't use the correct terms. I would like to quickly move to the last occupied cell in a row. Using Ctr/right arrow will not skip empty cells, but will take you to the next cell to the left of the next blank one. I want to skip any blanks and go directly to the last cell in a row that contains data. Been searching for hours with no solution. Interestingly, someone had the opposite problem and posted a question 7-3-2008 and that's how I got to this website.
    Thanks!
    David

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,210

    Re: Ctrl + arrow key not working

    Try CTRL+END
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  3. #3
    Registered User
    Join Date
    02-02-2017
    Location
    Buffalo, NY
    MS-Off Ver
    2007
    Posts
    3

    Re: Ctrl + arrow key not working

    Thanks for the reply!
    CTR+END takes you to the bottom row and last column cell. I'm looking for a shortcut to go to the last cell (with data) in the row you're in.

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,210

    Re: Ctrl + arrow key not working

    Oh, sorry. If there are empty cells in a row, then a shortcut to the last column with data requires a macro. You can attach a shortcut key sequence to this macro, but it can only be CTRL followed by a lowercase or uppercase letter.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    02-02-2017
    Location
    Buffalo, NY
    MS-Off Ver
    2007
    Posts
    3

    Re: Ctrl + arrow key not working

    I can't thank you enough! A minor learning curve to figure out how to create this, but it works great and will save so much time!!

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,210

    Re: Ctrl + arrow key not working

    You're welcome! If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on Add Reputation icon.jpg below their name.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Ctrl + arrow key not working
    By DamienC in forum Excel General
    Replies: 9
    Last Post: 04-01-2016, 05:23 AM
  2. CTRL + SHIFT + DOWN ARROW not working
    By kxkxkxx in forum Excel General
    Replies: 4
    Last Post: 09-30-2014, 01:40 PM
  3. Recording dynamic range using ctrl+ arrow keys not working
    By akshay12 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-03-2014, 05:57 AM
  4. Ctrl + Arrow key isn't working the way I need it to
    By ipausa in forum Excel General
    Replies: 2
    Last Post: 01-29-2014, 11:00 AM
  5. CTRL + Arrow not working properly
    By rockets2010 in forum Excel General
    Replies: 2
    Last Post: 06-30-2011, 12:22 PM
  6. Can't use CTRL + Arrow to move
    By Dnsierra in forum Excel General
    Replies: 1
    Last Post: 12-12-2009, 03:09 PM
  7. Ctrl+Shift+arrow
    By briansetondavis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

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