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?
|