Automatic return in an excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Returning a Value from Another Worksheet 2
Hide columns based on row values 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Formula (or code) return the largest number of duplicates in a list. 16
Merging Excel Sheet with Excel Sheet (Just like in MS Word!) 3
Formula/Function for parsing data 5

Back
Top