Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto return to column A but of next row
Is there an easy way to auto return to column A but of next row. I would like to be able to do this automatically say when column 87 is reached. I could just arrow down and hit home but there must be a way to automate this. I am currently in 2003 but will be moving to 2007 in a few months. Thanks in advance! -- herbie000 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto return to column A but of next row
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 On Tue, 8 Dec 2009 02:00:47 +0000, herbie000 wrote: Is there an easy way to auto return to column A but of next row. I would like to be able to do this automatically say when column 87 is reached. I could just arrow down and hit home but there must be a way to automate this. I am currently in 2003 but will be moving to 2007 in a few months. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I auto refresh a column that has an auto filter in place | Excel Discussion (Misc queries) | |||
How can I set up an auto return to the next column in excell? | Excel Worksheet Functions | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
HOW DO I CREATE AN AUTO RETURN IN A COLUMN THAT IS OFF MY WORKSHEE | Excel Worksheet Functions | |||
Auto Return | Excel Discussion (Misc queries) |