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

Using Wizard to create a form

Create a good Base for your data

Databases may sound very dreary but they are behind almost everything we do. We explain how to go about starting one of your own using Libre Office Base

Treesize Free tip 1 screenshot

How to prevent PC problems

Follow our useful tips to solve common problems using Windows or free software

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

Question & Answer

Q.Why are some of the keys on my keyboard doing strange...

> Read the answer

Q.Is my phone’s Bluetooth any use?

> Read the answer

Q.Can I switch boot drives so that I can work on older...

> Read the answer

Best deals on the web

img

Apple iMac 21.5" (MC309)

£926.40- Buy it now

img

Dell Inspiron 620 ST Intel Core i3-2100 3.10GHz / 3GB / 500GB / DVDRW / Win 7 Home Premium

£329.00- Buy it now

img

ZooStorm 7877-1023

£386.38- Buy it now

Latest issue & subscription deals

Poll

Are you concerned about viruses that target mobile phones?

Jargon Buster

Computing terms explained in plain English

Router

A device used to connect more than one computer or other device to the internet.

Great shopping deals from Computeractive