Tab sequence or direction.

T

tamato43

Is there a way to specify the direction of a tab???

Example:

I have 2 Colums, 10 Cells In Column A (A1 through A10), and 10 Cells in column B (B1 through B10).

I'd Like to tab through Column A (1 through 10) before tabbing through Column B (1 through 10).

Right now I can only tab vertically, even after I've unlocked the specific cells I'm requesting to tab over to.
 
K

Ken Wright

Select A1:A10, hold down the CTRL key, select B1:B10 and then still with the
CTRL key held down select C1:C10. Now tab as normal and it will run down the
columns.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



tamato43 said:
Is there a way to specify the direction of a tab???

Example:

I have 2 Colums, 10 Cells In Column A (A1 through A10), and 10 Cells in column B (B1 through B10).

I'd Like to tab through Column A (1 through 10) before tabbing through Column B (1 through 10).

Right now I can only tab vertically, even after I've unlocked the specific
Click to expand...
cells I'm requesting to tab over to.
 
L

Leo Heuser

First select A1:B10
Now you can use <Tab>, <Shift><Tab>, <Enter> and <Shift><Enter>
to "tab" through the cells.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

tamato43 said:
Is there a way to specify the direction of a tab???

Example:

I have 2 Colums, 10 Cells In Column A (A1 through A10), and 10 Cells in column B (B1 through B10).

I'd Like to tab through Column A (1 through 10) before tabbing through Column B (1 through 10).

Right now I can only tab vertically, even after I've unlocked the specific
Click to expand...
cells I'm requesting to tab over to.
 
Top