Results 1 to 7 of 7

Thread: Arabic formatted Excel spreadsheet

  1. #1
    New Member
    Join Date
    Jul 2019
    Location
    Gdansk, Poland
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Arabic formatted Excel spreadsheet

    Hello everybody,
    have you ever met situation when Excel columns go from right to left (column A is first from the right) but data are ingested from left to right (January is in column L, December in A). If I just copy and paste all data I have wrong order. How can I reverse order of columns? Can I change spreadsheet to get column A on the left? If I could reverse order of data (i.e. January in column A) it would also be OK for me. Thanks in advance for any help.

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,854
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Arabic formatted Excel spreadsheet

    Options - Advanced - Display - Left to Right (select)
    optionally: Options - Advanced - Display options for this worksheet - (uncheck) Show sheet right to left
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  3. #3
    New Member
    Join Date
    Jul 2019
    Location
    Gdansk, Poland
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Arabic formatted Excel spreadsheet

    Thank you very much for your answer. However it does not resolve all problems. It reverses whole spreadsheet together with columns. I need data in columns in reversed order.
    I forgot in first message: I work on PC, Windows 10, Excel Office 365.

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,854
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Arabic formatted Excel spreadsheet

    Oh so I misunderstood.
    try:
    • copy row with months
    • paste transform
    • add index (1..12)
    • sort reverse index column (with two columns selected) (12..1)
    • copy vertical range of months
    • paste transform
    • remove previous data
    • move actual data to the right place

    or maybe find any vba to sort selected range or use PowerQuery

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    15
    December November October September August July June May April March February January
    16
    17
    12
    January
    18
    11
    February
    19
    10
    March
    20
    9
    April
    21
    8
    May
    22
    7
    June
    23
    6
    July
    24
    5
    August
    25
    4
    September
    26
    3
    October
    27
    2
    November
    28
    1
    December
    29
    30
    January February March April May June July August September October November December
    Last edited by sandy666; Jul 25th, 2019 at 03:35 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  5. #5
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,854
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Arabic formatted Excel spreadsheet

    or

    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  6. #6
    New Member
    Join Date
    Jul 2019
    Location
    Gdansk, Poland
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Arabic formatted Excel spreadsheet

    Thank you very much sandy666. You are really helpful.
    All the best,
    BZ

  7. #7
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,854
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Arabic formatted Excel spreadsheet

    You are welcome

    Have a nice day
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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