[vally]

Hi there

I have an excel document that the columns are set from left to right. The data is also represented from left to right.
I want to change the columns from right to left but the data to stay from left to right.

see attached file

** The document I am working with as 20 columns

Thanx

Attached Thumbnails

• 

Edited by vally, 20 July 2012 - 03:26 AM.

[Advertisements]

Right click the sheet 1 tab at the bottom of the sheet
Click view code
Select the sheet you want to change
Then change Display right to left to TRUE in the drop down box
This is for Excel 2010 is this what you are looking for

[peter99]

Right click the sheet 1 tab at the bottom of the sheet
Click view code
Select the sheet you want to change
Then change Display right to left to TRUE in the drop down box
This is for Excel 2010 is this what you are looking for

[vally]

Thanks for the reply.

Changing the display right to left to true is the same as choosing the right to left layout.
I need what is in the left column to stay on the left side.