An open community 
of Macintosh users,
for Macintosh users.

FineTunedMac Dashboard widget now available! Download Here

Previous Thread
Next Thread
Print Thread
Excel Navigation - Arrow Keys
#19425 12/01/11 03:55 PM
Joined: Aug 2009
Likes: 14
ryck Offline OP
OP Offline

Joined: Aug 2009
Likes: 14
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?

Last edited by ryck; 12/01/11 03:56 PM.

ryck

"What Were Once Vices Are Now Habits" The Doobie Brothers

iMac (Retina 5K, 27", 2020), 3.8 GHz 8 Core Intel Core i7, 8GB RAM, 2667 MHz DDR4
OS Ventura 13.6.3
Canon Pixma TR 8520 Printer
Epson Perfection V500 Photo Scanner c/w VueScan software
TM on 1TB LaCie USB-C
Re: Excel Navigation - Arrow Keys
ryck #19428 12/01/11 07:26 PM
Joined: Aug 2009
Likes: 15
Online

Joined: Aug 2009
Likes: 15
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.

Last edited by artie505; 12/01/11 07:28 PM.

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
Re: Excel Navigation - Arrow Keys
ryck #19429 12/01/11 07:29 PM
Joined: Aug 2009
Likes: 14
ryck Offline OP
OP Offline

Joined: Aug 2009
Likes: 14
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.

Last edited by ryck; 12/01/11 07:35 PM.

ryck

"What Were Once Vices Are Now Habits" The Doobie Brothers

iMac (Retina 5K, 27", 2020), 3.8 GHz 8 Core Intel Core i7, 8GB RAM, 2667 MHz DDR4
OS Ventura 13.6.3
Canon Pixma TR 8520 Printer
Epson Perfection V500 Photo Scanner c/w VueScan software
TM on 1TB LaCie USB-C
Re: Excel Navigation - Arrow Keys
ryck #19433 12/01/11 10:39 PM
Joined: Aug 2009
Likes: 1
Moderator
Offline
Moderator

Joined: Aug 2009
Likes: 1
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

Moderated by  alternaut, dianne, dkmarsh 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.4.33 Page Time: 0.015s Queries: 22 (0.011s) Memory: 0.5851 MB (Peak: 0.6428 MB) Data Comp: Zlib Server Time: 2024-03-29 10:15:01 UTC
Valid HTML 5 and Valid CSS