ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   enter (https://www.excelbanter.com/excel-discussion-misc-queries/188279-enter.html)

Ali.Abughrabieh[_2_]

enter
 
How I can make the cell stopped where it is when I press enter I dont want
to move the sell down when I press enter I know its a silly question but
this is a very useful at work
Many thanks


jlclyde

enter
 
On May 21, 1:22*am, Ali.Abughrabieh
wrote:
How I can make the cell stopped where it is when I press enter I don’t want
to move the sell down when I press enter I know it’s a silly question but
this is a very useful at work
Many thanks


CTRL + Enter. This will calculate the formula but keep it in the same
cell.
Jay

Gord Dibben

enter
 
ToolsOptionsEditMove selection after Enter.

Uncheck the option button.

Gord Dibben MS Excel MVP

On Tue, 20 May 2008 23:22:01 -0700, Ali.Abughrabieh
wrote:

How I can make the cell stopped where it is when I press enter I don’t want
to move the sell down when I press enter I know it’s a silly question but
this is a very useful at work
Many thanks




All times are GMT +1. The time now is 04:17 AM.

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