HOW DO YOU

  • Thread starter Thread starter cjbarron5
  • Start date Start date
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
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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.
 

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

Back
Top