Simple clear advice in plain English

Change the Enter key function in Excel

Set Excel to push down a cell when you press the Enter key

q-a-logo

Q When I press the Enter key in Excel, it moves up a cell rather than down, which is what I was expecting. How can I change this back?

Fergus Fox, Computeractive forum

A Excel will allow you to set the cursor to move in any direction. To change this, click on the Tools menu and then on Options. Click on the Edit tab. Look for the option Move selection after Enter. Click on the dropdown menu and select Down. Click on OK.

Mike C, Computeractive forum

Baffled by jargon? See our free online jargon buster.

Reader Comments

what has happened to 'noproblems'

what has happened to 'noproblems'? I have a problem but I cannot find anyway to get onto a place to submit it,why? regards, mel shipley

Posted by mel holmes, 12 Feb 2010

   

Add your comment

All fields must be completed. Your email address will not be displayed or used to send marketing messages.

All messages will be checked by moderators before appearing on the site.

See our Privacy Policy for more information.

Related articles

Word's undo feature

How to fix common PC errors

It’s easy to hit the wrong key when using a PC and throw yourself into a panic. There's no need to worry - we have easy fixes for 30 common everyday errors

337-f3-lp

How to sort lists easily in Word, Excel and Open Office columns

Microsoft Office and Open Office word processing and spreadsheet programs have simple ways of sorting lists of data in tables and spreadsheets

335-shortcuts-lead

Keyboard shortcuts made easy

Discover how keyboard shortcuts could speed things up – and print out our free guide to help you master some of the most common PC keyboard shortcuts

Question & Answer

Q.How do I store musician and other information about...

> Read the answer

Q.Why can't my browser find the website address I typed...

> Read the answer

Q.All updates have been downloaded, so why won't Windows...

> Read the answer

Best deals on the web

img

Apple MacBook Pro (MC724LL/A)

£999.99- Buy it now

img

Sony Vaio VPCF23P1E/B

£679.98- Buy it now

img

Samsung 300E5A-A01DX

£449.99- Buy it now

Great benefits for subscribers!

Poll

Which is your preferred web browser

Jargon Buster

Computing terms explained in plain English

CPU

Central Processing Unit. Another term for a computer processor.

Great shopping deals from Computeractive