can you make the cursor move to the next cell automaticlly after information
is entered and can you make it skip cells that fill with results of formulas

can you make the cursor move to the next cell automaticlly after
information
is entered

Tools Options Edit and check "Move selection after enter and select the
direction you want.

is entered and can you make it skip cells that fill with results of
formulas

Can be done but needs VBA

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"cjbarron5" wrote in message
...
can you make the cursor move to the next cell automaticlly after
information
is entered and can you make it skip cells that fill with results of
formulas

If you unlock the cells that you want users to access, protect the sheet and
choose "select unlocked cells only" option, it will automatically skip all
the locked cells.


"cjbarron5" wrote in message
...
can you make the cursor move to the next cell automaticlly after
information
is entered and can you make it skip cells that fill with results of
formulas

This old post describes one way to approach this:

http://tinyurl.com/3kksgy


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"cjbarron5" wrote in message
...
can you make the cursor move to the next cell automaticlly after
information
is entered and can you make it skip cells that fill with results of
formulas