Automatic return in an excel worksheet
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Peggy" schrieb im Newsbeitrag
...
How do you set up for an automatic return from the last column to
return to
the first column in a spreadsheet?

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

On Wed, 10 Nov 2004 13:05:02 -0800, "Peggy"
wrote:

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