How to Change Spreadsheet Direction in Excel 2013

Microsoft Excel 2013 has a setting that allows you to specify the direction of new worksheets that you create. This setting will affect the location of the columns in the worksheets, as well as the starting location of the cursor.

Our guide below will show you where to find this setting on the Excel Options menu so that you can choose whether you want column A to be at the left or right side of the new worksheets that you create.

 

Change Worksheet Direction in Excel 2013

The steps in this article will point you to the Excel Options menu so that you can change the direction of new worksheets that you create. This will allow you to choose whether the worksheet is laid out in a left-to-right manner (column A at the left side of the worksheet) or a right-to-left manner (column A at the right side of the worksheet).

 

  1. Open Microsoft Excel 2013.
  2.  

  3. Click the File tab at the top-left corner of the window.
  4. open the excel 2013 file menu

     

     

  5. Click the Options button near the bottom of the column at the left side of the window. This will open an Excel Options window.
  6. open excel options window

     

     

  7. Click the Advanced tab in the left column of the Excel Options window.
  8. click advanced tab

     

     

  9. Scroll down to the Display section of this menu, locate the Default direction setting, then select either the Right-to-left or the Left-to-right option. As mentioned above, with the left-to-right setting, column A will be at the left side of the worksheet. With the right-to-left option, column A will be at the right side of the worksheet.
  10. change worksheet direction in excel 2013

     

     

  11. Click the OK button at the bottom of the window after you have made your selection.

 

Note that this will not change the direction of the current open worksheet or any existing worksheets. It will only change the direction of new sheets that you create.

Is your worksheet a mess of different fonts that is difficult to read? Learn how to change the font of an entire worksheet to improve the appearance of your data.

solveyourtech.com newsletter
vintage t rex t-shirt

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