ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Right-to-Left direction (https://www.excelbanter.com/excel-worksheet-functions/150138-right-left-direction.html)

Ninad

Right-to-Left direction
 
Config - Vista Home Premium, Office 2007

I have the defaults as UK keyboard and Language to US.

The default worksheet in Excel 2007 is Right-To-Left. How do I change
from Left-To-Right ?

Any help will be appreciated.

Regards,

Ninad.


Ron de Bruin

Right-to-Left direction
 
In the Beta there was a option to chnage this but I can find it anymore

You can use code to do it

Run this code line one time

Application.DefaultSheetDirection = xlRTL




--

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


"Ninad" wrote in message s.com...
Config - Vista Home Premium, Office 2007

I have the defaults as UK keyboard and Language to US.

The default worksheet in Excel 2007 is Right-To-Left. How do I change
from Left-To-Right ?

Any help will be appreciated.

Regards,

Ninad.


Ron de Bruin

Right-to-Left direction
 
Hi Ninad

I add a page to my site aboutthis problem
http://www.rondebruin.nl/sheetdirection.htm

You can find a toggle macro there that you can use

--

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


"Ron de Bruin" wrote in message ...
In the Beta there was a option to chnage this but I can find it anymore

You can use code to do it

Run this code line one time

Application.DefaultSheetDirection = xlRTL




--

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


"Ninad" wrote in message s.com...
Config - Vista Home Premium, Office 2007

I have the defaults as UK keyboard and Language to US.

The default worksheet in Excel 2007 is Right-To-Left. How do I change
from Left-To-Right ?

Any help will be appreciated.

Regards,

Ninad.



All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com