Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How do I automatically move down to the next row?

For example, I only need my spreadsheet to go to column H. Is there a way I
can get it to jump down a row and to column A every time I hit tab after
column H? I saw one question that had some really complicated macro
thingamahoozer that I didn't understand at all. Is there a simpler way?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default How do I automatically move down to the next row?

Keep hitting <Tab until you come to Column H.
Then hit <Enter.
This will take you to the next row, and to whatever column you were in when
you hit <Tab the first time.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"mlacigam" wrote in message
...
For example, I only need my spreadsheet to go to column H. Is there a way I
can get it to jump down a row and to column A every time I hit tab after
column H? I saw one question that had some really complicated macro
thingamahoozer that I didn't understand at all. Is there a simpler way?


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 524
Default How do I automatically move down to the next row?

Thu, 17 May 2007 09:38:01 -0700 from mlacigam
:
For example, I only need my spreadsheet to go to column H. Is there a way I
can get it to jump down a row and to column A every time I hit tab after
column H? I saw one question that had some really complicated macro
thingamahoozer that I didn't understand at all. Is there a simpler way?


You want to hit Enter, not Tab.

If it doesn't work, go into Tools | Options | Edit and set "Move
selection after Enter" to Down.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
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
Automatically move cursor when cell value changes scotty New Users to Excel 0 January 19th 07 08:15 PM
automatically move row to another worksheet CA enpet Excel Discussion (Misc queries) 0 August 4th 06 09:49 PM
Move automatically to a cell Box666 Excel Discussion (Misc queries) 2 October 15th 05 10:34 AM
Automatically move arrows Y2DRE Excel Discussion (Misc queries) 0 July 20th 05 01:09 PM
Automatically move down to the next row Pank Mehta Excel Discussion (Misc queries) 5 May 9th 05 01:01 PM


All times are GMT +1. The time now is 06:04 AM.

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

About Us

"It's about Microsoft Excel"