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

nchristine

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

Tags: excel
Topic: Software
Answer this Question

Answers

2 total
jimlynch
Vote Up (8)

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
Vote Up (6)

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.

Ask a question

Join Now or Sign In to ask a question.
Hydraulic actuators, battery stacks, biochemical systems and disease propagation are but a few things that now can be modeled more easily, thanks to a number of libraries and a library store that Wolfram Research has created for a new edition of its SystemModeler software package.
A new model of the Raspberry Pi is out, but it's not Raspberry Pi 2
Microsoft seems on the brink of announcing a major enhancement to its operating system lines, namely merging them into a single OS that could bring big benefits for corporate users.
Check out the collaboration-friendly tools built into Google Docs, and learn how to set some handy preferences.
Apple has "inadvertently admitted" to creating a "backdoor" in iOS, according to a post by a forensics scientist, iOS author and ex-hacker.
After seventeen years, Valve and ValveTime Database give us our first look at screenshots from the unreleased 1996 title Prospero.
The U.S. Social Security Administration has spent nearly US$300 million on a software system for processing disability claims that still isn't finished and has delivered limited useful functionality, according to an independent report on the project.
Financial results are oh-so boring, but Microsoft's latest quarterly results hid a surprising number of juicy tidbits
Given that this marks the first time a major new version of OS X has been available to users before it's actually released (not counting the original Mac OS X Public Beta), you likely have questions. We've got answers.
Hewlett-Packard is betting $50 million that its customers will find value in the Hadoop data processing platform, by investing in Hadoop distributor Hortonworks.