sheet view

  • Thread starter Thread starter Walt
  • Start date Start date
W

Walt

First time using this version of excel. All of the column headings are from
right to left. How do I change the headings to left to right? Havew looked
through all of the tabs and don't see that option anywhere. Thanks
 
First time using this version of excel.
What version? You should have stated.

If in excel 2003 (my ver),
You could try check the settings in the International tab
Click Tools > Options > International tab
Check "Left-to-right"
Uncheck "View current sheet right-to-left"
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
 
I remember Roger Govier posted this for Excel 2007:

"Press round Office Button>Excel Option>Customise>use dropdown on Choose
Commands from>All Commands>scroll down to Right to Left
Document>Highlight>Add

This will place an icon on the QAT (Quick Access Toolbar) which, when
pressed will do what you require"
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---
 
Thank you for the response. I tried doing what you suggested and I did get
the icon on the QAT. However, pressing the icon doesn't change the way the
columns are displayed. Still have column "A" on the right. Any other things I
can ttry?
 
Sorry. 2007 version.

Max said:
What version? You should have stated.

If in excel 2003 (my ver),
You could try check the settings in the International tab
Click Tools > Options > International tab
Check "Left-to-right"
Uncheck "View current sheet right-to-left"
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
Click to expand...
 
Thank you for the reply. I'm using excel 2007. Earlier versions are a lot
easier to use. I am thinking of removing this version in favor of earlier
versions. I wonder if they will work with vista? If you could help with this
version I would be grateful.
 
Back
Top