ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I automatically move down to the next row? (https://www.excelbanter.com/new-users-excel/143115-how-do-i-automatically-move-down-next-row.html)

mlacigam

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?

RagDyeR

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?



Stan Brown

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/


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com