Previous Topic Next Topic

F 5 problem

Solved/Closed
selflearner Posts 16 Registration date Wednesday October 21, 2009 Status Member Last seen March 12, 2010 - Mar 10, 2010 at 12:35 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 12, 2010 at 08:55 AM
Hello,
Up untill yesterday, when I used F 5, the cell that I was going to always ended up in the upper left corner of the screen. Now it goes to somewhere on the right. Also, before when I used the "home" key, the cursor would go to A 1. Now it goes to A and the line it's in. Did I change a setting or something? I don't want to have to re-write macros. I'm using Excel 2007. I tried the F 5 function on a machine that has Excel 2003 and it's what I had before. I wanted to make sure I'm not losing my mind,

Mike
Related:

3 responses

Answer 1 / 3
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 10, 2010 at 12:46 PM
Nope you have not lost your mind. Press the scroll lock key and you will get back your old way.
http://office.microsoft.com/en-us/excel/HP100738481033.aspx
0
Answer 2 / 3
selflearner Posts 16 Registration date Wednesday October 21, 2009 Status Member Last seen March 12, 2010
Mar 10, 2010 at 05:08 PM
Hi rizvisa1,
I just tried that. It didn't help. I switched key boards in case the first one was broke. Still no luck. With the Scroll On and I press HOME, the cursor moves to the upper left of the screen. With the Scroll OFF and I press HOME, the cursor moves to the "A" row and stays on the same line. The Scroll button doesn't seem to effect the F 5 function. Either ON or OFF, it still goes to the requested cell, but instead of putting it on the upper left of the screen, it puts it on the right side, and not always on top. Sometimes in the middle right and sometimes lower right, Depending on which cell I try to go to. I went to the link and tried some of the short cut keys. They seemed to work fine.

Mike
0
Answer 3 / 3
selflearner Posts 16 Registration date Wednesday October 21, 2009 Status Member Last seen March 12, 2010
Mar 12, 2010 at 08:52 AM
Hi rizvisa1

I found that I had checked the Lotus navagation square in Excel options when I installed Excel and unchecked it a few days ago. When I re checked it, I'm back to normal. I checked the Excel version 2003 that I use for testing and it was checked. BUT I think I DID lose my mind. I don't remember checking it when I did the install last year, OR unchecking it recently.
Well, That's one problem solved...now for my mind...........
thanks for the help

Mike
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 12, 2010 at 08:55 AM
Thanks for sharing your finding. I am sure some one down the road will be so glad that you did.

Cheers!!
0