Search code examples
excelexcel-2007vba

Reversed columns ('A' column at the end of a Spreadsheet)

I'm asked to solve this kind of problem, but it's too hard for me. Click to see reversed columns

Of course, I want the sheet to show columns from 'A'. Has anybody got any idea how to figure it out?

Solution

  • It looks that Excel 2007 has a diferent approach to reverse the order of columns from other Excel versions, as mentioned in http://www.rondebruin.nl/win/s5/win004.htm

    Excel 2007:

    1. Open Excel and create a new workbook
    2. Alt+F11 to open the VBA editor
    3. Ctrl+G to open the Immediate window and then type in the window

    Application.DefaultSheetDirection = xlRTL

    Press Enter.

    1. Alt+Q to close the VBA editor
    2. Create a new workbook to test it

    Note: you can type Application.DefaultSheetDirection = xlLTR to reverse again.

    Excel 2013:

    Go to File -> Options -> Advanced -> Display (tab) -> Default direction -> Right-to-Left.

    Hope that helps ;)