auto return to column A but of next row

  • Thread starter Thread starter herbie000
  • Start date Start date
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
 
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
 
Back
Top