auto return to column A but of next row

H

herbie000

Is there an easy way to auto return to column A but of next row.
would like to be able to do this automatically say when column 87 i
reached. I could just arrow down and hit home but there must be a wa
to automate this. I am currently in 2003 but will be moving to 2007 i
a few months. Thanks in advance
 
G

Gord Dibben

Start in A1........Tab, Tab, Tab across to column 87.

Leave column 87 by hitting ENTER key to go back to A2

Or lock all columns from 88 onward, unlock 1 to 87

Protect the worksheet and use the Tab key all the way across.


Gord Dibben MS Excel MVP
 

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

The next Grand Theft Auto title has been officially announced 0
Find values across a row and return a text value from the same column 2
hit enter in any column and go to next row in first column 3
Auto fit row height for one column 3
go to fitst column of next row when enter (or other key) is presse 1
In excel I want the return key to move down a row not over a col 3
Auto Filter skips first row 3
Auto re-numbering when a row is deleted 3

Top