setting tabs

L

Lucy Kochanny

Can I set tabs to skip fields I don't want to stop at when
using the tab key?

Please advise
 
C

Charlie

Lucy,

You could turn on protection. Go to Format Cell and
uncheck Locked for the cells requiring data entry. Next
use Tools/Protection/Protect Sheet. A password is not
required. Now the Tab key will only advance to the
unprotected cells and skip over the protected cells.

Charlie O'Neill
 

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