View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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?