LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How can I set up an auto return to the next column in excell?

I am entering data in sets of three cells in each column on a spreadsheet.
Can I set up an auto return so that when I hit "enter" on the third cell, it
will automatically go to the first cell in the next column? (Bascially set up
a pattern such as - <enter=go down one cell, <enter=go down one cell,
<enter=go up two cells and right one cell.)
 
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
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
HOW DO I CREATE AN AUTO RETURN IN A COLUMN THAT IS OFF MY WORKSHEE LINDA Excel Worksheet Functions 5 August 16th 06 03:43 PM
Return the column name using if function. pblenis Excel Discussion (Misc queries) 2 August 2nd 06 02:56 AM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Lookup values in one column to return another [email protected] Excel Worksheet Functions 4 November 17th 05 09:42 PM


All times are GMT +1. The time now is 12:16 PM.

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

About Us

"It's about Microsoft Excel"