Display text or a spreadsheet so that it reads right to left or left to right

Use right-to-left text direction or display when your spreadsheet will be viewed in languages that read from right to left.

Display an entire spreadsheet right to left or left to right

1. On the toolbar, click Commands and Options , and then click the Sheet tab.

2. Under Show/Hide, select or clear the Display right to left check box.

When you select right-to-left display, the elements of the spreadsheet are displayed as a mirror image of the default left-to-right display: The row numbers are displayed on the right side of the spreadsheet and the vertical scroll bars appear on the left side.

Display text right to left or left to right

Text direction defaults to Context, which means text direction is automatically displayed as left to right or right to left depending on the language used. You can set specific cells to display text direction as right to left or left to right so that if you are working with multiple languages in different cells, individual cells can have different text directions.

1. On the toolbar, click Commands and Options , and then click the Format tab.

2. Under Text Format, click the arrow next to the Text direction box, and select an option from the list.