An open community 
of Macintosh users,
for Macintosh users.

FineTunedMac Dashboard widget now available! Download Here

Topic Options
#19425 - 12/01/11 07:55 AM Excel Navigation - Arrow Keys
ryck Online


Registered: 08/04/09
Loc: Okanagan Valley
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?


Edited by ryck (12/01/11 07:56 AM)
_________________________
ryck

iMac (Retina 5K, 27", 2017), 3.4 GHz Intel Core i5, 8GB RAM, 2400 MHz DDR4
OS High Sierra 10.13.6
Canon MX712 Printer
Epson Perfection V500 Photo Scanner
Time Machine on 320GB OWC Mercury OTG Pro
Super Duper on 500GB OWC Mercury OTG Pro

Top
#19428 - 12/01/11 11:26 AM Re: Excel Navigation - Arrow Keys [Re: ryck]
artie505 Online


Registered: 08/04/09
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.


Edited by artie505 (12/01/11 11:28 AM)
_________________________
The new Great Equalizer is the SEND button.

In Memory Of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire

Top
#19429 - 12/01/11 11:29 AM Re: Excel Navigation - Arrow Keys [Re: ryck]
ryck Online


Registered: 08/04/09
Loc: Okanagan Valley
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.


Edited by ryck (12/01/11 11:35 AM)
_________________________
ryck

iMac (Retina 5K, 27", 2017), 3.4 GHz Intel Core i5, 8GB RAM, 2400 MHz DDR4
OS High Sierra 10.13.6
Canon MX712 Printer
Epson Perfection V500 Photo Scanner
Time Machine on 320GB OWC Mercury OTG Pro
Super Duper on 500GB OWC Mercury OTG Pro

Top
#19433 - 12/01/11 02:39 PM Re: Excel Navigation - Arrow Keys [Re: ryck]
alternaut Offline

Moderator

Registered: 08/04/09
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.
_________________________
alternaut moderator

Top

Moderator:  alternaut, dianne, dkmarsh