Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel - swap column side not data


  • Please log in to reply

#1
vally

vally

    Member

  • Member
  • PipPipPip
  • 573 posts
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

  • excel.jpg

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

  • 0

Advertisements


#2
peter99

peter99

    Member

  • Member
  • PipPipPip
  • 283 posts
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
  • 0

#3
vally

vally

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 573 posts
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.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP