Ma ogtahay in aad u qaabayn karto qoraalka siyaabo badan hal unug gudaha Microsoft Excel ? Hagahan, waxaanu ku tusinaynaa sida aad ugu dari karto habayn badan qoraalkaaga hal unug oo Excel ah^{(add multiple formatting to your text in a single cell in Excel)} .

Habayntu waxay ka dhigtaa qoraalkeena mid muuqda. Waxaan ku calaamadin karnaa muhiimada ikhtiyaarada qaabaynta. Nasiib darrose, waxaan u maleyneynaa inaanan u qaabeyn karin qoraalka Excel sida aan ku sameyno processor-yada kale ee qoraalka. Xataa iskuma dayno inaan qaabaynno qoraalka maadaama inta badan xaashida Excel aysan u baahnayn habayn badan. Laakin, waxaa jiri kara kiisas gaar ah, halkaas oo aad ku samaynayso qaabaynta qoraalka badan hal unug si aad u muujiso ama hoosta uga xariiqdo ama u codsato qoraal hoosaadka ama qoraalka sare. Hagahan, waxaan ku haynaa xalal lagu dabaqi karo ikhtiyaarada qaabaynta ee kala duwan qoraalka Excel . Aan aragno sida aan u samayn karno.

Sida loogu daro Multiple Formating^{(Multiple Formatting)} qoraalkaaga hal^(Text) unug oo^(Cell) Excel ah^(Excel)

Si aad u bilowdo, fur Microsoft Excel oo ku qor qoraalka aad u baahan tahay si aad u codsato qaabab badan oo unug ah oo aad hagaajisid cabbirka unugga si qoraalku si fiican u muuqdo. Si aad qoraalka u geliso unugga oo aad u aragto dhammaan qoraalka halkaas, dooro unugga oo dhagsii qoraalka ku duub ^{(Wrap Text )} gudaha tabka guriga^(Home) ee liiska ribbon. Kadib,

1. Dooro qoraalka
2. Guji^(Click) falaarta hoos-u-dhaca ee qaybta farta^(Font)
3. Hagaaji Farta, Qaabka, iyo Cabirka
4. Hubi badhanka ku dheggan Saamaynta^(Effect) aad u baahan tahay
5. Guji OK si aad u codsato

Aynu galno faahfaahinta habka.

Ka dib marka la hagaajiyo cabbirka unugga oo aad qoraalka ku duubto, dooro qoraalka gaarka ah ee unugga, waxaad dooneysaa inaad isticmaasho qaabab kala duwan. Haddii aad rabto in aad ka dhigto mid geesinimo leh, ama faalig ah, ama aad hoosta ka xariiqdo, waxaad riixi kartaa badhamada heeganka ah ee ku yaal tabka Guriga . ^(Home)Haddii aad rabto in aad codsato Superscript , Subscript , ama Strikthrough^{(Strikethrough)} saamaynta qoraalka, dhagsii fallaadha hoos-u-u-jiidka ah ee geeska qaybta qaybta xarfaha ee tabka^(Font) Guriga .^(Home)

Waxa ay furi doontaa daaqada Format Cells mini overlay. Waxaad hagaajin kartaa farta^(Font) , qaabka xarfaha^{(Font Style)} , cabbirka^(Size) , iyo midabka^(Color) daaqada oo arag horudhaca halkaas. Si aad u codsato saamaynta ama qaabaynta qoraalka la doortay, calamee badhanka ag saamaynta aad rabto inaad ku dabaqdo qoraalka. Kadib markaad codsato saamaynta oo aad isbedel samayso, dhagsii OK si isbedelada loo dabaqo.

Waxaad ku celin kartaa tan dhowr jeer, adigoo dooranaya qoraallo kala duwan mar kasta si aad u isticmaasho habayn badan qoraalka.

Sideen ku dhejiyaa walxo badan hal unug oo Excel ah ?

Waxaa jira hab fudud oo lagu daro walxo badan hal unug gudaha Excel . Kaliya waa inaad riixdaa  Alt + Enter ka dib markaad geliso hal shay oo ku dar shayga labaad, oo ku celi ilaa aad ku darto wax kasta oo ku jira unugga.

Sideen u isticmaalaa midabo far badan ama xarfo hal unug oo Excel ah ?

Waxaad taas ku samayn kartaa adigoo isticmaalaya qaybta farta^(Font) ee ku taal tabka guriga^(Home) ee liiska ribbon. Waa inaad doorataa qoraalka gaarka ah oo aad isticmaasho badhanka go'an ee qaybta farta^(Font) si aad u isticmaasho saamaynta.

How to add Multiple Formatting to your Text in one Cell in Excel

Do you know that yоu can format text in multiple ways in a sіngle cell in Microѕoft Excel? In this guide, we show how you can add multiple formatting to your text in a single cell in Excel.

Formatting makes our text stand out. We can mark the important with the formatting options. Sadly, we think that we cannot format the text on Excel as we do on other text processors. We don’t even try to format the text as most of the Excel sheets don’t require much formatting. But, there might be special cases, where you have to do multiple text formatting in a single cell to highlight or underline or apply subscript or superscript. In this guide, we have solutions to apply different formatting options to text in Excel. Let’s see how we can do it.

How to add Multiple Formatting to your Text in one Cell in Excel

To get started, open Microsoft Excel and type the text you need to apply multiple formatting in a cell and adjust the sizes of the cell to make the text visible well. To put the text in the cell and see the whole text there, select the cell and click on Wrap Text in the Home tab on the ribbon menu. Then,

1. Select the text
2. Click on the drop-down arrow in the Font section
3. Adjust the Font, Style, and Size
4. Check the button beside the Effect you need
5. Click on OK to apply.

Let’s get into the details of the process.

After adjusting cell sizes and wrapping text in it, select the particular text in the cell, you want to apply different formatting effects. If you want to make it bold, or italic, or underline it, you can click on the dedicated buttons in the Home tab. If you want to apply Superscript, Subscript, or Strikethrough effects to the text, click on the drop-down arrow in the corner of the Font section in the Home tab.

It will open a Format Cells mini overlay window. You can adjust Font, Font Style, Size, and Color in the window and see the preview there. To apply effects or formatting to the selected text, check the button beside the effect you want to apply to the text. After applying the effects and making changes, click on OK for the changes to apply.

You can repeat this multiple times, selecting different text each time to apply multiple formatting to the text.

How do I put multiple items in one cell in Excel?

There is a simple way to add multiple items in one cell in Excel. You just have to press Alt + Enter after entering one item and add the second item, and repeat it until you add everything in the cell.

How do I use multiple font colors or fonts in one cell in Excel?

You can do this using the Font section in the Home tab of the ribbon menu. You have to select the particular text and use the dedicated button in the Font section to apply the effects.

Related posts

• Sida loo joojiyo ama loo qariyo qoraalka qulqulka ee Excel

• Sida loo beddelo qoraalka qoraalka (TXT/CSV) faylka Excel

• Sida loogu daro ama looga saaro Xudduudaha Unug ee Excel

• Sida loo daro Comma ka dib Erayga ugu horeeya ee unug kasta oo Excel ah

• U qaabee qoraalka sidii Superscript ama Subscript ahaan Word, Excel, PowerPoint

• U qaabeeya Unugyada iyadoo la isticmaalayo Habaynta Shuruudaha ah ee Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

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

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Ka dhex raadi faylal qoraal ah oo badan hal mar

• Sida Dhakhso Loo Geliyo Safaf Badan gudaha Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Ka dhex raadi qoraalka Gudaha Faylal badan oo PDF ah

• Ilaali Tixraaca Unugyada marka aad nuqul ka samaynayso foomamka gudaha Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Ka soo dir fariimaha qoraalka ah ee bilaashka ah taleefanka gacanta ee PC-gaaga

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel