Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Column A is on the right

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ahmad Mahran - 08 Apr 2008 18:38 GMT
Hi,
Can anyone help me Please?
When I launch excel 2007, the default page starts from right to left, i.e.
column A is in the far right!
how can I resore column A to be in the far left as usual?
Kindly email me your suggestions on mehro@eim.ae
Thanks
Ron de Bruin - 08 Apr 2008 19:04 GMT
Hi Ahmad

See
http://www.rondebruin.nl/sheetdirection.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Hi,
> Can anyone help me Please?
[quoted text clipped - 3 lines]
> Kindly email me your suggestions on mehro@eim.ae
> Thanks
Ahmad Mahran - 10 Apr 2008 20:02 GMT
Hi Ron,
Thank you for your kind assistance.
yes I had enabled Arabic,i.e. right to left language as a second language on
my computer.
You had mentioned in the link you sent me " The default sheet direction for
Excel you can change with this code line
Application.DefaultSheetDirection = xlLTR 'or use xlRTL"
Would you please explain how can I do that in easy steps please.
mehro@eim.ae is my email address.
I appreciate your help

> Hi Ahmad
>
[quoted text clipped - 8 lines]
> > Kindly email me your suggestions on mehro@eim.ae
> > Thanks
Ron de Bruin - 10 Apr 2008 20:24 GMT
Hi Ahmad

Open a new workbook
Alt F11
Use Insert module in the VBA editor
Copy this in the module

Sub test()
   Application.DefaultSheetDirection = xlLTR    'or use xlRTL"
   MsgBox "Ready"
End Sub

With your curser in this macro press F5 to run ther macro

Now close the file without saving

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Hi Ron,
> Thank you for your kind assistance.
[quoted text clipped - 19 lines]
>> > Kindly email me your suggestions on mehro@eim.ae
>> > Thanks
Ahmad Mahran - 10 Apr 2008 20:55 GMT
Thanks Ron it worked.
Now I have my A column on the left, but I have two pages!!
how can we have only one page at start up?
Sorry man.
Ahmad

> Hi Ahmad
>
[quoted text clipped - 35 lines]
> >> > Kindly email me your suggestions on mehro@eim.ae
> >> > Thanks
Ron de Bruin - 10 Apr 2008 21:15 GMT
With two pages you mean two sheets when you open a new workbook

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Thanks Ron it worked.
> Now I have my A column on the left, but I have two pages!!
[quoted text clipped - 41 lines]
>> >> > Kindly email me your suggestions on mehro@eim.ae
>> >> > Thanks
Ahmad Mahran - 10 Apr 2008 22:03 GMT
yes.
two pages

> With two pages you mean two sheets when you open a new workbook
>
[quoted text clipped - 43 lines]
> >> >> > Kindly email me your suggestions on mehro@eim.ae
> >> >> > Thanks
Ron de Bruin - 10 Apr 2008 22:13 GMT
Hi Ahmad

Office Button>Excel options
Popular

Change "Include this many sheets:" to 1

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> yes.
> two pages
[quoted text clipped - 46 lines]
>> >> >> > Kindly email me your suggestions on mehro@eim.ae
>> >> >> > Thanks
Ahmad Mahran - 11 Apr 2008 05:59 GMT
thanks a lot man

> Hi Ahmad
>
[quoted text clipped - 53 lines]
> >> >> >> > Kindly email me your suggestions on mehro@eim.ae
> >> >> >> > Thanks

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.