moving right instead of down after editing a cell
 

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?


--
thomasF
------------------------------------------------------------------------
thomasF's Profile: http://www.excelforum.com/member.php...o&userid=25314
View this thread: http://www.excelforum.com/showthread...hreadid=393905

This can be changed via the ToolsOptions | Edit tab In the Move
selection after Enter, click the down arrow and choose Right.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=393905

thomasF wrote in
:


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. :)


--
thomasF
------------------------------------------------------------------------
thomasF's Profile: http://www.excelforum.com/member.php...o&userid=25314
View this thread: http://www.excelforum.com/showthread...hreadid=393905