Office Settings & Configuration

How to Restore Excel Columns to Normal Left-to-Right Order

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to change the Excel column display order from right-to-left back to the standard left-to-right layout.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening a spreadsheet downloaded from OneDrive after a system issue, resulting in reversed column letters (A starting on the right).
Observed behavior: Columns are displayed in a right-to-left direction instead of the normal left-to-right order.

Before you start

Check whether the reversed column issue affects only the currently open worksheet or all new workbooks you create, as the settings to fix them are located in different sections of the Options menu.

Solution 1Recommended

Restore Left-to-Right Order for the Current Worksheet

Use this method if only the currently opened spreadsheet has its columns reversed.

Excel allows individual worksheets to have their own display direction settings. If you downloaded a file where this setting was accidentally changed, you can revert it locally without affecting your overall application defaults.

Open Excel Options

Click on the 'File' tab in the top-left corner of the ribbon, then select 'Options' at the bottom of the menu.

Navigate to Advanced Settings

In the Excel Options dialog box, click on 'Advanced' in the left-hand pane.

Modify Worksheet Display Options

Scroll down until you find the section labeled 'Display options for this worksheet'. Choose the affected worksheet from the dropdown menu if it is not already selected.

Clear the Right-to-Left Setting

Uncheck the box that says 'Show sheet right-to-left', then click 'OK' to save your changes and apply the left-to-right layout.

Immediate Application: Your worksheet columns will instantly revert to the standard A-to-Z left-to-right layout upon clicking OK.

Solution 2

Change Default Column Direction for All New Workbooks

Apply this fix if every new Excel file you open automatically defaults to a right-to-left column layout.

WPS Spreadsheet Display

Easily Manage Spreadsheet Layouts in WPS Office

WPS Office provides an intuitive and seamless way to handle spreadsheet layouts, including right-to-left toggles. It is a fully featured, lightweight alternative that guarantees your data displays exactly how you need it.

1. Open the Spreadsheet: Launch WPS Office and open your affected spreadsheet file.
2. Access the Options Menu: Click the 'Menu' button in the top left corner, then click on 'Options'.
3. Navigate to View Preferences: Select 'View' from the settings window to find the workspace display options.
4. Adjust the Layout: Locate the sheet direction toggles, set your preference to left-to-right, and confirm your choice.

Seamlessly toggle between left-to-right and right-to-left display layouts100% compatible with Microsoft Excel (.xlsx) formatsLightweight application with a familiar, easy-to-use interfaceFree alternative with robust data management and visualization features

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel columns suddenly reverse to right-to-left?

This typically happens if the default direction setting is accidentally changed, a right-to-left language pack (like Arabic or Hebrew) is installed, or the file was originally saved by someone using a right-to-left application direction.

Does changing the left-to-right setting affect my printed document?

Yes, if your worksheet is set to right-to-left, it will print in that layout. Reverting it back to left-to-right ensures it prints in the standard format.

Can I toggle the left-to-right view directly from the Excel ribbon?

Yes, if you frequently switch directions, you can add the 'Right-to-Left Document' button to your Quick Access Toolbar by customizing the ribbon settings.

Will this solution alter the data inside my cells?

No, changing the worksheet direction only affects the visual layout of the columns and the interface. Your actual data, formulas, and cell formatting will remain perfectly intact.

Office App Problems