Can I contol Tab Order in a worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to control the tab order of an Order Entry sheet I'm creating. Can
I do this or would I have to recreate it as a form?

Thanks
 
Hi,

If i understand your question correctly you want the tab to follow a certain
sequence of cells. This is what you can try to do.

Select the various cells that you want to associate with the tab command
Select non-contiguous cells by holding down the ctrl key
Now go to the "Name box" on the extreme left and give a name to the range
you have selected.

When you want to enter something in that specific range enter the name inthe
"Name box" and then scroll throgh the cells youy selected earlier by using
the tab key

Regards,

Ashish Mathur
 

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