3 Ways to Swap Columns in Excel

 You created your Excel spreadsheet, but you see that the columns are in the wrong order. You might be tempted to erase everything and start over, but there are a few ways to rearrange the order without having to erase everything. With different methods to choose from, you can go with the one that best works for you. Keep reading to see what steps to follow to swap columns in Excel.

How to Swap Columns in Excel

Let’s get started with the fastest way to swap columns in Excel. First, select the column you want to move so that it’s highlighted. Place the cursor so that it turns into four arrows pointing in different directions.

Hold down the Shift key and drag the column to where you want to put it. As you drag it, you’ll see a green line where the column will appear. Let go of the buttons you’re pressing, and your column will be in its new area. That’s your first method and the quickest one. If you moved the wrong column, you can press Ctrl + Z, which will undo what you did. You can also use this method to select and move multiple columns.

Swap Columns in Excel: Sort and Filter

Another way you can swap columns is by using the Sort and Filter option. To try this method, you must have an empty row on top of the columns. If you don’t have that, you can easily insert a blank row by placing the cursor on the number and right-clicking. Choose the insert option, and a new row will be inserted.

AD

As you can see in the image below, the columns are not the order they should be, with the city first and the name in the third column. To rearrange them, number the columns in the order you want them to appear. For example, let’s say you want the name first, the address second, the city third, the state fourth, the phone number fifth, and the email last.

 Once the columns are numbered, click on the Home tab at the top and click Sort and Filter. Choose Custom Sort, followed by the Options button. If you don’t see this window, ensure that everything you want to move is selected, including the row you added.

In the Sort window (after you’ve clicked the options button), select the Sort left to right option and click OK. In the Sort by option, click the dropdown menu and choose Row 1. Also, ensure that the order menu is set from Smallest to Largest. This last option will be set to that by default, but if you see that it’s not, please change it.

AD

To apply what you’ve chosen, click OK, and the columns will be sorted in the order you put them in.

Place the cursor on the 1 and right-click > Delete to remove the row where you put the numbers. The row will disappear. This is one method where you will certainly move those columns around.

Try The Choose Function

The third method you can use to rearrange your Excel columns is the Choose function. Click on a cell in the area where you want to put the newly arranged columns. Enter: =CHOOSECOLS(A2:E14,1,4,3,2) and press enter.

The (A1:E14,1,4,3,2) is used as an example here; for it to apply to your Excel worksheet, change it so that the first part of the formula covers the cells you put the data in, and after that, type the column numbers in the order you want them to appear.

For example, I wanted column 1 to appear first, followed by 4,3,2. The A2:E14 is the cells that were taken up by my data. You can add this info by also using your mouse to highlight the data you want to include.

Conclusion

It can be time-consuming when you want to move specific columns around, but with the tips mentioned in this guide, you can move them around quickly. One step at a time, you’ll show everyone how good you are at Excel, and others may even ask you to show them how to do it. Which method was more straightforward for you to use? Share your thoughts in the comments below, and don’t forget to share the article with others on social media.

 

Links

https://my.omsystem.com/members/kotew
https://www.mifare.net/support/forum/users/kotew/
https://3dprintboard.com/member.php?123460-kotew
https://zumvu.com/kotew/
https://www.sqlservercentral.com/forums/user/kotew
https://www.themplsegotist.com/members/kotew/
https://triberr.com/kotew
http://uid.me/kotew_kotew#
https://www.developpez.com/user/profil/1834869/kotew
https://www.globalvision2000.com/forum/member.php?action=profile&uid=1007435
https://www.mapleprimes.com/users/kotew
https://commiss.io/kotew
http://gendou.com/user/kotew
https://www.castingcall.club/kotew
https://try.gitea.io/kotew
https://forums.stardock.com/user/7337483
https://forum.reallusion.com/Users/3155738/kotewo878
https://myanimeshelf.com/profile/kotew
http://www.rohitab.com/discuss/user/2003756-kotew/
https://illust.daysneo.com/illustrator/kotewer/
https://varecha.pravda.sk/profil/kotew/o-mne/
https://travel98.com/member/138611
https://www.chordie.com/forum/profile.php?id=1845503
https://www.liveinternet.ru/journal_proc.php?action=redirect&url=https://techbar.org/1and1-webmail/
https://opentutorials.org/profile/151634
https://camp-fire.jp/profile/kotew
https://kotewo.contently.com/
https://www.metal-archives.com/users/kotew
https://www.twitch.tv/kotewer
https://postgresconf.org/users/kotew-kotew
https://pxhere.com/en/photographer/4172516
https://spinninrecords.com/profile
https://perpignan.onvasortir.com/profil_read.php?Kotew
https://www.bibrave.com/users/233668
https://forum.ixbt.com/users.cgi?id=info:%3E1807405
https://robertsspaceindustries.com/citizens/kotew
https://conifer.rhizome.org/kotew
https://visual.ly/users/kotewo878/portfolio
https://www.tetongravity.com/
https://booklog.jp/users/meliodi/profile
https://myanimelist.net/profile/kotew
https://linktr.ee/kotew
https://pxhere.com/en/photographer/4172516
https://www.bahamaslocal.com/join/
https://www.diggerslist.com/65711ed40d57a/about
https://social.msdn.microsoft.com/Profile/kotew
https://3dprintboard.com/member.php?123460-kotew
https://droidsans.com/user/173120/
https://fileforums.com/member.php?u=272237
https://forum.singaporeexpats.com/memberlist.php?mode=viewprofile&u=653473
https://app.pluralsight.com/profile/kotew-o
https://www.xibeiwujin.com/home.php?mod=space&uid=2216815&do=profile&from=space
https://artmight.com/user/profile/3816310
https://community.wongcw.com/
https://www.openlearning.com/oauth/microsoft/?error=server_error&state=TeCQQ7Hv9uo0cEd1jTaQwUGjxxAkR8
https://amazonki.net/szukaj
https://www.findit.com/xmsudsmotnmyqno
https://www.imdb.com/user/ur176348825/?ref_=nv_usr_prof_2
https://forum.lacartoonerie.com/member.php?action=activate&uid=3690&code=v4TmeUku
https://events.opensuse.org/users/79817
https://iq.worldcrunch.com/
https://www.abclinuxu.cz/lide/kotew
https://www.elseptimoarte.net/foro/index.php?action=register
http://eldjeesr-immo.freehostia.com/kotew/
https://bitcointalk.org/index.php?action=profile;u=3605161;sa=summary
https://disqus.com/by/kotewo/about/
https://roomstyler.com/users/kotew
https://www.intensedebate.com/people/kotewRT
https://www.bandlab.com/user8415720893955633
https://globalhealthtrials.tghn.org/community/members/844195/
https://keymander.iogear.com/profile/179487/kotew?action=edit
https://visual.ly/users/yitwokeyto/portfolio
https://www.aparat.com/u_19127957
https://worldcosplay.net/member/1710314
https://www.wikidot.com/user:info/kotew
https://www.mojomarketplace.com/?utm_source=mojo-sunset&utm_medium=landing-redirect
https://challengeposts.com/register/
https://hub.docker.com/u/kotew
https://www.genglobal.org/user/register
https://www.passivehousecanada.com/members/kotew/
https://community.allen-heath.com/forums/users/rufind/
https://gfycat.com/@werttere
https://www.usgbc.org/leed/rating-systems/residential
https://www.yourquote.in/wert-tere-dsbpw/quotes
https://may-dialogue.lamayenne.fr/profiles/kotew/activity
https://board.radionomy.com/memberlist.php?mode=viewprofile&u=420708
http://vrc.org.au/forums/users/fermuru
https://fediverse.blog/@/coniqu
https://smotra.ru/users/kotew/
http://gpsarmenia.am/user/kewla/
https://challengeposts.com/register/
https://www.infragistics.com/community/members/d89011e75ec8576b19263c3273b6ef18e9cb22e4?_ga=2.49578726.1704521725.1703230825-1807046565.1672869914
https://app.zintro.com/profile/ziec70f6e9?ref=
https://ambitious-marigold-h69r7f.mystrikingly.com/
https://asmetalwork.com.ua/forum/user/profile/99945.page
https://https-47-47-www-techcreative-org-47-write-for-us-techno.myfreesites.net/
https://kotew.myfreesites.net/
https://myanimeshelf.com/profile/kotew
https://www.instapaper.com/read/1659740838
https://storify.co.uk/register/
https://slides.com/kotewo
https://buyandsellhair.com/author/kotew/
http://chernousovajazz.ru/user/kotew/
https://rpgmaker.net/users/Acanda12/
https://player.fm/kotewo
https://app.pluralsight.com/profile/kotew-o
https://decidim.rezero.cat/profiles/kotew/activity
https://blip.fm/kotewo878gmailcom
https://gamesurge.net/profile/graji/
https://topsitenet.com/startpage/kotew/1121651/
https://www.akaqa.com/account/profile/19191626636
https://ioby.org/users/kotewo878764649
https://bsaber.com/members/rufind/info/
https://www.beatstars.com/kotewo878
https://twinoid.com/user/10076287
https://communities.bentley.com/members/d69e5a7d_2d00_fa09_2d00_4290_2d00_a0b6_2d00_53b34bea279c
http://www.genina.com/user/profile/4138369.page
https://coub.com/dd4e7de648c702408652
http://www.orangepi.org/orangepibbsen/home.php?mod=space&uid=4520741
https://500px.com/p/kotewo878?view=photos
https://qooh.me/kotew
https://fairygodboss.com/users/profile/4CTWWf4S_f/Kotew-O
https://www.pearltrees.com/kotew#item571745790
http://gpsarmenia.am/user/kewla/
https://www.reverbnation.com/artist/kotew
https://www.openlearning.com/oauth/microsoft/?error=server_error&state=TeCQQ7Hv9uo0cEd1jTaQwUGjxxAkR8https://coolors.co/u/melio
https://iq.worldcrunch.com/
https://www.bitsdujour.com/profiles/UsjOsa
https://www.elseptimoarte.net/foro/index.php?action=register
http://sonicsquirrel.net/user/kotew
https://plazapublica.cdmx.gob.mx/profiles/meliodi/activity
https://linktr.ee/kotew
https://www.7sky.life/members/yitwo/
https://allods.my.games/forum/index.php?page=User&userID=130248
https://hitrecord.org/users/kotew/records
https://blogcircle.jp/user/jokider
http://maisoncarlos.com/UserProfile/tabid/42/userId/1864843/Default.aspx
https://fr-minecraft.net/forum/register.php
http://www.ccwin.cn/space-uid-12000736.html
https://www.longisland.com/profile/kotew/
https://pbase.com/profile/kotew
https://papaly.com/User479287/818GM/My-First-Board
https://www.instapaper.com/read/1659831984
https://beermapping.com/account/GrajiHe
https://www.evernote.com/shard/s615/client/snv?isnewsnv=true&noteGuid=8063f15e-4da6-42f9-f14f-3c57d162e350&noteKey=1jnEUNMtRE6D1KEERvsas2o-p6czEBmcbcntB5I_Y6pM-pxBc_bGM92Slw&sn=https%3A%2F%2Fwww.evernote.com%2Fshard%2Fs615%2Fsh%2F8063f15e-4da6-42f9-f14f-3c57d162e350%2F1jnEUNMtRE6D1KEERvsas2o-p6czEBmcbcntB5I_Y6pM-pxBc_bGM92Slw&title=kotew
https://link.space/@kotew
http://parsiyar.ir/u12a82457e7853703/Feeds
https://chadstonetabletennis.com/
https://www.silverstripe.org/ForumMemberProfile/show/131813
https://ict-edu.uk/register/
https://pubhtml5.com/homepage/ycafu/
https://ancien.escalade-alsace.com/forum/profile.php?mode=register&sid=5255e869ea4f15a37e395eab2e206603
http://biowong.freehostia.com/phpbb2/profile.php?mode=viewprofile&u=146475
https://grizzled-blob-f5c.notion.site/kotew-1d21474f4e0e4ad8b64ad616dba3d45f
https://joy.link/kotew
https://www.walkscore.com/people/208185251424/walk-score-user
https://us.community.sony.com/s/?language=en_US
https://pantip.com/profile/7951887#topics
https://app.zintro.com/profile/ziec70f6e9
https://www.curioos.com/kotew
https://community.avid.com/members/meliodi/default.aspx
https://www.wantedly.com/signin_or_signup?redirect_to=https%3A%2F%2Fwww.wantedly.com%2Fid%2Flekiar_vase&social_login=true&step=signup
https://www.sampleboard.com/profile/203791
https://band.us/band/93672495/post/1
https://bitcoinblack.net/community/fermuru/info/
https://biashara.co.ke/author/kotew/
http://www.clubwww1.com/dating/false_page.html
https://profile.ameba.jp/ameba/jagedi
https://pixelhub.me/rufind
http://participons.debatpublic.fr/profiles/Pepert/activity
https://buddypress.org/members/denvert/profile/
https://themepacific.com/support/users/kotewo878/
http://www.servinord.com/phpBB2/profile.php?mode=viewprofile&u=571163
http://www.getjob.us/usa-jobs-view/job-posting-869008-scasc.html
https://twinoid.com/user/10076287
http://foxsheets.com/UserProfile/tabid/57/userId/171297/Default.aspx
https://myopportunity.com/profile/kotew-kotew/nw
https://gotartwork.com/Profile/kewla-kewla/261029/
http://warhammer.world.free.fr/index.php?sid=8047dff8db898914a0a1cae9d8e26b02
https://battlelog.battlefield.com/bf4/user/q3so9qypm02p/
https://www.aphorismsgalore.com/users/kotew
https://uklianjiang.com/member.php?mod=register
https://www.hd.club.tw/space-uid-2973303.html
https://tesera.ru/user/kotew
https://www.xibeiwujin.com/home.php?mod=space&uid=2215505&do=profile&from=space
https://starity.hu/profil/404638-graji/
https://favinks.com/profile/MarbelMarbelYXce5/
https://apk.tw/member.php?mod=register
http://gitlab.sleepace.com/yitwo
http://arahn.100webspace.net/profile.php?mode=viewprofile&u=137500
https://www.efunda.com/members/people/show_people.cfm?Usr=kotew
https://coolors.co/u/kotew_o
https://doodleordie.com/profile/kotew
https://www.dermandar.com/user/kotew/
http://ttlink.com/main/openid
http://cannabis.cluster005.ovh.net/french/forum/member.php?u=1218105
https://www.beqbe.com/p/melio
http://cannabis.cluster005.ovh.net/french/forum/member.php?u=1218105
https://peatix.com/user/20759469/view
https://www.producthunt.com/@kotew_o

 

Comments

Popular posts from this blog

Jira for Project Estimation and Planning

Portable Washing Machines