How to Put Excel Column A on Right Side

There are some things that you take for granted in applications like Microsoft Excel that you use all the time. One of those things is the direction in which the data flows.

So if you have Excel column A on right side of the window, or it’s on the left, and that’s not what you are used to, then you may be wondering how to fix it.

How to Change Spreadsheet Direction in Excel 2013

  1. Open Excel.
  2. Click File.
  3. Choose Options.
  4. Select the Advanced tab.
  5. Choose the desired option under Default direction.
  6. Click OK.

Our guide continues below with additional information on how to move Excel column A on right side to the left, or vice versa, including pictures of these steps.

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.

Curious about creating tables in Excel? They are a great way to store and sort data in your spreadsheets.

How to Change Worksheet Direction in Excel 2013 (Guide with Pictures)

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).

Step 1: Open Microsoft Excel 2013.

Step 2: Click the File tab at the top-left corner of the window.

open the excel 2013 file menu

Step 3: Click the Options button near the bottom of the column at the left side of the window.

This will open an Excel Options window.

open excel options window

Step 4: Click the Advanced tab in the left column of the Excel Options window.

click advanced tab

Step 5: 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.

change worksheet direction in excel 2013

Step 6: 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.

Now that you have Excel column A on right side of the window, you will be able to enter and edit your data in the manner to which you are accustomed.

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.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy