Mac excel preferences question

[johnet]

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".

 

[Hermes Monster]

I can't think of anything that would do that for you, other than writing a macro? Or push down and left keys

 

[Gregg2]

..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.

 

[johnet]

..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.

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.