Isku darka iyo isku darka unugyada Excel waa mid waxtar leh marka la habeynayo liisaska marka la abuurayo cinwaano/hoos-u-dhacyo, ama meesha laga saarayo. Waxaa jira noocyo kala duwan oo isku-darka ah ee Excel waxaanan ka wada hadli doonnaa nooca anagoo adeegsanayna aaladda Merge/Unmerge halkan.

Sida loo midoobo^(Merge) oo loo kala saaro^(Unmerge) unugyada Excel

Waxaa jira siyaabo badan oo la isugu daro unugyada iyo tiirarka gudaha Excel . Haddii aad u baahan tahay inaad ku biirto unugyo badan adigoon lumin xogta, isku day inaad ku biirto unugyada Excel adoo isticmaalaya shaqada Concatenate .

Qalabka Isku^(Merge) -dhafka iyo Isku- dhafka^(Unmerge) ayaa ka tirtiraya xogta unug kasta oo ku jira xulashada aan ahayn midka bidix ee sare. Isticmaalka aasaasiga ah ee qalabkani waa in la abuuro unug isku dhafan oo weyn oo loogu talagalay qorista cinwaannada iyo qoraal-hoosaadyada xitaa ka hor inta aan la gelin xogta dhabta ah.

Ikhtiyaarka isku- dhafka^(Merge) unugyadu waa meelo kala duwan oo kala duwan ee tifaftirayaasha Excel iyo noocyada kala duwan ee MS Excel . Guud ahaan^(Generally) , waxaad ka heli doontaa bogga guriga. Tusaale ahaan, waxaanu tixgelinnay xaashida internetka ee Excel ee tusaalaha hoose.

Qalabka Isku - ^(Alignment)dhafka iyo Xarunta^{(Merge and Center tool)} wuxuu ku yaalaa tiirka toosinta ee tifaftiraha internetka ee Microsoft Excel .

Aynu ka soo qaadno, waxaad u baahan tahay inaad ku biirto unugyada u dhexeeya xulashada C3, E3, E5, iyo C5.

Dooro unugyada oo guji falaarta tilmaamaysa hoos ee u dhiganta Isku^(Merge) -dhafka .

Xulashooyinka soo socdaa waxay u dhaqmi doonaan sida lagu xusay:

1] Isku-darka iyo Xarunta^{(Merge and Center)} : Waxay isku dari doontaa unugyada xulashada waxayna keenaysaa qoraalka unugga koowaad tiirka dhexe iyo safka hoose ee ugu hooseeya.

2] Isku-darka guud^{(Merge across)} : Waxay isku dari doontaa unugyada xulashada waxayna keenaysaa qoraalka unugga koowaad tiirka dhexe iyo safka ugu sarreeya. Haddii ay dhacdo tirooyinka, nambarku wuxuu tagayaa dhinaca midigta.

3] Unugyada^{(Merge cells)} isku dar ah: Waxa ay isku milmayaan unugyadaas si unugga weyni uu u dhaqmo sidii unug keliya, qoraalkuna waxa uu aadayaa halka uu inta badan ku jiro unug caadi ah marka xogta la gelayo.

4] Unugyada^{(Unmerge cells)} kala soocida : Waxay kala saartaa unugyada la doortay.

Waxaan rajeyneynaa in tani ay ahayd mid waxtar leh!

How to Merge and Unmerge cells in Excel

Merging and unmerging cells in Excel is helpful while organizing lists when creating titles/subtitles, or removing them. There are different types of merging in Excel and we would be discussing thе type using the Merge/Unmerge tool here.

How to Merge and Unmerge cells in Excel

There are many ways of merging cells and columns in Excel. If you need to merge multiple cells without losing data, try merging cells in Excel using the Concatenate function.

The Merge and Unmerge tools delete data from any cell in the selection other than the top-left one. The primary use of this tool is to create a larger merged cell for writing titles and subtitles even before entering the actual data.

The option to Merge cells is at different positions across different Excel editors and different versions of MS Excel. Generally, you would find it on the homepage. As an example, we have considered an Excel online sheet in the example below.

The Merge and Center tool is present in the Alignment column in the Microsoft Excel online editor.

Let us assume, you need to merge the cells between selection C3, E3, E5, and C5.

Select the cells and click on the downward pointing arrow corresponding to Merge.

The following options will behave as mentioned:

1] Merge and Center: It will merge the cells in the selection and bring the text in the first cell to the center column and bottom-most row.

2] Merge across:  It will merge the cells in the selection and bring the text in the first cell to the center column and the top-most row. In case of numbers, the number goes to the right-hand side.

3] Merge cells: It will merge the cells such that the larger cell acts as a single cell and the text will go where it would usually in a normal cell upon entering data.

4] Unmerge cells: It unmerges the selected cells.

We hope this was helpful!

Related posts

• Badhanka isku-dhafka iyo badhanka ma shaqaynayo, maqan yahay, ka cawday gudaha Excel

• Sida Loogu Mideeyo Xogta Faylal Badan oo Excel ah

• Sida Loo Mideeyo Unugyada, Tiirarka & Safafka gudaha Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday