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

(e-mail address removed)
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.
 

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

Similar Threads

Email Address 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel 2003-skip to another cell upon leaving 7
Excel Macro to automatically go to the right of the last colored cell 0
average range growing 2
Macro triggered by an event 2
Conditional Formatting Problem 2

Top