Down arrow jumps cursor to end of cell text


T

Timma

I can move normally between cells using up and down arrows unless I double
click into a cell to edit the text within that cell. Clicking the down arrow
now moves the cursor to the end of the cell text instead of to the cell
immediately below the active cell. Clicking the up arrow moves the cursor to
the begging of the cell text instead of to the cell immediately above the
active cell.
Any suggestions?
 
Ad

Advertisements

O

OssieMac

The arrows work to move form one cell to another if you simple enter data
then press an arrow. If you try to edit data in a cell then the arrows only
move the cursor within the cell. Reason for this is so that you can use the
arrow keys to move the cursor within the cell for editing purposes.
 
T

Timma

Ok, so this is by design and that makes sense to me, but I do tech support
and I know someone will eventually ask. Is there anyway around this? Anyway
to change the default behavior?

Thanks,
Timma
 
Ad

Advertisements

G

Gord Dibben

Tell them it cannot be changed and to use the Enter or Tab key to leave the cell
after editing.

Or don't double-click.......F2...edit........F2 then use the arrow keys to leave
the cell.


Gord Dibben MS Excel MVP
 

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

Top