Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Oct 2009
    Posts
    471
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Smile Interchanging columns in Excel 2010

    Hi,

    I am using Excel 2010. I would like to know if it is possible to interchange two columns. For example, I have an Excel document in which column 1 is titled Problem # and column 2 is titled Page. I would like make Column 2 my Column 1 and my Column 1 column 2.

    If this is possible, please show me how to do it.

    Thank you very much.

    Moon

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Click the column header for column B. Hold the shift key, move the mouse over the left edge of the selected column (over the worksheet, not the column headers) until it changes to a black cross with 4 arrow heads, then click and drag left. You should see an indicator bar of where the column will go. Release the mouse when the indicator is to the left of column A.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    4 Star Lounger
    Join Date
    Oct 2009
    Posts
    471
    Thanks
    3
    Thanked 2 Times in 2 Posts
    Thank you very much, rory.

    Have a real Good one, and Beautiful Olympics there. Congratulations.

    Moon

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •