Arabic formatted Excel spreadsheet

[BigZbig]

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.

 

[sandy666]

Options - Advanced - Display - Left to Right (select)
optionally: Options - Advanced - Display options for this worksheet - (uncheck) Show sheet right to left

 

[BigZbig]

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.

 

[sandy666]

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

[Table="width:, class:head"][tr=bgcolor:#000000][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][th]

L​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

15​

[/td][td]December[/td][td]November[/td][td]October[/td][td]September[/td][td]August[/td][td]July[/td][td]June[/td][td]May[/td][td]April[/td][td]March[/td][td]February[/td][td]January[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

16​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

17​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

12​

[/td][td]January[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

18​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

11​

[/td][td]February[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

19​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

10​

[/td][td]March[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

20​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

9​

[/td][td]April[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

21​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

8​

[/td][td]May[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

22​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

7​

[/td][td]June[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

23​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

6​

[/td][td]July[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

24​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

5​

[/td][td]August[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

25​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

4​

[/td][td]September[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

26​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

3​

[/td][td]October[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

27​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

2​

[/td][td]November[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

28​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

1​

[/td][td]December[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

29​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

30​

[/td][td]January[/td][td]February[/td][td]March[/td][td]April[/td][td]May[/td][td]June[/td][td]July[/td][td]August[/td][td]September[/td][td]October[/td][td]November[/td][td]December[/td][/tr]
[/table]

 

[sandy666]

or

 

[BigZbig]

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

 

[sandy666]

You are welcome

Have a nice day