Column A is on the right side of the spreadsheet !!

Hi,

Every new spreadsheet or workbook that I create is with the column A on the right side. I mean, instead of the A1 cell be located at the top left corner it is located at the top right corner. The spreadsheet tab on the bottom is also in the inverse order. The row numbers are located on the right side while the vertical scroll bar is on the right side.

I don't know what I did and I couldn't find any information about it.

I don't have Excel 2007 but in Excel 2003 this is a setting under 'Tools |Options..| International tab'

You should see a checkbox which says "View current sheet Right to left" which is ticked- untick it.

The problem is that Excel 2007 doesn't have it. I was wondering how the problem started. . .

Don't know how you managed that but to revert to "normal"

Office button (large round top-left button)>Excel Options>Customize>All Commands, scroll down to Right to left document, click
Add, OK

Now you have a button on the QAT (next to the Office button) that toggles the direction

I'm not at the right pc right now but I just did it. The thing is that the new button is grayed out. So, if I click it, nothing happens. Trying to investigate it further I realized that the one with problem was upgraded from office 2003. Is there any relation ?

This appears to be problem which occurs when upgrading from Excel 2003. You can fix this by running regedt32 and changing the follwing key value from 1 to 0 :-

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options\DefaultSheetR2L