How to change worksheet direction in Excel 2010 to Right-to-Left

The default worksheet direction in Excel 2007 or 2010 is Left-to-Right. To change a worksheet direction to Right-to-Left, follow these steps:

  1. In Excel Ribbon click on the Page Layout tab.
  2. In the Sheet Options group click Sheet Right-to-Left. The sheet direction will be changed. Column A will now be to the far right. Columns B, C, D.. etc. will follow to the left.