Editing in cell - Disable "Home" key closes cell when text first entered

Hi @Andrew Cecka,

Thank you for posting your question in the Microsoft Q&A forum.

I'm sincerely sorry for any inconvenience and troubles this situation may have caused you.

According to your concern, unfortunately Excel does not have a built-in option to change the Home key behavior globally. However, you can achieve that by using this VBA setup:

• In the Excel file you want to disable "Home" key close cell, press Alt + F11 to open VBA editor.
• Double click on This Workbook and add the below script into it:

Option Explicit
 
Private Sub Workbook_Open()
    Application.OnKey "{HOME}", "HomeToEditStart"
End Sub
 
Private Sub Workbook_Activate()
    Application.OnKey "{HOME}", "HomeToEditStart"
End Sub
 
Private Sub Workbook_BeforeClose(ByVal Cancel As Boolean)
    Application.OnKey "{HOME}"
End

• Then press Insert > Module and add the below script into it:

Option Explicit
 
Public Sub HomeToEditStart()
    Application.SendKeys "{F2}{HOME}", True
End Sub
Public Sub SetHomeRemap()
    Application.OnKey "{HOME}", "HomeToEditStart"
End Sub
Public Sub ClearHomeRemap()
    Application.OnKey "{HOME}"
End Sub

• After that, close the VBA editor.
• In your worksheet, press Alt + F8 > select the SetHomeRemap and press Run. Then test if the Home key works as you expect.

Hope this information proves helpful. You can try this formula and let me know if it works for you. If not, we can work together to find a solution.

Thank you for your understanding and cooperation. If you have any questions or need further assistance, please feel free to share them in the comments so I can continue to support you.

I'm looking forward to your reply.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".      

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

In Excel, the behavior of the Home key is designed to move the focus to the first cell of the row when you are in editing mode and have just entered text in a blank cell. Unfortunately, there is no built-in option to change this behavior so that the Home key only moves the cursor to the beginning of the text in the cell without closing it.

The Home key's functionality in Excel differs from that in Word, where it consistently moves the cursor to the beginning of the line. In Excel, you can use F2 or double-clicking the cell to enter edit mode, and then the Home key will behave as expected by moving the cursor to the start of the text.

To avoid the issue of accidentally closing the cell when hitting Home, you might consider being cautious with your key presses or using other methods to navigate within the cell, such as using the arrow keys or Ctrl + Arrow keys for word navigation. Unfortunately, there is no way to customize the Home key behavior in Excel to prevent it from closing the cell when text is first entered.