Excel Text Direction: Change Cells and Sheet Layout

How-to basics · Updated November 18, 2026

In Excel for Microsoft 365 on Windows, change the direction of text in a cell by opening Format Cells with Ctrl+1, choosing the Alignment tab, and selecting Context, Left-to-right, or Right-to-left under Text direction. To flip the entire worksheet layout instead, go to File > Options > Advanced and select Show sheet right-to-left for that worksheet.

What text direction means in Excel

“Text direction” can refer to two different settings in Excel. One controls how text is arranged inside selected cells; the other changes which side of the worksheet holds the first column. Choosing the right setting depends on whether the problem is limited to a cell’s contents or affects the whole grid.

  • Cell text direction affects the reading order of text inside a cell. It is useful for languages written from right to left, such as Arabic and Hebrew, and for cells containing a mixture of scripts.
  • Worksheet direction reverses the sheet’s layout. In a right-to-left sheet, column A begins at the right edge and later columns extend toward the left.

Neither setting translates text, changes the underlying values, nor reverses the order of characters stored in a cell. They affect how Excel displays and navigates the content. Text direction is also different from text orientation: orientation rotates or stacks letters, while direction determines reading order.

Set direction for text in selected cells

Use the cell-level setting when only particular entries need a right-to-left or left-to-right reading order. This is common in a bilingual list, a form, or a worksheet that combines English labels with Arabic or Hebrew content.

  1. Select the cell or range you want to format.
  2. Press Ctrl+1 to open the Format Cells dialog box.
  3. Choose the Alignment tab.
  4. Under Text direction, choose Context, Left-to-right, or Right-to-left.
  5. Select OK to apply the setting.

Context lets Excel determine direction from the text. It is a reasonable choice for cells whose contents may start with different scripts. Choose Left-to-right or Right-to-left when you want a fixed direction regardless of the first character. For example, a table may have an English product code followed by Arabic text; setting the cell direction explicitly can make the order easier to read.

The setting belongs to the cell formatting, so it can be copied with the cell using the usual copy-and-paste or Format Painter methods. If you only want the change on a few cells, avoid changing the worksheet direction: that would rearrange the entire grid.

Switch a worksheet to right-to-left

For a sheet designed primarily for a right-to-left language, change the worksheet direction rather than adjusting every cell separately. In Excel for Microsoft 365 on Windows, use these steps:

  1. Open the worksheet you want to change.
  2. Select File > Options, then choose Advanced.
  3. Scroll to Display options for this worksheet. If the workbook has several sheets, check that the worksheet named in this section is the one you intend to modify.
  4. Select Show sheet right-to-left, then choose OK.

Column A will appear on the right, with subsequent columns extending to the left. The row numbers and horizontal navigation reflect the reversed layout as well. The setting applies to the selected worksheet, not automatically to every sheet in the workbook; repeat the procedure for other sheets that need the same arrangement.

Changing the sheet direction does not rewrite formulas or move the data into different cells. A value that was in A1 remains in A1, even though A1 is now displayed on the right. References such as A1 in formulas continue to refer to the same cell. This is a display and navigation change, not a data conversion.

Choose the right setting for your task

The distinction matters because Excel’s two direction controls solve different problems. If a sentence is displayed in the wrong reading order but the column layout is correct, change the cell’s Text direction. If the entire worksheet should start at the right and proceed leftward, change the sheet direction. You can use both settings in the same workbook when appropriate.

  • Use cell direction for a few cells, mixed-language entries, or a specific field in an otherwise left-to-right table.
  • Use sheet direction when the whole sheet follows a right-to-left workflow and users expect the first column at the right.
  • Use text orientation when the goal is to rotate headings vertically or at an angle to save space. Find Orientation in the Home tab’s Alignment group; it does not set reading order.

For example, a bilingual customer register could keep its overall sheet left-to-right while giving an Arabic-name column right-to-left cell formatting. A form intended for Arabic readers might instead use a right-to-left sheet so its fields begin at the right edge. The correct choice is the one that matches how readers scan the information.

How direction interacts with alignment and mixed text

Direction and alignment are related but separate. Horizontal alignment determines whether cell contents sit at the left, center, or right of the cell. Text direction determines the order in which characters and text runs are displayed. Right-aligning an English phrase does not make it right-to-left, and left-aligning Arabic does not convert it to left-to-right.

Mixed-script text can be especially confusing because punctuation, numbers, parentheses, and symbols may appear in a different visual position than expected. Excel uses bidirectional text behavior to display left-to-right and right-to-left characters together. The Context option generally lets Excel choose an appropriate direction based on the content, but a cell beginning with a number or punctuation mark may not behave as a reader expects. Try setting the cell’s direction explicitly, then check the result with the complete text rather than judging from its first character alone.

When a value is imported from another system, invisible characters or pre-existing formatting can also affect its appearance. A useful check is to enter a short sample directly into a blank cell and compare it with the imported value. If the sample looks right but the imported text does not, the source data or its formatting may be contributing to the issue.

Set a default direction for new worksheets

If new sheets in a particular workbook should routinely use a right-to-left layout, Excel provides a default direction setting in the Advanced options. In File > Options > Advanced, look under Display options for this workbook for Default direction, then choose the direction you want. This is distinct from Show sheet right-to-left, which changes the currently specified worksheet.

After changing the default, create a new worksheet and confirm its layout. Existing sheets may retain their own direction, so do not assume that changing the default retroactively converts the workbook. If the controls are missing, check whether right-to-left language features are enabled in Office; available options can depend on the installed language support and version.

Common problems and practical fixes

  • The text looks reversed, but the columns are in the right places: Open Format Cells > Alignment and change Text direction for the affected cells. Do not flip the whole sheet unless its column order should also reverse.
  • Column A is on the wrong side: Check Show sheet right-to-left in Advanced options for the active worksheet. This is not controlled by cell alignment.
  • The direction option is missing: Update or check Office language settings and installed right-to-left language support. The available controls may vary by platform and configuration.
  • Only some cells behave differently: Select those cells and inspect their Alignment settings. They may have explicit direction formatting while surrounding cells use Context.
  • Headings are vertical rather than reversed: Check Orientation in the Home tab’s Alignment group. Rotation is a separate formatting property.

When correcting a workbook, test a small range first. Then apply the setting to the intended cells or sheet, and review headings, numbers, punctuation, and formulas. This avoids changing a workbook-wide layout to solve a problem confined to one field.

Windows, Mac, and Excel for the web

The steps above use Excel for Microsoft 365 on Windows. On Excel for Mac, the Format Cells dialog is also available, commonly opened with Command+1 rather than Ctrl+1; ribbon and settings locations can differ by release. For worksheet direction, look for the right-to-left sheet control in the Page Layout or sheet-layout options if it is available in that Mac build. Language support and version can affect whether the command appears.

Excel for the web has a different, more limited interface than the desktop app, and some direction controls may not be exposed there. If you cannot find the cell Text direction or worksheet direction setting in the browser, open the workbook in the desktop version of Excel and make the change there. When collaborating, confirm the result in the version your readers use, especially for a workbook with mixed right-to-left and left-to-right text.

Frequently Asked Questions

How do I change text direction in Excel?
For selected cells in Excel for Windows, select them, press Ctrl+1, choose Alignment, and set Text direction to Context, Left-to-right, or Right-to-left. For a whole sheet, use File > Options > Advanced and select Show sheet right-to-left.

How do I make column A appear on the right?
Change the worksheet direction. In Windows Excel, go to File > Options > Advanced, find Display options for this worksheet, and select Show sheet right-to-left. Column A then appears at the right of that sheet.

Does changing text direction change formulas or cell references?
No. It changes how Excel displays or lays out the worksheet. Cell addresses and formula references remain tied to the same cells, and the text is not translated.

Why does right-aligning text not make it read right-to-left?
Alignment changes where content sits in a cell; it does not set character reading order. Use the Text direction control on the Alignment tab of Format Cells for reading order.

Can one Excel worksheet contain both Arabic and English text?
Yes. You can format individual cells for a fixed direction or use Context so Excel determines direction from their contents. Review mixed text with punctuation and numbers, since their visual placement can depend on the surrounding script.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.