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.

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

On Thu, 31 Aug 2006 07:57:02 -0700, setting a tab order in an excel spreadsh
<setting a tab order in an excel wrote:

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.

Gord Dibben MS Excel MVP