Fix the Excel Home Key Moving to the Right Side of a Worksheet
Question details
The user wants the Home key to move to the beginning of a row on the left side of an Excel worksheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Navigating a worksheet that may be displayed from right to left.
- Observed behavior
- Pressing Home moves the selection toward the far-right side of the worksheet instead of the left.
Open the affected workbook and test the Home key on another worksheet to see whether the behavior is limited to one sheet. The menu paths below apply to desktop Excel on Windows.
Turn off right-to-left display for the affected worksheet
Use this setting when the problem occurs on a particular worksheet.
Click the affected worksheet tab at the bottom of the Excel workbook.
Select File > Options > Advanced.
Under Display options for this worksheet, confirm the affected sheet is selected and clear Show sheet right-to-left.
Click OK, select a cell in the worksheet, and press Home to check the direction of movement.

Set the default direction for new Excel worksheets
Use this setting to make new worksheets display from left to right by default.
Copy the data to a new worksheet
Try a new worksheet if the sheet-specific setting is unavailable or already turned off.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Excel files. Its format compatibility makes it easy to move existing spreadsheets into WPS, though it does not change Excel's own settings.

Frequently Asked Questions
Why does Home move to the right in my Excel worksheet?
The worksheet may be displayed right to left, placing the beginning of the row on the right. Check File > Options > Advanced > Display options for this worksheet and clear Show sheet right-to-left.
What does the Home key normally do in Excel?
Home moves the selection to the beginning of the current row. In a left-to-right worksheet, that is normally toward column A on the left.
Will changing the default direction fix existing worksheets?
Not necessarily. The Default direction setting under File > Options > Advanced applies to new worksheets; check the individual display setting for existing sheets.
What if right-to-left display is already turned off?
Copy the affected data with Home > Copy, add a worksheet using the plus button beside the sheet tabs, and paste the data into the new sheet. Test Home again and review the copied formulas and formatting.




