HOW DO YOU

C

cjbarron5

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
 
S

Sandy Mann

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

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
Click to expand...

Can be done but needs VBA

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
G

Gaurav

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.
 
Top