Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 10th 04, 09:05 PM
Peggy
 
Posts: n/a
Default 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   Report Post  
Old November 10th 04, 09:21 PM
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Old November 11th 04, 01:52 AM
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic links in Excel 2003 Jim Bud Excel Discussion (Misc queries) 4 January 13th 05 03:57 PM
Way to make Excel only run certain formulas on a worksheet? jrusso Excel Discussion (Misc queries) 0 January 12th 05 04:23 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
How do I convert an existing MS Excel worksheet tracking a simple. NOTANYJOE Excel Discussion (Misc queries) 1 January 4th 05 02:07 AM
How do I convert an existing MS Excel worksheet tracking a simple. [email protected] Excel Discussion (Misc queries) 0 January 4th 05 12:53 AM


All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017