Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel problem: reverse order 1

Status
Not open for further replies.

darkwraith

Programmer
May 26, 2003
44
IT
I have an excel sheet. I don't know what has happened but the columns are put in reverse order (from Z to A) and everithing is ordered from right to left.
Does anyone know hot to put it in the correct order?
Thanks in advance,
Elena
 
Hi,

I'm guessing that sumbudy's playin' mind games with you.

Go to menu item Tools/Options - View tab and see that Windo Options - Row & Column headers is checked.

Skip,
Skip@TheOfficeExperts.com
 
rotflmao

I love doing this to people (sad I know)

Tools / Options / International Tab / View current sheet right to left (Uncheck it)

Regards
Ken................
 
OP didn't say but I'm guessing they are using 2002 and you are using 2000. It was a new gizmo in the XP version, one that I never had any idea why someobody would want to be able to do it, and I then came across a post from someone in a group somewhere asking if there was any way they could reverse their screen as their culture was used to reading data the other way - I went 'WOW!!! - That's what it's for!!!' :) Funny old world.

Regards
Ken.................
 
Well the thought went thru my mind about languages that read right to left. I thought there must be an international setting somewhere.

Good job, with the Wright answer! ;-)

Skip,
Skip@TheOfficeExperts.com
 
Thanks a lot, guys.
I've used Office 200 so far, so I was a bit unskilled with xp. :)
Elena
 
The differences for most users are quite minimal, and you just happen to have come across one of those features. :)

Regards
Ken...............
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top