Nov 14, 2013

How to prevent Excel from automatically putting the pointer in the next cell down?

Is there a way to change where Excel automatically advances the cell pointer? Usually next cell down is fine, but not always. Thanks!

The first answer seems to have it right, but here are some additional Excel tips that you might find helpful.

Excel Tips

You can customize that behavior in the Advanced tab of the Excel Options dialog box (Alt+FTA). Uncheck the check box for “After Pressing Enter, Move Selection” if you don’t want it to move at all. If you want to make it move in a different direction, there is a “Direction” pop-up list where you can select your desired direction of movement.

Answer this