Tab Order

  • Thread starter Thread starter Graham Clements
  • Start date Start date
G

Graham Clements

Hi all,

I wonder if any of you could help. I have a
spreadsheet which has the appearence of a form,
containing questions and input boxes. I would like data
entry to be as easy as possible, one possibility is to
enable the user to use the tab button to jump from input
box to input box. I have seen it done before but cannot
work out how it is done. Could someone help me to make
this happen?

Graham
 
Graham

I've never done it, but I've seen it suggested!! Select each cell in the
order you want (using Ctrl and click), strating with the second and
finishing with the first, and then give the range a name. If you select that
range now, tabbing will take you through the cells in the order you want.

HTH
Andy.
 
Thanks Andy but this doesn't work in the same way to the
one I've seen. The problem with this method is that it
is simply a selection and therefore behaves like a
selection, so when you click out of it all is lost as
well as the tab order until you choose the named group
again.

The one I saw constantly moved to the next tab point in
the order whereever the user clicks. Similar to how a
tab order is used in MS Access forms, but it was a
spreadsheet.

Any more ideas???
 
If you don't like selecting the range first, maybe you could unlock those cells
(that get jumped to), lock all the other ones and then turn on
Tools|Protection|protect sheet.

Then the tab key will take you to only those cells that are unlocked. (But
depending on your layout, it might not be the pattern you want.)
 
Back
Top