Spreadsheet has gone all bum about face!

Spreadsheet has gone all [***] about face!

Didn't find your answer?

I would say I'm an Excel geek and there's not much I haven't seen or done in a spreadsheet. But I have received a spreadsheet from a client who is based in the middle east and his spreadsheet has the cell A1 in the top right corner. So the columns are basically back to front and the row numbers are on the right hand side of the screen. It's completely doing my head in! Does anyone know how to switch it back around?

Many Thanks

SD

Replies (5)

Please login or register to join the discussion.

avatar
By paulwakefield1
13th May 2013 12:49

Depending on your version of excel

In Excel 2010:

File - Options - Advanced - Display - default direction and tick Left-to-Right

In Excel 2003:

Tools - Options - International - and tick left to right

Hope that does the trick for you.

Thanks (1)
By Sarah Offord
13th May 2013 13:12

Thanks but

I'm using Excel 2007 and I cannot see that option anywhere!

Thanks (0)
avatar
By chetan
13th May 2013 13:36
Thanks (1)
avatar
By paulwakefield1
13th May 2013 13:37

For 2007

Apparently that option only appears if a right to left language is installed (so Google tells me!).

A workaround which may be more useful anyway if this is going to be a regular occrrence:

Office Button - Excel Options - Customize - Page Layout tab under "Choose Commands from" - Right to left Document and Add

This will put a button on the QAT which will toggle the column order.

 

Thanks (2)
By Sarah Offord
14th May 2013 13:46

You star!

Thank you so much for your help Paul!    I just couldn't get my head around working back to front!

Thanks (0)