excels 2007 columns run right to left
in [Microsoft Office]
|
Prev: Office 2007 proofing tools - English UK
Next: I ordered and paid for Microsoft Office Ultimate 2007 (windowsxp/vista)
From: syed_sal_ali on 2 May 2010 06:12 i have a problem, the columns in my excel blank template run right-left...i have tried everything but they all result in changing the direction of the text within the cells but not the direction of columns.......i need help urgently, have a project coming up and am running out of time.i have attached a screen from the worksheet. thnaks +-------------------------------------------------------------------+ |Filename: Untitled.jpg | |Download: http://forums.techarena.in/attachment.php?attachmentid=10880| +-------------------------------------------------------------------+ -- syed_sal_ali ------------------------------------------------------------------------ syed_sal_ali's Profile: http://forums.techarena.in/members/215772.htm View this thread: http://forums.techarena.in/ms-office-support/1332979.htm http://forums.techarena.in
From: Db on 2 May 2010 13:23 look up "default direction" in options. you might find how to do the above via help/ f1. after you set the default to left to right, restart excel. "syed_sal_ali" <syed_sal_ali.4abz5c(a)DoNotSpam.com> wrote in message news:syed_sal_ali.4abz5c(a)DoNotSpam.com... > > i have a problem, the columns in my excel blank template run > right-left...i have tried everything but they all result in changing the > direction of the text within the cells but not the direction of > columns.......i need help urgently, have a project coming up and am > running out of time.i have attached a screen from the worksheet. > thnaks > > > +-------------------------------------------------------------------+ > |Filename: Untitled.jpg | > |Download: http://forums.techarena.in/attachment.php?attachmentid=10880| > +-------------------------------------------------------------------+ > > -- > syed_sal_ali > ------------------------------------------------------------------------ > syed_sal_ali's Profile: http://forums.techarena.in/members/215772.htm > View this thread: http://forums.techarena.in/ms-office-support/1332979.htm > > http://forums.techarena.in >
From: syed_sal_ali on 2 May 2010 14:22 thanks...but the problem is that my excel has no option "international", i have searched everywhere. plz help.if it helps, i have the professional version of office. thanks +-------------------------------------------------------------------+ |Filename: Untitled1.jpg | |Download: http://forums.techarena.in/attachment.php?attachmentid=10881| +-------------------------------------------------------------------+ -- syed_sal_ali ------------------------------------------------------------------------ syed_sal_ali's Profile: http://forums.techarena.in/members/215772.htm View this thread: http://forums.techarena.in/ms-office-support/1332979.htm http://forums.techarena.in
From: LD5SZRA on 2 May 2010 16:20 Assuming you don't have any special language settings like Arabic or Hebrew, I suggest that you should uninstall the entire Office 2007 from your system, then reboot yur system and then reinstall Office 2007 again. this should sort itself out and save you valuable time. Have you tried running Office diagnostics to see if it can sort out this problem? hth syed_sal_ali wrote: > > i have a problem, the columns in my excel blank template run > right-left...i have tried everything but they all result in changing the > direction of the text within the cells but not the direction of > columns.......i need help urgently, have a project coming up and am > running out of time.i have attached a screen from the worksheet. > thnaks > > +-------------------------------------------------------------------+ > |Filename: Untitled.jpg | > |Download: http://forums.techarena.in/attachment.php?attachmentid=10880| > +-------------------------------------------------------------------+ > > -- > syed_sal_ali > ------------------------------------------------------------------------ > syed_sal_ali's Profile: http://forums.techarena.in/members/215772.htm > View this thread: http://forums.techarena.in/ms-office-support/1332979.htm > > http://forums.techarena.in -- THE INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. LD5SZRA DISCLAIMS ALL WARRANTIES, EITHER EXPRESSED OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL LD5SZRA OR ITS ASSOCIATES BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF LD5SZRA OR ITS ASSOCIATES HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright LD5SZRA 2010.
From: Db on 2 May 2010 16:28
yeah, I think you/we discovered a bug in excel 2007. once the option "right to left" is selected, the option for "left to right" is removed. one possible method is to reinstall excel but I haven't tried it. --------------------- there is however a possible work around with the current installation of excel and it's slightly tricky. open a blank workbook in excel. then under the "view" menu option select "arrange all" for the opened worksheet. then select "cascade" at the left hand corner and above the first cell the work book name will be notated. right click on it and select "view code" this will take you to the worksheets' visual basic module. then you will see "vba project" at the top of the left hand window and you will be able to click on each spreadsheet that is notated under it. for each sheet there will be a properties sheet in the window below and it will have "display right to left", in which case you modify that property from true to false afterwards select "file" from the menu bar and save then exit and you will be taken back to the worksheet. hopefully the columns will be left to right. you will then need to save the worksheet. choose "save as" "other formats" via the office button and name the file book1 and then select the file type as "excel macro enable workbook." then try to save your work book in: \Program Files)\Microsoft Office\ Office12\XLSTART also, might as well save a copy in "my documents". ---------------------- if you have a problem with saving the workbook in the "\xlstart" folder, it may be due to not having admin priviledges. if so, exit excel and right click on the excel short cut to pull up the properties page. I'm sure you have seen the properties page for shortcuts because it provides the option to run in "compatibility" mode however, you will need to look around for the option to "run as administrator". after you save/apply the modification above you should be able to save into the xlstart folder., so open excel and book1 that you saved in my documents. then try to save it as "book1" as a "excel macro enabled" file into the xlstart folder: [ \Program Files)\Microsoft Office\ Office12\XLSTART] you should be able to save it there and it should open up with the left to right columns when you startup excel. -------------------- another trick is to hold down the ctrl key and click the excel shortcut until a box pops up citing that it will open in safe mode. the worksheet will open with the columns left to right. unfortunately, I am not sure what all is disabled other than add-ins. but you can try it out and get back with us. ~db "syed_sal_ali" <syed_sal_ali.4aclda(a)DoNotSpam.com> wrote in message news:syed_sal_ali.4aclda(a)DoNotSpam.com... > > thanks...but the problem is that my excel has no option "international", > i have searched everywhere. > plz help.if it helps, i have the professional version of office. > thanks > > > +-------------------------------------------------------------------+ > |Filename: Untitled1.jpg | > |Download: http://forums.techarena.in/attachment.php?attachmentid=10881| > +-------------------------------------------------------------------+ > > -- > syed_sal_ali > ------------------------------------------------------------------------ > syed_sal_ali's Profile: http://forums.techarena.in/members/215772.htm > View this thread: http://forums.techarena.in/ms-office-support/1332979.htm > > http://forums.techarena.in > |