ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Problem (https://www.excelbanter.com/excel-programming/367328-excel-problem.html)

mastermind

Excel Problem
 
This may be a stupid question, but does anyone have any ideas why when
strike "Enter" the active cell stays the same? Is there some setting
or something that has been adjusted to make it do this, or is it
something else. Any information would be most appreciated.

John


Otto Moehrbach

Excel Problem
 
Look under Tools - Options - View tab. Look at "Move after selection". You
have the option of not moving or moving left, right, down, or up. HTH
Otto
"mastermind" wrote in message
ups.com...
This may be a stupid question, but does anyone have any ideas why when
strike "Enter" the active cell stays the same? Is there some setting
or something that has been adjusted to make it do this, or is it
something else. Any information would be most appreciated.

John




Dave Peterson

Excel Problem
 
Maybe you could use:

Tools|Options|Edit tab
Uncheck "move selection after enter"
(if you want to stay put)

or check it (and select the direction) if you want it to move somewhere else.

mastermind wrote:

This may be a stupid question, but does anyone have any ideas why when
strike "Enter" the active cell stays the same? Is there some setting
or something that has been adjusted to make it do this, or is it
something else. Any information would be most appreciated.

John


--

Dave Peterson


All times are GMT +1. The time now is 03:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com