Cell Navigation with Arrow Keys Solved

Question

Good evening everyone,

Who could help me:
- I am using an iMac with OS X Lion 10.7
- with Excel 2008 for Mac
- how can I configure Excel to move from one cell to another using the arrow keys, something I used to do before?

THANK YOU in advance for your help.

Paul A.

Configuration: Mac OS X Lion (10.7) / Firefox 17.0

cristo · Accepted Answer

THANK YOU For me, who doesn't have a F14 key, it's on the "scroll lock" button that one should press (

Raymond PENTIER · Answer

It's not Excel that needs to be configured, but the keyboard ...  -- Retirement is great! Especially in the Caribbean ... :-) &#9787; Raymond &#9794;

Paul A · Answer

THANK YOU for your help!

Since I don't know how to configure the keyboard, I continued searching on the forum and I found:
To enable cell-by-cell navigation in Excel on Mac OS X, you need to press the F14 key.

Have a great day and see you later!

val · Answer

Thank youuuu to Paul A!

RDX · Answer

Indeed, it is the keyboard configuration that is to blame. So, no need to look in the options of Excel, regardless of the version of Excel.

My two cents concern Windows users: for Windows, you have to play with the "Scroll Lock" key.

Positions of the "Scroll Lock" key:
- Scroll Lock ON = the arrow keys will scroll the page
- Scroll Lock OFF = the arrow keys will move from cell to cell.

On my laptop keyboard, the "Scroll Lock" key is combined with the "Num Lock" key, and I have to press the Fn key together with the "Scroll Lock" key to get the expected result.
In conclusion, you need to juggle with the keys to get what you expect from their functions:
- change scrolling type = Fn + "Scroll Lock/Num Lock" key,
- change functions of the numeric keypad = press only the "Scroll Lock/Num Lock" key.

Cell Navigation with Arrow Keys

5 réponses

Samsung j5 unable to answer

Scam of the suvedene highway

Internet connection problem with my ipad

Free box: remote control broken

Suspicious number text message

I receive calls from unallocated numbers.

Minecraft restore the cursor and the bar.

My ps3 keeps shutting down on its own...

Samsung series 4 led tv logo display...

How to enable bluetooth on a samsung tv?