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.
do you have more than 1 sheet selected? Right click sheet tab and ungroup.
Can you CTRL+Home in other workbooks?
Hello,Originally Posted by Andy Pope
I am only on 1 sheet and no I can not CTRL+Home on any excel on my computer today.
I would start with a reboot.
The test the ctrl key in another application.
The test it in excel on a new workbook.
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.
Check setting Tools > Options > Transition > Transition navigation keys
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
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks