Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic return in an excel worksheet
How do you set up for an automatic return from the last column to return to
the first column in a spreadsheet? |
#2
|
|||
|
|||
Hi
if you want this for entries just select your data range before starting entering values -- Regards Frank Kabel Frankfurt, Germany "Peggy" schrieb im Newsbeitrag ... How do you set up for an automatic return from the last column to return to the first column in a spreadsheet? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Automatic links in Excel 2003 | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) |