Why is My Worksheet Backwards in Excel 2010?

Did you open a file in Excel 2010 and the row numbers were at the right side of the worksheet, and the column letters were in the reverse order? This happens because a setting in the Excel options menu called “Show sheet right to left” has been turned on. This can be a frustrating change to have occur when you are comfortable working with Excel in a certain fashion, but luckily it is something that you can fix.

Our guide below will show you how to find the option that allows you to adjust this setting so that you can return your Excel layout to the version with which you are probably more comfortable.


How to Flip the Layout of Your Spreadsheet in Excel 2010

The steps in the article below will assume that you currently have a worksheet in Excel 2010 where the A1 cell is at the top-right corner of the sheet, and the row numbers are at the right side instead of the left.


  1. Open your worksheet in Excel 2010.

  3. Click the File tab at the top-left corner of the window.

    click the file tab



  5. Click Options in the column at the left side of the window.
  6. click options in the left column



  7. Click Advanced in the column at the left side of the Excel Options window.
  8. click advanced in the excel options window



  9. Scroll down until you get to the Display options for this worksheet section, then uncheck the box to the left of Show sheet right to left. If every worksheet in your workbook is backwards, then you may also need to click the drop-down menu to the right of Display options for this worksheet and change this setting for the other listed worksheets as well. Click the OK button at the bottom of the window when you have finished.

uncheck the show sheet right to left option



Are thew worksheet tabs hidden in your workbook, or would you like to hide them because they are taking up space? Click here and learn how to hide or unhide worksheet tabs in Excel 2010.

solveyourtech.com newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.