Usually when you have entered text or a number in a cell, you press enter and are moved one row down. This is fine when you are inserting data column by column, however right now I am entering some data row by row, and am finding it rather tedious pressing enter and two arrow keys to get to the next cell.
Anyone know if I can move directly to the right?
This can be changed via the Tools>Options | Edit tab In the Move selection after Enter, click the down arrow and choose Right.
HTH
Bruce
Bruce
The older I get, the better I used to be.
Minneapolis, MN USA
thomasF <thomasF.1tgdrf_1123517167.6261@excelforum-nospam.com> wrote in
news:thomasF.1tgdrf_1123517167.6261@excelforum-nospam.com:
>
> Usually when you have entered text or a number in a cell, you press
> enter and are moved one row down. This is fine when you are inserting
> data column by column, however right now I am entering some data row by
> row, and am finding it rather tedious pressing enter and two arrow keys
> to get to the next cell.
>
> Anyone know if I can move directly to the right?
>
>
Tools/Options/Edit/Move selection after Enter
I had to translate from Dutch so the terms might be slightly off.
--
It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)
Thanks.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks