Mac excel preferences question

Discussion in 'Mac Basics and Help' started by johnet, Mar 23, 2011.

  1. johnet macrumors newbie

    Joined:
    Mar 23, 2011
    #1
    When inputing two or more columns how do you get the cursor to go from column "b" automatically back to column "a" when you hit "enter".
     
  2. Hermes Monster macrumors 65816

    Hermes Monster

    Joined:
    May 4, 2010
    Location:
    UK
    #2
    I can't think of anything that would do that for you, other than writing a macro? Or push down and left keys :p
     
  3. Gregg2 macrumors 603

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI
    #3
    ..or enter and left arrow.

    How would the program know when you didn't want that behavior? If you're in Column R and hit enter, chances are you don't want it going back to A or even Q.
     
  4. johnet thread starter macrumors newbie

    Joined:
    Mar 23, 2011
    #4
    thanks for the reply. I have used it in a previous life when doing a lot of data entry work on a pc. when you come to the last column of input data and hit enter it takes you back to the first column. It may not be an option with this version of excel.
     

Share This Page