Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
tskaiser
 
Posts: n/a
Default how to move the cursor to column A after entering data column F

Is there a way when entering data in a spreadsheet - to have the cursor move
to column A after entering data in Column F or beyond?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Rae Drysdale
 
Posts: n/a
Default how to move the cursor to column A after entering data column F

If you enter data across the worksheet press tab, when you have entered the
data in column F press the Enter key. Check also Tools | Options |Edit that
you have selected Down in the Move selection after Enter. Does this work for
you?
--
Rae Drysdale


"tskaiser" wrote:

Is there a way when entering data in a spreadsheet - to have the cursor move
to column A after entering data in Column F or beyond?

  #3   Report Post  
Posted to microsoft.public.excel.newusers
excelent
 
Posts: n/a
Default how to move the cursor to column A after entering data column

try this (put in sheet module)

Private Sub Worksheet_Change(ByVal Target As Range)
If ActiveCell.Column = 6 Then ActiveCell.Offset(, -ActiveCell.Column +
1).Select
' If ActiveCell.Column = 6 Then ActiveCell.Offset(-1, -ActiveCell.Column +
1).Select ' if u want same row
End Sub



"tskaiser" wrote:

Is there a way when entering data in a spreadsheet - to have the cursor move
to column A after entering data in Column F or beyond?

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
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 07:16 PM
How do you Stop Entering Duplicate Data in a Column? Satraj Excel Worksheet Functions 7 November 4th 05 02:04 PM
How can I cut data from one column and move it to another. mhbond999 New Users to Excel 2 October 16th 05 03:06 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM


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

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"