CODEWITHSUNDEEP
excel
Mchich
Mchich

Reputation: 43

Apply new cell value without pressing Enter or moving focus

Well, This is my problem I'm making alot of cell value testing in Excel, when i enter to apply the new value, the focus left the cell to the cell under it, so i have to return to the cell the change/apply again and again. Is there a key in the keyboard to apply changement without quitting the cell ? Is there a sitting in excel to apply changement while editing ?

Thank You all for your help

Upvotes: 1

Views: 560

Answers (1)

user4039065
user4039065

Reputation:

Uncheck the File, Options, Advanced, Editing options, After pressing Enter move selection option.

In VBA as,

Application.MoveAfterReturn = False

Upvotes: 2

Related Questions