Abaabulka xaashida xaashida ee Excel mar walba ma fududa, gaar ahaan marka xaashiyahaasi ay waaweyn yihiin. Laakiin haddii aad taqaano sida loo dhaqaajiyo tiirarka Excel si wax ku ool ah, waxaad dib u habeyn kartaa xitaa xaashiyaha waaweyn adiga oo aan kharribin dhammaan xogta iyo xisaabaadka gudaha ku jira.

Maqaalkan, waxaad ku baran doontaa saddex siyaabood oo loo dhaqaajiyo tiirarka Excel iyo xaaladaha hab kastaa uu yahay habka ugu wanaagsan ee loo isticmaalo:

• Koobiyaynta iyo gelinka tiirarka
• Isticmaalka koobiyeynta oo dheji qaababka gaaban
• Isticmaalka furaha Shift iyo jiirka

Mid kasta oo ka mid ah farsamooyinkan, waxaad baran doontaa sida loo isticmaalo si loo dhaqaajiyo tiirarka adoon dib u qorin tiirar kale^{(overwriting other columns)} ama lumin wax xog ah oo ku jirta xaashidaada.

^{(Move Columns)}Ku Dhaqaaq Tiirarka Excel - Jidka Caadiga ah^{(Standard Way)}

Marka dadka intooda badan ay rabaan in ay ka guuraan tiir hal boos oo ay u guuraan meel kale, waxay qaataan habka dadka intooda badan ay ogaadaan. Habkani wuxuu qaadaa tillaabooyin ka badan kuwa kale ee lagu tilmaamay maqaalkan. Si kastaba ha ahaatee, waxaa muhiim ah in la tuso habka si aad u aragto inta wakhti ee la kaydiyay adigoo isticmaalaya mid ka mid ah hababka kale.

1. Midig ku dhufo madaxa tiirka meesha aad rabto inaad dhigto tiirka oo dooro Geli^(Insert) . Tani waxay abuuri doontaa tiir maran oo aad dhigi karto tiirka aad rabto inaad guurto.

2. Ka dooro^(Select) dhammaan unugyada tiirka aad rabto inaad nuqul ka sameyso. Kaliya dooro^(Select) unugyada, ha dooran tiirka oo dhan. Midig^(Right) ku dhufo unugyada la iftiimiyay oo dooro Goo^(Cut) .

3. Midig ku dhufo unugga kowaad ee tiirka maran ee aad abuurtay oo dooro paste . Ama isticmaal kiiboodhka Ctrl-V si aad xogta ugu dhejiso tiirka bannaan.^(Ctrl-V)

4. Hadda tiirka asalka ahi wuxuu noqonayaa mid madhan. Dooro tiirka oo dhan, midigta guji madaxa, oo dooro Delete .

Hadda tiirkii asalka ahaa waa la tirtiray, xogta tiirkana waxa la dhigayaa meeshii aad rabtay inay aaddo.

Ku Dhaqaqo Tiirarka Koobiyayna Geli

Habka ugu dhaqsiyaha badan ee loo dhaqaajiyo tiirarka Excel waa adeegsiga astaanta Gelida ee Excel^{(Insert feature in Excel)} . Habkani wuxuu kuu ogolaanayaa inaad ka gudubto laba tallaabo - abuurista tiir maran oo tirtirto tiirka guuray. 

1. Dooro xagga sare ee tiirka kowaad si tiirka oo dhan loo doorto. Midig^(Right) ku dhufo oo dooro gooyo^(Cut) . Haddii kale, waxaad riixi kartaa Ctrl + C si aad u jarto tiirka. 

2. Dooro tiirka dhanka midig ee meesha aad rabto inaad u guurto tiirkaaga. Midig^(Right) ku dhufo xagga sare ee tiirka oo dooro Geli Unugyada Goy^{(Insert Cut Cells)} . Beddelka doorashada kan, waxaad taa beddelkeeda dooran kartaa Ctrl iyo calaamadda lagu daray ( + ) ee kumbuyuutarka. Tani waxay sidoo kale gelin doontaa unugyada la jaray dhanka bidix ee tiirka aad dooratay.

Labadan tilaabo ka dib, tiirkaaga gooyay waxa la gelinayaa meesha aad dooratay. 

Runtii way fududahay taas.

Waxa kale oo aad dhaqaajin kartaa tiirar badan oo Excel ah adiga oo raacaya talaabooyin isku mid ah. Kaliya waxaad u baahan tahay inaad doorato tiirar badan ka hor intaadan dooran gooyn^(Cut) . Markaad geliso unugyada la jaray, waxay gelin doontaa labada tiir ee aad hore u jartay.

Xaddidaad kaliya ayaa ah in tiirarka aad isticmaashid ay u baahan yihiin in la is garab dhigo.

^{(Move Columns)}Ku Dhaqaaq Tiirarka Furaha Shift^{(Shift Key)} iyo Mouse

Siyaabo kale oo loo dhaqaajiyo tiirarka Excel waa adeegsiga furaha Shift ee kumbuyuutarkaaga, iyo jiirka. 

Habkani wuxuu u baahan yahay inaad abuurto 

1. Geli^(Insert) tiir maran meesha aad jeclaan lahayd inaad tiirkaada u guurto xaashidaada xaashida. Isticmaal habraac la mid ah sidii aad ku samaysay qaybta koowaad ee maqaalkan. Midig^(Right) ku dhufo tiirka oo dooro Geli^(Insert) .

1. Dooro tiirka oo dhan (ama tiirar badan) oo aad rabto inaad nuqul ka sameyso. U dhaqaaq curiyaha jiirka mid ka mid ah soohdinta bidix ama midig ee tiirka ilaa tusaha jiirka uu u beddelo tilmaame leh calaamad bartilmaameed.

3. Bidix^(Left) guji oo qabo jiirka, oo tiirka u jiid tiirka maran ee aad abuurtay. Markaad sii deyso tilmaame jiirka, Excel wuxuu ku weydiin doonaa haddii aad rabto inaad bedesho waxa ku jira tiirka. Maadaama aad tiirka bannaan ka dhigtay, kaliya waxaad dooran kartaa OK . 

Tani waxay gelin doontaa tiirkaaga booska midka bannaan.

Haddii aad rabto inaad ka gudubto tallaabada abuurista tiir maran, kaliya midig-guji jiirkaaga si aad u jiiddo tiirka halkii aad isticmaali lahayd badhanka jiirka bidix. Tiirka u jiid si la mid ah, laakiin ku sii da tiirka meesha aad rabto inaad tiirkaaga bidix geliso. Marka aad sii dayso waxaad arki doontaa dhawr ikhtiyaar oo ah sida loo geliyo tiirarka booska.

Haddii aad dooratay tiirka dhinaca midig ee meesha aad rabto inaad dhigto tiirkaagii guuray, dooro Shift Right oo dhaqaaq^{(Shift Right and Move)} si aad u geliso tiirarkaaga oo u beddel tiirarka intiisa kale dhanka midig.

Isticmaalka habkan (midig-riixista) waxay yaraynaysaa tirada tillaabooyinka ku lug leh xulashada tiirka, midigta guji oo u jiid tiirka meel kasta oo aad rabto inuu aado. Ilaa hadda tani waa habka ugu fudud ee loo dhaqaajin karo tiirarka Excel .

Qaabkee Kugu Haboon?

Dad kala duwan ayaa doorbidaya isticmaalka kumbuyuutarka ama jiirka si ay wax ugu qabtaan Excel . Ma jiro hab dhab ah oo ka wanaagsan kan xiga. Runtii waxay ku soo degtaa nidaamka kore ee ku habboon sida caadiga ah ee Excel .

Dhaqdhaqaaqa tiirarka Excel maaha inay noqdaan kuwo adag, mana aha inay kharribaan xaashidaada oo dhan. Kaliya^(Just) si taxadar leh uga shaqee tillaabooyinka faahfaahsan ee kor ku xusan oo waxaad si dhakhso leh oo fudud u dhaqaajin kartaa tiirarka oo dhan.

Dhammaan farsamooyinkan waxay sidoo kale la shaqeeyaan safafka dhaqaaqa ee Excel^{(moving rows in Excel)} sidoo kale.

How To Move Columns In Excel

Organizing your Excel spreadsheets isn’t alwаys easy, especially when those spreаdsheеts are large. But if you know hоw to move columns іn Excel more efficіently, yoυ can rеorganize even large spreadsheets without messing up all of the data and calculations insіde of them.

In this article, you’ll learn three ways to move columns in Excel and the situations where each approach is best approach to use:

• Copying and inserting columns
• Using copy and paste shortcuts
• Using the Shift key and the mouse

With each of these techniques, you’ll learn how to use them to move columns without overwriting other columns or losing any data in your spreadsheet.

Move Columns In Excel – The Standard Way

When most people want to move a column from one position to another, they take the approach most people know about. This approach takes extra steps than the others described in this article. However, it’s important to show the process so you can see how much time is saved by using one of the other approaches.

1. Right-click the header of the column where you want to place the column and select Insert. This will create a blank column where you can place the column you want to move.

2. Select all of the cells from the column you want to copy. Select only the cells, not the entire column. Right click the highlighted cells and select Cut.

3. Right-click the first cell in the empty column you created and select Paste. Or use the Ctrl-V keyboard shortcut to paste the data into the blank column.

4. Now the original column will be blank. Select the entire column, right click the header, and select Delete.

Now the original column is deleted, and the data from the column is placed where you wanted it to go.

Move Columns With Copy And Insert

A much faster approach to move columns in Excel is using the Insert feature in Excel. This approach lets you skip over two steps – creating a blank column and deleting the moved column. 

1. Select the top of the first column so that the whole column is selected. Right click and select Cut. Alternatively, you can press Ctrl + C to cut the column. 

2. Select the column to the right of where you want to move your column. Right click the top of the column and select Insert Cut Cells. As an alternative to selecting this, you could instead select Ctrl and the plus sign (+) on the keyboard. This will also insert the cut cells to the left of the column you’ve selected.

After just these two steps, your cut column gets inserted in the location you’ve selected. 

It’s really as simple as that.

You can also move multiple columns in Excel by following the same steps. You just need to select multiple columns before you select Cut. When you insert the cut cells, it’ll insert the two columns that you previously cut.

The only limitation is that the columns you use need to be positioned beside one another.

Move Columns With Shift Key And Mouse

Another way to move columns in Excel is using the Shift key on your keyboard, and the mouse. 

This approach does require that you create 

1. Insert a blank column where you’d like to move your column to in your spreadsheet. Use the same procedure as you did in the first section of this article. Right click the column and select Insert.

1. Select the entire column (or multiple columns) you want to copy. Move the mouse cursor to either the left or right border of the column until the mouse pointer changes to a pointer with target symbol.

3. Left click and hold the mouse, and drag the column into the blank column you’ve created. When you release the mouse pointer, Excel will ask you if you want to replace the contents of the column. Since you’ve made the column blank, you can just select OK. 

This will place your column into the position of the blank one.

If you want to skip the step of creating a blank column, just right-click your mouse to drag the column rather than using the left mouse button. Drag the column over in the same way, but release it on the column where you’d like to insert your column to the left. When you release you’ll see several options of how to insert to column into the slot.

If you’ve selected the column to the right of where you want to place your moved column, select Shift Right and Move to insert your column and shift the rest of the columns to the right.

Using this approach (right-clicking) reduces the number of steps involved to just selecting the column, right clicking and dragging the column to wherever you would like it to go. By far this is the easiest way to move columns in Excel.

Which Method Is Right For You?

Different people prefer using the keyboard or the mouse to do things in Excel. No approach is necessarily better than the next. It really comes down to which procedure above fits in best into how you normally use Excel.

Moving columns in Excel doesn’t have to be complicated, and it doesn’t have to mess up your entire worksheet. Just carefully work through the steps detailed above and you can move entire columns quickly and easily.

All of these techniques also work with moving rows in Excel as well.

Related posts

• Safka Kooxda iyo Tiirarka ku jira xaashida shaqada ee Excel

• Sida Loo Mideeyo Unugyada, Tiirarka & Safafka gudaha Excel

• Sida loo tirtiro khadadka banaan ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Sida Loo Geliyo CSV ama TSV Xaashida Shaqada ee Excel

• Waa maxay VBA Array ee Excel iyo Sida loo Barnaamijyo Mid

• Sida Loogu Mideeyo Xogta Faylal Badan oo Excel ah

• Sida loo Isticmaalo If iyo Nsted Haddii Odhaahyada Excel

• Goorta la Isticmaalayo Tusaha-Match Bedelkii VLOOKUP ee Excel

• Sida Taariikh ahaan loogu kala saaro Excel

• Sida Loo Hagaajiyo Safka gudaha Excel

• Sida Loo Abuuro VBA Macro Ama Script gudaha Excel

• 4 siyaabood oo loo isticmaalo calaamadda jeeg ee Excel

• Sida loo raad raaco Ku-tiirsanaanta gudaha Excel

• 10 Talooyin iyo Tabaha Excel ee 2019

• Sida loo qoro IF Formula/Bayaanka gudaha Excel

• Sida Loo Sameeyo Shaxda Pivot Fudud ee Excel

• Isticmaal kiiboodhka si aad u bedesho dhererka safka iyo ballaca tiirka gudaha Excel

• Waa maxay sababta ay tahay inaad u isticmaasho safafka la magacaabay ee Excel