setting tabs

  • Thread starter Thread starter Lucy Kochanny
  • Start date Start date
L

Lucy Kochanny

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

Please advise
 
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

Back
Top