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
 
Top