how do i set the tab order for a user to fill out worksheet cells

  • Thread starter setting a tab order in an excel spreadsh
  • Start date
S

setting a tab order in an excel spreadsh

I have a basic worksheet that I want to set the tab order in so that the user
does nothave to manually tab through the 1st part of the worksheet. Once
they get to the basic part, it is fine to go by row, 1 cell at a time.
 
G

Gord Dibben

You can give the range a name and ENTER your way through the cells in the order
you wish.

See Bob Phillips's site for methods of naming a range.

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

Don't be put off by the title "Tab to selected cells". There is a method of
using the ENTER key.

Also see alternate methods of tabbing through using Protected cells.


Gord Dibben MS Excel MVP

I have a basic worksheet that I want to set the tab order in so that the user
does nothave to manually tab through the 1st part of the worksheet. Once
they get to the basic part, it is fine to go by row, 1 cell at a time.
Click to expand...

Gord Dibben MS Excel MVP
 
Top