Home
Posted By: ryck Excel Navigation - Arrow Keys - 12/01/11 03:55 PM
The default for keyboard arrow keys in Excel is that they allow cell-by-cell navigation in the direction of whichever arrow is selected.

My keyboard has changed. The arrow keys now move the entire sheet the distance of a row or a column, on each arrow key entry, depending which arrow is used. That is, if I selected cell R23 and pressed the up arrow, cell R23 remains highlighted but the entire sheet moves.

This has started happening since I used TechTool Pro to run some routine tests so I assume it has reset something. Any ideas on what I would do to restore the default settings?
Posted By: artie505 Re: Excel Navigation - Arrow Keys - 12/01/11 07:26 PM
I'm not at all certain, but in my Excel X, Preferences > Edit > Move selection after Return looks like it may be what you're looking for.

Hope this helps.

Edit: On second thought, I'm less certain than I originally was.
Posted By: ryck Re: Excel Navigation - Arrow Keys - 12/01/11 07:29 PM
As Rosanna Rosanna Danna used to say: "Never mind."

It turns out there are Mac key equivalents to Windows keyboard keys. The Scroll Lock key on a Windows keyboard is Control F-14 on a Mac keyboard. However, I was able to get back to normal functioning by hitting F-14 (without the Control key).

I have no idea how I could have accidentally hit Control F-14 as I don't use the numbered Function keys.
Posted By: alternaut Re: Excel Navigation - Arrow Keys - 12/01/11 10:39 PM
Interesting. I checked Excel Help for the various keyboard shortcuts, and F14 doesn't feature there at all. A search for Control+F14 yields a bunch of returns based on Control, not F14. But when I used the Control+F14 combo in Excel, I got exactly the the arrow key response you described. Go figure.
© FineTunedMac