Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j pantozzi
 
Posts: n/a
Default need enter key to move to the next column beginning

I know how to change the direction up down left right but I need it to go
back to column A next row.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR
 
Posts: n/a
Default need enter key to move to the next column beginning

Simplest way is to use <Tab to move your cursor (focus) right, then hit
<Enter after the last data entry, which *automatically* moves the focus to
the cell *under* the first cell that you used <Tab on.

So, if you start in A10, and tab across to K10, hitting <Enter brings you
to A11.

Start in J100, and you'll be brought back to J101.

--

HTH,

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

"j pantozzi" <j wrote in message
...
I know how to change the direction up down left right but I need it to go
back to column A next row.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j pantozzi
 
Posts: n/a
Default need enter key to move to the next column beginning

Maybe I said it wrong. In the past every time I press enter the cell that it
goes back to ir the next row column A In other words it will go from column
F4 to A5.

I am a novice at this but this is confounding me.

"RagDyeR" wrote:

Simplest way is to use <Tab to move your cursor (focus) right, then hit
<Enter after the last data entry, which *automatically* moves the focus to
the cell *under* the first cell that you used <Tab on.

So, if you start in A10, and tab across to K10, hitting <Enter brings you
to A11.

Start in J100, and you'll be brought back to J101.

--

HTH,

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

"j pantozzi" <j wrote in message
...
I know how to change the direction up down left right but I need it to go
back to column A next row.



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
IF/AND/OR/DATEIF Issue...sorry...long post... EDSTAFF Excel Worksheet Functions 1 November 10th 05 12:28 AM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
match and count words David Excel Worksheet Functions 5 July 4th 05 02:24 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
Search column and move text formula tommy Excel Discussion (Misc queries) 0 February 8th 05 06:55 PM


All times are GMT +1. The time now is 03:00 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"