Tab order

[jambun]

Is there a way of setting the tab order in a spreadsheet ie: I want to
tab from Column C through each column to column U, although the input
then continues from column Z to column AQ I want to operate between C
& U so that it does not jump to column Z, (Columns V,W,X,and Y are
protected to record results of formulas ). Once I have recorded the
information in the above columns I will then be moving to columns Z
through to column AQ and need to stay within these columns. I hope
that this is clear.
Thanks,
jambun

 

[Shane Devenshire]

Hi,

There is nothing built-in to Excel to do this you could write code, but of
course you will have to nail down exactly what you want to happen. For
example, if a cell in the first range is missed would you be allowed to move
to second region. Do you fill in a row or how many rows in the first region
before you can move to the second region. Once in the second region can you
move back to the first region, if so when. When you've entered data in both
regions, what then.

Cheers,
Shane Devenshire

 

[Satti Charvak]

Hi Jambun,

For all practical purposes, why don't you just hide the columns that you
don't want to use, your question will be solved.

Like in your first case only open columns c to u, and hide all others.

when done, open all the columns then hide all others except columns z to aq
ans o on.

No macros ....ho headache ........just joking

 

[jambun]

On Wed, 26 Nov 2008 22:12:01 -0800, Shane Devenshire

Shane, The first set of columns record the scores of each hole of Golf
for day one,each row is for a different player. So I tab across each
hole and enter the score, then go down to the row needed to enter the
next players score. The next set of columns are for day 2's score. The
problem I have is that when I get to hole 18 on Day 1 by tabbing
across the row, if I tab again I end up on day 2's columns and need to
scroll back to day 1 to enter the next player. There are ways to
overcome this problem ie: by having the days on separate sheets and
combining the scores for count back an another sheet but I am trying
to make it easier for someone that is not sure of what is happening.
Hope this makes sense
Thanks
Jambun

 

[Gord Dibben]

Tab your way across to hole 18 then hit ENTER key to drop back down to the
cell below your start point.

i.e. start in C2, Tab across to U2............ENTER will take you to C3


Gord Dibben MS Excel MVP