Customize TAB key ?

  • Thread starter Thread starter Kinner
  • Start date Start date
K

Kinner

Hello,

Is there a way to customize the TAB key so that I can
configure the directions that the cursor moves?

For example, I would like to move from cell A1 to A5 then
from A5 to B7 just by hitting the TAB key twice.

I made a form in Excel for people to fill in but I've
been getting lots of compliant from users that it's hard
to navigate through fields.

Thanks in advance.
Kinner
 
By unlocking the cells you want data entered into and then
protecting the worksheet. Cells are locked by default,
but the locking is not effective until the worksheet is protected.

Format, Cells, Protection
Tools, Protection
 
No, but if you turn it into a form and lock it, tab should
cycle you through only those cells which allow data entry.

Jane
 
Worked great! Thanks!
-----Original Message-----
No, but if you turn it into a form and lock it, tab should
cycle you through only those cells which allow data entry.
.
 

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