+ Reply to Thread
Results 1 to 5 of 5

CTRL + SHIFT + DOWN ARROW not working

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    Walnut Creek, Ca
    MS-Off Ver
    Windows 7
    Posts
    18

    Question CTRL + SHIFT + DOWN ARROW not working

    Not sure what happened...but every time I use this very helpful shortcut, it now goes to the bottom of excel...it will not stop at the last cell of data....did I somehow disable this?

    thanks in advance for any help!

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,533

    Re: CTRL + SHIFT + DOWN ARROW not working

    found this on another site...
    http://www.mrexcel.com/forum/excel-q...t-working.html

    Just posting a reply in case anyone else has this issue like I just did. The reply above worked to an extent but being that I'm using Excel 2007; it was a tad different to get to it.
    In Excel 2007; Hit the upper left round Menu button. Click Excel Options at the bottom. Choose Advanced on the left, and scroll all the way down to "Lotus Compatibility". Uncheck the Transition Navigational Keys box.
    Worked like a charm! Thanks!

    <><><><>
    maybe that will work for you?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    07-02-2014
    Location
    Walnut Creek, Ca
    MS-Off Ver
    Windows 7
    Posts
    18

    Re: CTRL + SHIFT + DOWN ARROW not working

    Thank you...mine was already unchecked....it works fine if I am selecting data in a column...it will go to the end of that data...no issue there.....but if I insert a column next to it, enter a value in the first cell, and then want to select all of the blanks cells below to paste the same value, it goes to the bottom of excel.....normally, it would look at the column next to it and stop at the same row where the last cell of data is in that column...make sense?

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,533

    Re: CTRL + SHIFT + DOWN ARROW not working

    Makes sense and that has happened to me at times.
    Usually when I've had my excel open for a week or longer (I'll work on it one day then again the next) and it seems with time mine gets flacky.
    Usually I save things, log out then back in and it works fine after that.
    But if I don't want to do that I will go down to the last cell in the column you refer to that has data, go to the next column and put an "x" or something there, then go back up to the top then do the double click to have what i want autopopulated into that column and it will stop when it reaches the "x".

  5. #5
    Registered User
    Join Date
    07-02-2014
    Location
    Walnut Creek, Ca
    MS-Off Ver
    Windows 7
    Posts
    18

    Re: CTRL + SHIFT + DOWN ARROW not working

    Ok, that's a nice shortcut...thanks for the reply!

+ 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 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
  2. [SOLVED] Ctrl-Shift-Arrow combination does not work
    By ch in forum Excel General
    Replies: 1
    Last Post: 09-28-2005, 10:05 PM
  3. Replies: 1
    Last Post: 08-03-2005, 09:05 AM
  4. CTRL+Shift+Arrow Doesn't Work
    By Elon in forum Excel General
    Replies: 2
    Last Post: 05-25-2005, 08:21 AM
  5. [SOLVED] Ctrl+Shift+arrow
    By briansetondavis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

Tags for this Thread

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