Navigating text in cells

J

Jonathan Finney

Pretty much anywhere you come across an editable text field, you can use the
cursor keys and common shortcuts (End, Home, Ctl+Cursor, etc) to navigate
text.

Anywhere, that is, except when editing text in an Excel cell where these
keys are used to navigate between the cells.

I don't understand why Excel can't tell when I'm editing within a cell and
react to these keys in the same way as any other editable text area. I
can't find any setting to change this.

It drives me mad because I use Excel quite a lot. Is there any way to
change this behaviour?
 
G

goober

Press F2 to edit the cell and the directional arrows will work like you
want them to.
 
J

Jonathan Finney

goober said:
Press F2 to edit the cell and the directional arrows will work like you
want them to.
Click to expand...

Thanks Goober.

All these years I'd never noticed the difference between entering text and
editing text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to use cursor to navigate active cells 4
Select cells with text 4
Locating differences in text when comparing two cells 10
Changing Text Case 12
Selecting cells in Excel 3
Default Cell Editing Behavior and the F2 key 5
Problem when navigating between cells 2
CF on Consecutive cells 1

Top