Tab control

[Jessica]

Hello,

I have Excel 2002 and have created a spreadsheet. Within
this spreadsheet I would like to have the tabs to return
to the beginning instead of going all the way over to the
end that is endless. Is the a way to set tab controls?

Thanks, for your advise

Jessica

 

[Frank Kabel]

Hi
just highligh your data range before entering values. This way after
reching the right end you should 'jump' to the next row. Also have a
look at 'Data - Form'

 

[Gord Dibben]

Jessica

Two methods.......

1. Unlock columns A through H then protect the worksheet. Use the TAB key to
move across the columns. When you reach H and hit TAB you will go back to A
and down one row.

2. Start entering data in column A(or any column) and TAB to next cell
across. When you reach H hit <ENTER> key to return to A(or start column) one
row down. No need for sheet protection with this method.

Gord Dibben Excel MVP