Office Settings & Configuration

Fix the Excel Home Key Moving to the Right Side of a Worksheet

John WilsonJohn Wilson Nov 13, 2026 869 views

Question details

The user wants the Home key to move to the beginning of a row on the left side of an Excel worksheet.

Fix the Excel Home Key Moving to the Right Side of a 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.
Before you start

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.

Solution 1Recommended

Turn off right-to-left display for the affected worksheet

Use this setting when the problem occurs on a particular worksheet.

1
Select the worksheet

Click the affected worksheet tab at the bottom of the Excel workbook.

2
Open Excel options

Select File > Options > Advanced.

3
Change the sheet direction

Under Display options for this worksheet, confirm the affected sheet is selected and clear Show sheet right-to-left.

4
Test the Home key

Click OK, select a cell in the worksheet, and press Home to check the direction of movement.

Turn off right-to-left display for the affected worksheet
Setting already cleared?: If Show sheet right-to-left is already off or is unavailable and the worksheet still behaves unexpectedly, try copying its data to a new worksheet.
Free Microsoft Office alternative

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.

Navigate and edit worksheets in WPS SpreadsheetsOpen and save Microsoft Excel XLSX and XLS filesUse familiar spreadsheet controls for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

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.