n
nchristine
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!

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

Excel Tips
http://spreadsheets.about.com/od/tipsandfaqs/a/excel_tip_hub.htm
kreiley
11/15/2013

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