I recently got a new (to me) PC at work. I went from 512 of RAM to 1G, which is quite nice. Anyway, I used the post and comments on Power User Setup to get Excel humming the way it was. One comment, by John Walkenbach, was that he unchecks the Move Selection After Enter box on the Edit menu of Tools > Options. Another commenter agreed that unchecked was the way to go. I’ve always had that checkbox checked, but it was time to try a new way. For a week, or so, I’ve worked with that box unchecked and I have to say that it was much easier…about half the time. It seems that half the time I want to remain in the cell I just edited and the other half I want to move down.
My new plan is to put a macro in Personal.xls (that will make three macros in there) to switch between the behaviors.
Application.MoveAfterReturn = Not Application.MoveAfterReturn
I assigned it a shortcut key (Tools > Macros > Macros > Options) of Control+Shift+M. Now I can switch back and forth. We’ll see how that goes.
Update: Mike Schaeffer shows some improvements here. I haven’t seen Mike’s blog before, but a quick scan of the post titles looks promising. I wanted to make sure there was a link to his blog in the main post rather than hidden in the comments.
The only thing I don’t like about Mike’s improvements is that it seems backward. It seems as if I’m punished for choosing correctly, i.e. I use the key combination to change the property and if it was the proper thing to do, I have to press it again. If the property was already set properly, I don’t have to do anything. I think it should be the other way around, so I propose these changes:
.MoveAfterReturn = Not .MoveAfterReturn
.StatusBar = “Move After Return Is “ & IIf(.MoveAfterReturn, “Enabled”, “Disabled”)
.OnTime Now + TimeValue(“00:00:03”), “ResetStatusBar”
Application.StatusBar = False
In this scenario, I hit Control+Shift+M and look at the Status Bar. If I changed the property to what I want, I’m rewarded by not having to do anything. If I change the property away from what I want, I’m punished by having to press the keys again. Such are the delusions of some cosmic justice in my pathetic world.