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 (9)

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.
IBM continues to make the case for the nascent field of cognitive computing, showing off some Watson prototypes Thursday that could help speed scientific discovery in the medical field, by scanning large volumes of literature and data far more quickly then humans can, and suggesting possible leads.
Three CIOs discuss how they balance traditional and unconventional approaches to keep projects on track and deliver on their promises.
Windows XP users may now download a fourth service pack for the 13-year-old operating system, but it isn't coming from Microsoft.
Wishing your Raspberry Pi had more power for all those hardware hacking projects you have planned? There's a new barebones board on the market that may better fit your needs, and right now you can sign-up for your chance to get it for free.
Is it crazy to pay $1300 for a Chromebook? Some reflections after a year and a half of living with Google's luxurious Pixel.
Project management seems so straightforward. You set a deadline. You set a budget. You select the right people. The project gets done.
The arrival of the first round Android Wear-based smartwatches means developers have to take extra care to ensure their apps look good.
Microsoft has consolidated the consumer and enterprise editions of OneDrive under a single Android app, a move it plans to replicate across all the platforms that the cloud storage service runs on.
Google Drive apps are loved for their simplicity and ease of use, but don't let that fool you. There's a whole lot of power locked up in these web apps. And while we'd never put the suite on a par with Microsoft Office, there are some impressive features in Docs, Sheets, and Slides that you've likely overlooked.
Microsoft has begun clamping down on sham Windows Store apps that try to dupe users into paying for free software, the company announced Wednesday.
randomness