Hitting [ENTER] doesn't move onto next cell

A

ALio

On one machine I'm using, hitting the [RETURN] or [ENTER]
keys whilst editing a cell does NOT convert the cell below
into the active cell. Normally in Excel, this is the case
is it not?

How can I change this?

Thanks.
 
H

Harald Staff

Hi

Most mysteries like this are solved in the Tools > Options menu, containing
a strange mixture of settings for the active file and Excel herself. This
one is in the Edit pane there: "Move selection after Enter".

And while there, have a look at all the other settings and options. It's
useful to know what and where they are.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default number format in Excel 1
auto format on number entry 1
Tab and Enter key to move in spreadsheet? 5
Set cell to only accept 1 character 1
change direction when hitting enter key 1
Automatically move to adjacent cells without hitting Enter 7
"Move selection after Enter" 3
Excel Auto Tabbing in Excel Worksheet Data Entry 1

Top