Badhanka barta aaladaha ka gudba tiirarka ka^{(Center Across Columns)} gudba ma aha mid ka muuqda Microsoft Excel . Waxaa bedelay Isku-dhafka iyo Xarunta^{(Merge and Center)} oo bixisa isla shaqeyn. Sida magacu soo jeediyo, waxa ay u ogolaataa isticmaalayaasha xogta ku jirta hal unug ama unugyo kala duwan laakiin mararka qaarkood waxa laga yaabaa in badhanka uu ku guuldareysto inuu ka soo muuqdo liiska ribbon hoostiisa. Waa kuwan waxa aad u baahan tahay inaad sameyso si aad u dhexdhexaadiso qoraallada marka badhanka Isku-dhafka iyo Xarunta^{(Merge and Center)} uusan ka soo bixin aaladda Excel^(Excel) .

Isku darka iyo badhanka ayaa maqan

Waxaa jira laba fursadood marka badhanka Isku^(Merge) -dhafka iyo Xarunta^(Center) maqan yahay, cawlan ama aan ka shaqayn Excel . Marka hore^(First) , xaashida shaqada waa la ilaaliyaa. Labaad^(Second) , Buuga Shaqada^(Workbook) waa la wadaagaa. Markaa, haddii aad dami wadaagga marka ay daaran tahay, badhanka waa inuu mar kale diyaar ahaadaa. Haddii ay tani shaqayn waydo, isku day xalinta soo socota!

1. Dooro unugyadu in ay xuddun u noqdaan.
2. Midig ku dhufo oo dooro Qaabka Unugyada^{(Format Cells)} ikhtiyaarka ah.
3. Dooro tab toosinta^(Alignment)
4. Guji falaarta hoos-u-dhaca ee ku dheggan ciwaanka Horizontal .
5. Dooro Xarunta Dhan Xulashada^{( Center Across Selection)} .
6. Ku dhufo badhanka OK

Hawsha sare waxay u ogolaan doontaa isticmaalayaasha xogta ku jirta hal unug oo ka kooban unugyo kala duwan.

Fur faylka Excel ee aad rabto inaad wax ka beddesho.

Marka xigta, dooro tirada unugyada aad jeceshahay inaad qoraalka dhexda uga dhigto.

Midig ku dhufo^{(Right-click)} unugyada la doortay, ka dibna ka dooro Qaabka Unugyada^{(Format Cells)} liiska xulashooyinka la soo bandhigay.

Akhri^(Read) : Habbee Toolbarka Helitaanka Degdegga ah ee Excel si uu kuugu shaqeeyo .

Marka uu furmo daaqada Qaabka Unugyada , u ^{(Format Cells)}gudub^(Alignment) tabka toosinta.

Guji tab toosinta^(Alignment)

Hoosta qaybta toosinta qoraalka^{(Text alignment)} , aad cinwaanka Horizontal.

Guji fallaadha hoos-u-dhaca oo dooro xulashada xulashada Xarunta Dhexe^{(Center Across Selection)} .

Marka la sameeyo, dhagsii badhanka OK .

Waxaad ogaan doontaa in qoraalada ku jira hal unug ama unugyo kala duwan ay udub dhexaad u noqonayaan, isla markaaba.

That’s all there is to it!

Merge and Center button is not working, missing, greyed out in Excel

The Center Across Columns toolbar button is no longer visible in Microsoft Excel. It has been replaced by Merge and Center that offers the same functionality. As the name suggests, it lets users center information contained in a single cell or across a range of cells but sometimes the button may fail to appear under the ribbon menu. Here’s what you should do to center texts when the Merge and Center button doesn’t appear on the Excel toolbar.

Merge and Center button is missing

There are two possibilities when the Merge and Center button is missing, greyed out or not working in Excel. First, your worksheet is protected. Second, the Workbook is shared. So, if you turn off sharing when it is enabled, the button should once again be available. If this doesn’t work, try the following workaround!

1. Select cells to be centered.
2. Right-click and choose the Format Cells option.
3. Select the Alignment tab.
4. Click the drop-down arrow adjacent to the Horizontal heading.
5. Choose Center Across Selection.
6. Hit the OK button.

The above workaround will let users center information contained in a single cell across a range of cells.

Open the Excel file you would like to edit.

Next, select the range of cells over which you would like to center text.

Right-click the selected cells, and then choose Format Cells from the list of options displayed.

Read: Customize the Quick Access Toolbar in Excel to make it work for you.

When the Format Cells window opens, switch to the Alignment tab.

Click the Alignment tab.

Under the Text alignment section, go to Horizontal heading.

Click the drop-down arrow and choose the Center Across Selection option.

When done, click the OK button.

You’ll notice that the texts contained in a single cell or a range of cells will be centered, instantly.

That’s all there is to it!

Related posts

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Xarunta Xogta Xaashida Shaqada ee Excel si loo daabaco

• 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 COOSE ee Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel