Tabs on excel worksheets

  • Thread starter Thread starter Phyllis
  • Start date Start date
P

Phyllis

Can tabs be set in excel to tab to predefined cells? I can't find this
answer anywhere.
I want to be able to set tabs to go from one unlocked cell to another to
facilitate data input.

If it can be done, can you point me to somewhere where it discusses how?
 
When you protect the sheet, if you uncheck the selection that allows users to
select locked cells, then the Tab key will cycle through only the unlocked
ones.
 
If your input cells are in a left to right, top to bottom sequence,
unlocking input cells and Tabbing to them will work.

If not in that sequence you can create a named range in the order you want.

Start with last cell in order then CTRL + Click your way through the
sequence.

See Bob Phillips' site for more on this.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

You can also use VBA to tab through a sequence of cells.

If you want that, post back.


Gord Dibben MS Excel MVP
 
Back
Top