Edit mode with Enter key instead of F2?

Question

Edit mode with Enter key instead of F2?

Anonymous

Is there a way to change how to enter edit mode in Excel?

I would like to use the Enter key, instead of the F2 key, to edit a cell.

Is there an option, or a Macro I could code in order to do this?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

1 answer

Answer 1

Dear GaXve,

First, my pleasure to assist you.

As per your description, I understand you want to enter edit mode in Excel via Enter key, instead of F2 key.

Generally, type function key "F2" at any Excel cell, the Cell mode will change to "Edit" mode. If you double click on a non-blank (where data is already filled) Excel Cell with mouse pointer, the Cell mode will become "Edit" mode.

And Pressing "Enter" saves the cell changes and displays the results of a formula, if you created a calculation. Regarding to your concern, “I would like to use the Enter key, instead of the F2 key, to edit a cell.” I’m afraid there is no setting to change this default behaviour in Excel. I checked setting option, for your reference:

Regarding to macro-VBA code for press Enter key for Edit mode in Excel, if possible, workaround or VBA code that make press Enter key for Edit mode in Excel, any community members who have related experience are welcome to share your insights here.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Waqas Muhammad

Share via

Edit mode with Enter key instead of F2?

1 answer