Cursor navigation


A

ANelson

Where in 2007 can I find the options for the direction of the cursor to move
when I hit return? I feel so dumb!
 
Ad

Advertisements

N

Niek Otten

Office button (top left)>Excel Options>Advanced tab> there it is under Editing Options

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Where in 2007 can I find the options for the direction of the cursor to move
| when I hit return? I feel so dumb!
 
K

ksak

i have updated some new forms in Excel (have Vista but saving forms as
97-2003 format)
in my previous versions the cursor would move to the beginning of the
next line down
which i really, really like and need
i can't seem to get the new versions to do this
major changes include locking cells and protecting the page
am fine with forgoing these if it means my cursor will return to the
right place

would appreciate any help - please note that i'm a total newbie :)
thanks!
 
G

Gord Dibben

Previous versions required the use of the Tab and Enter keys.

Start in A1 and Tab across to F1 entering data as you go.

When leaving F1 hit the Enter key to go to B1


Gord Dibben MS Excel MVP
 
K

ksak

that's what i want to be able to do but won't work if the sheet is
protected
that's the only thing i've been able to find to allow this
 
Ad

Advertisements

G

Gord Dibben

Not sure what you need.

If sheet is protected with some unlocked cells, setting Enter key to move
right will move across unlocked cells then down to beginning of next row of
unlocked cells.

Tab key will do the same.

With sheet not protected, the Tab, Tab, Tab, Enter will work.


Gord
 

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