+ Reply to Thread
Results 1 to 4 of 4

How do I program Excel to return to column A after pressing return/enter?

  1. #1
    Registered User
    Join Date
    10-18-2018
    Location
    Mobile, AL
    MS-Off Ver
    Office 365 (2016)
    Posts
    9

    How do I program Excel to return to column A after pressing return/enter?

    What is the setting called that I use to move the cursor to the first cell in the row in column A after pressing enter. It's a simple setup, but the problem is deceptively simple.

    We have 3 columns: Last Name, First Name, Payrate
    I just split these columns into 3 from a single column my payroll lady was using so we could actually use formulas to calculate based on their payrate. (and sort by last name only)

    Problem is, when she enters, name[tab] name[tab] payrate [ENTER] - it's going to the next row in the Payrate column (C). We want it to return to Last Name in the next row. Is there a way to do this easily?

    We ARE utilizing Excel Online for collaboration purposes.

  2. #2
    Registered User
    Join Date
    10-15-2018
    Location
    Iran
    MS-Off Ver
    2013
    Posts
    30

    Re: How do I program Excel to return to column A after pressing return/enter?

    Hello
    Look at this file
    Do you mean this?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-18-2018
    Location
    Mobile, AL
    MS-Off Ver
    Office 365 (2016)
    Posts
    9

    Re: How do I program Excel to return to column A after pressing return/enter?

    That is exactly how the columns are set up, yes. However, it's not "returning" to the far left column, it's going straight down. (normal operation)

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,414

    Re: How do I program Excel to return to column A after pressing return/enter?

    .
    Hopefully this will assist ... I use the following in a project. When the cursor reaches the 15th column and the user presses ENTER,
    the cursor returns to Col A :

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Last cell in column selected when pressing enter - why?
    By Lacaycer in forum Excel General
    Replies: 3
    Last Post: 06-05-2018, 12:13 PM
  2. Replies: 3
    Last Post: 03-30-2018, 11:06 AM
  3. Replies: 7
    Last Post: 11-19-2016, 06:27 PM
  4. Forcing data entry by pressing return
    By Simon1185 in forum Excel General
    Replies: 3
    Last Post: 10-22-2010, 05:28 AM
  5. [SOLVED] Enter column A and B values, return column C value?
    By Wezzo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2010, 04:04 PM
  6. Replies: 3
    Last Post: 12-31-2009, 03:44 PM
  7. [SOLVED] Make enter key return to first column
    By J in forum Excel General
    Replies: 1
    Last Post: 12-14-2005, 02:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1