Automatic return in an excel worksheet

[Peggy]

How do you set up for an automatic return from the last column to return to
the first column in a spreadsheet?

 

[Frank Kabel]

Hi
if you want this for entries just select your data range before
starting entering values

 

[Gord Dibben]

Peggy

Do you really mean "last column" as in IV, or just last column with data?

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 "last column" 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