![]() |
|
|
|
Dept store Quartermaster
Join Date: Jul 2001
Location: I'm right here Tati
Posts: 19,858
|
Quick and stupid Excel question
I use Excel all the time and have never had this happen before. I normally use the arrow keys to jump around the cells and enter data, but all of a sudden the arrow keys are not moving from cell to cell, but moving the whole page. What did I do?
__________________
Cornpoppin' Pony Soldier |
||
![]() |
|
Registered
|
Press escape (esc) ?
__________________
2018 VW Golf R 5 door + 1991 Mazda MX5 Eunos + 2010 MX5 folding hard top. Nikon D810 SLR and a gazillion lenses. Lumix LX3 and Canon SX720HS (40 x zoom) , Leica DLUX 109 (really a Panasonic) |
||
![]() |
|
Dept store Quartermaster
Join Date: Jul 2001
Location: I'm right here Tati
Posts: 19,858
|
No dice.
__________________
Cornpoppin' Pony Soldier |
||
![]() |
|
Moderator
|
Press Scroll Lock.
__________________
Don Plumley M235i memories: 87 911, 96 993, 13 Cayenne |
||
![]() |
|
Registered
Join Date: Sep 2005
Location: CT
Posts: 283
|
press the liberal media key
|
||
![]() |
|
Registered
|
"to quickly move more than one cell in any direction, press the END key and then press the arrow key that points in the direction you are heading. If you get numbers instead of moving your numlock key is on."
So try pressing the END key to get rid of it.
__________________
2018 VW Golf R 5 door + 1991 Mazda MX5 Eunos + 2010 MX5 folding hard top. Nikon D810 SLR and a gazillion lenses. Lumix LX3 and Canon SX720HS (40 x zoom) , Leica DLUX 109 (really a Panasonic) |
||
![]() |
|
![]() |
Dept store Quartermaster
Join Date: Jul 2001
Location: I'm right here Tati
Posts: 19,858
|
None of those worked, this is weird.
__________________
Cornpoppin' Pony Soldier |
||
![]() |
|
Registered
|
Save it under a new name , close excel, reopen exel and saved sheet.
__________________
2018 VW Golf R 5 door + 1991 Mazda MX5 Eunos + 2010 MX5 folding hard top. Nikon D810 SLR and a gazillion lenses. Lumix LX3 and Canon SX720HS (40 x zoom) , Leica DLUX 109 (really a Panasonic) |
||
![]() |
|
Dept store Quartermaster
Join Date: Jul 2001
Location: I'm right here Tati
Posts: 19,858
|
Don was right, but I had to hold down my F-mode button while hitting scroll lock. Strange as all get out. Thanks.
__________________
Cornpoppin' Pony Soldier |
||
![]() |
|
Registered
Join Date: Mar 2004
Location: S.E. Pennsylvania
Posts: 1,967
|
Go to Tools, Options and then to Transition and tell me what is selected.
However before you do that, Hold the shift key down and hit the "tab" key.
__________________
The Fox Carrera |
||
![]() |
|
Dept store Quartermaster
Join Date: Jul 2001
Location: I'm right here Tati
Posts: 19,858
|
Quote:
__________________
Cornpoppin' Pony Soldier |
||
![]() |
|
Registered
Join Date: Mar 2004
Location: S.E. Pennsylvania
Posts: 1,967
|
Yes, in excel, up top you'll see Tools.
__________________
The Fox Carrera |
||
![]() |
|
Dept store Quartermaster
Join Date: Jul 2001
Location: I'm right here Tati
Posts: 19,858
|
Quote:
"Microsoft Excel menus"
__________________
Cornpoppin' Pony Soldier |
||
![]() |
|
Registered
Join Date: Mar 2004
Location: S.E. Pennsylvania
Posts: 1,967
|
What happens when you select a cell and hit shift/Tab. You should move left from cell to cell. If you hit the Tab key you should move to the right. Does this happen?
__________________
The Fox Carrera |
||
![]() |
|
Dept store Quartermaster
Join Date: Jul 2001
Location: I'm right here Tati
Posts: 19,858
|
Quote:
But keep in mind that I've got it working correctly now via [F-mode] + [scroll lock]
__________________
Cornpoppin' Pony Soldier |
||
![]() |
|