+ Reply to Thread
Results 1 to 8 of 8

Ctrl - home isnt going home on sheet for sorting

  1. #1
    Registered User
    Join Date
    08-07-2006
    Posts
    19

    Ctrl - home isnt going home on sheet for sorting

    Hello,
    Yes I know I am the one with the most simple questions yet these are the little things that trip me up.

    I have several spread sheets I sort daily, now suddenly today when I hit Ctrl / home it wont go home and I can not sort the sheet.

    Any suggestions would be wonderful.
    Thank you,

    Last edited by VBA Noob; 11-07-2008 at 01:59 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,934
    do you have more than 1 sheet selected? Right click sheet tab and ungroup.

    Can you CTRL+Home in other workbooks?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-07-2006
    Posts
    19
    Quote Originally Posted by Andy Pope View Post
    do you have more than 1 sheet selected? Right click sheet tab and ungroup.

    Can you CTRL+Home in other workbooks?
    Hello,
    I am only on 1 sheet and no I can not CTRL+Home on any excel on my computer today.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,934
    I would start with a reboot.
    The test the ctrl key in another application.
    The test it in excel on a new workbook.

  5. #5
    Registered User
    Join Date
    08-07-2006
    Posts
    19
    Quote Originally Posted by Andy Pope View Post
    I would start with a reboot.

    I have rebooted still no luck.

    The test the ctrl key in another application.

    CTRL key works outside of Excel.

    The test it in excel on a new workbook.


    5 new work books now and no different then the old ones. I am pulling my hair out on this one.


    In addition when I do CTRL+HOme it goes to a random cell different every time but never home.
    Last edited by photo_angel2004; 11-07-2008 at 11:47 AM.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,934
    Check setting Tools > Options > Transition > Transition navigation keys

  7. #7
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577
    It doesn't sound like this is your problem but FYI, if you are using "Freeze Panes" the cursor will not go to A1 but to where you froze the panes.
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  8. #8
    Registered User
    Join Date
    08-07-2006
    Posts
    19
    Quote Originally Posted by Andy Pope View Post
    Check setting Tools > Options > Transition > Transition navigation keys
    That was it that was the trick.
    Thank you so much, someone must have been on my computer, I have never changed those settings.

    Thanks again,

    (time for a new password)

+ 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