2 Ways to Move or Swap Columns or Rows in Excel

In an Excel file, sometimes you may input some information to the wrong cells. Hence you should change the position. Therefore, today we have the Excel tips of moving or swapping columns or rows in a worksheet.

Sometimes in an Excel file, you need to input a lot of information into it. But things are not always perfect, and Excel files are no exception. There is a possibility that you need to switch information of different columns or rows. And for instance, here you can see a worksheet of several employees.Sales Volume for Swapping Columns

When you need to check the numbers of each person and each season, you find that the data of season 1 and season 2 is in the wrong place. Thus, now you need to swap the two columns. And in the following context, we will introduce two ways to solve this problem.

Copy and Paste

This is a very common method for many operations in Excel. And in this condition, you can also use this method. And the following are the steps.

  1. Create a new column between the column C and column D.Create a New Column
  2. And then select the data in column C.
  3. Press the keys “Ctrl + X”.
  4. Click the cell D1.
  5. And then press the key “Ctrl + V”.Copy Column
  6. And now select the data in column E.
  7. Press the keys “Ctrl + X”.
  8. Click the cell C1.
  9. And then press the key “Ctrl + V”.Copy Column to column C
  10. Input the header “season 2” into the cell D1.
  11. And then delete the column E in the worksheet.The Changed Columns

After all the above steps, now you have corrected the data and get a new worksheet. And this method is also suitable for swapping rows.

A Better Way to Swap Adjacent Columns

  1. Select the data in Column C.
  2. Press the key “Shift” on the keyboard and hold it.
  3. Move your mouse to the right border. Then you see the shape like the image shows, click your mouse.The Shape of Mouse
  4. Drag it to the right border of column D. and you will see this shape.The New Shape

And now you can release the button and the mouse. Then you will find that the numbers change. And you can also move columns to other places that you need. In addition, the method is also suitable for swap rows.

Excel can also Cause Shock to You

While Excel is very powerful, it can sometimes cause distress to you. For example, you can’t open your Excel file. Thus, you may consider that you meet with Excel corruption. We recommend that you can use the third party tool to fix Excel file. After all, using a powerful tool is better than losing all your information.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com

3 responses to “2 Ways to Move or Swap Columns or Rows in Excel”

  1. Content from TOR websites Magic Kingdom, TLZ,
    Childs Pl ay, Baby Heart, Giftbox, Hoarders Hell,
    OPVA, Pedo Playground, GirlsHUB, Lolita City
    More videos and girls and boy




  2. ####### OPVA ########

    Description:-> gg.gg/lua7w

    Webcams РТНС 1999-2021 FULL
    STICKAM, Skype, video_mail_ru
    Omegle, Vichatter, Interia_pl
    BlogTV, Online_ru, murclub_ru

    Complete series LS, BD, YWM
    Sibirian Mouse, St. Peterburg
    Moscow, Liluplanet, Kids Box
    Fattman, Falkovideo, Bibigon
    Paradise Birds, GoldbergVideo
    Fantasia Models, Cat Goddess
    Valya and Irisa, Tropical Cuties
    Deadpixel, PZ-magazine, BabyJ
    Home Made Model (HMM)

    Gay рthс collection: Luto
    Blue Orchid, PJK, KDV, RBV

    Nudism: Naturism in Russia
    Helios Natura, Holy Nature
    Naturist Freedom, Eurovid

    ALL studio collection: from
    Acrobatic Nymрhеts to Your
    Lоlitаs (more 100 studios)

    Collection european, asian,
    latin and ebony girls (all
    the Internet video) > 4Tb

    Rurikon Lоli library 171.4Gb
    manga, game, anime, 3D

    This and much more here:
    or –> gg.gg/ntwfm
    or –> cpc.cx/uVc
    or –> xor.tw/4pt0y
    or –> v.ht/LEYc
    or –> cutt.us/jKbHA
    or –> gg.gg/ntwgr
    or –> v.ht/kIy2
    or –> gurl.pro/k6ftqd
    or –> gg.gg/ntwhd

Leave a Reply

Your email address will not be published. Required fields are marked *