move selection after enter into cell

[lynn_Spaulding]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Upon entering data into a cell, I do not want to move to another cell when I hit Return. In the older version of Excel I used to be able to go into Tools/Options/Edit and uncheck Move Selection after Enter. How can I accomplish this in the 2008 version? thanks

 

[CyberTaz]

Aha - you've revealed yourself as a Windows user Mac OS has never had
Options, it uses Preferences instead. Go to Excel> Preferences> Edit where
you can specify Up, Down, Left, Right from the list or clear the check to
not have the selector move on pressing return.

HTH |:>)
Bob Jones
[MVP] Office:Mac