When I add a new worksheet to my workbook in Excel 2010 (by clicking the button insert worksheet next to sheet names), one sheet will be added and the direction goes to RTL from LTR automatically and immediately! So I need to go to page layout and correct the direction (to LTR) each time I insert a new worksheet. What can be the problem?
In the Page layout -> sheet options group -> in the left there is button named sheet right to left. When clicking on it, the direction will be changed. That is the Rows list go to the right side of the worksheet screen and by clicking that button once again the Rows list go to another side, this time left.
