Tab control

  • Thread starter Thread starter Jessica
  • Start date Start date
J

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
 
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'
 
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
 
Back
Top