+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : worksheet view reversed

  1. #1
    Registered User
    Join Date
    08-28-2011
    Location
    Egypt
    MS-Off Ver
    Excel 2003
    Posts
    2

    worksheet view reversed

    I work at a school in Egypt, a colleague asked me to have a look at a problem she's having with Excel which seemed unusual to me and I haven't been able to find the problem. Whenever she creates a new worksheet the view is reversed. The row names run down the right hand side of the page and the columns run A, B, C, D, etc from right to left along the top instead of from left to right as is usual. The worksheets are listed on the bottom-right of the screen instead of the bottom-left.

    When opening an existing workbook everything is as normal, but when adding a new worksheet to the same work book everything is reversed on the new sheet but as normal on the old sheets.

    Totally perplexed by this, I thought maybe it was something to do with regional settings as we're in an Arab country but everything is set to UK regional settings. Anybody any idea how to fix?

  2. #2
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: worksheet view reversed

    Hello and welcome to the forum,

    I have seen this from Excel sheets produced from several Arab countries including Saudi Arabia and UAE. I have Excel 2010 and so my instructions may not be exactly the same for Excel 2003, but here goes.

    1) Open Excel Options

    2) Under 'Display options for this worksheet' uncheck 'show sheet right-to-left'

    Hope this helps.

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: worksheet view reversed

    Here is the info for worksheet level and workbook level switching from Microsoft:

    http://office.microsoft.com/en-us/ex...005262661.aspx

    Hope this helps.

    abousetta

  4. #4
    Registered User
    Join Date
    08-28-2011
    Location
    Egypt
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: worksheet view reversed

    Thanks for the pointers that fixed it. Haven't been able to update thread title to [solved] however as when I edit the original post it doesn't seem to give me the option to change the subject line or prefix.

  5. #5
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: worksheet view reversed

    Hi,

    Thanks for the feedback. You will need to go to Edit --> Advanced. That's where where you will find the dropbown menu next to the Title that will allow you to mark the thread as SOLVED.

    Good luck.

    abousetta

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1