Gudaha Microsoft Excel , xaashidaada shaqada, waxaad ku dari kartaa oo ka saari kartaa xuduudaha unuggaaga. Si aad xudduudahaagu u soo baxaan, waxaad dooran kartaa inaad ku darto qaababka, dhumucda, midabada, iyo sida aad rabto inaad u qaabayso xuduudahan. Tababarkan ayaa sharxi doona sida loogu daro ama looga saaro xuduudaha unugga xaashida shaqada ee Excel .

Sida loogu daro ama looga saaro Xudduudaha Unug^{(Cell Borders)} ee Excel

Gudaha Microsoft Excel , xuduuduhu waa xariiqyo ka sameysan agagaarka unugga. Gudaha Excel , waxaa jira xulashooyin lagu dari karo labadaba xudduudaha unugga ee horay loo sii qeexay iyo xudduudaha unugyada caadiga ah.

1] Sida^(How) loogu daro xuduudaha unugga xaashida shaqada ee Excel

Fur Microsoft Excel .

Guji unug ku yaal xaashida shaqada.

Bogga Hoyga^(Home) ee kooxda xarfaha^(Font) , waxaad arki doontaa summada soohdinta; guji, waxaad arki doontaa liiska xuduudaha la sii qeexay; dhagsii doorashada aad rabto, waxay si toos ah ugu muuqan doontaa unugga aad dooratay.

Waxaa jira laba ikhtiyaar oo kale oo lagu daro xuduudaha unugyadaada.

Ikhtiyaarka koowaad waa in aad gujiso Border Border^{(Draw Border)} ee liiska hoos-u-dhaca ee Xuduudaha.

Qalin ayaa u muuqan doona inuu ku sawirayo soohdinta ku wareegsan unugga.

Waxaad ku dari kartaa qaababka laynka iyo midabka liiska hoos-u-dhaca adiga oo gujinaya Qaababka Line^{(Line Styles)} iyo Midabka laynka^{(Line Color)} ee liiska.

Doorashada labaad waa inaad gujiso Font Settings^{(Font Settings)} , falaar yar oo ku taal xagga hoose ee kooxda xarfaha .

Sanduuqa wada hadalka Unugyada Qaabka ayaa soo bixi doona .^{(Format Cells)}

Guji tab xadka .^(Border)

Tabka Xudduudda ee^(Border) ku dhex jira sanduuqa wada-hadalka, waxaad arki doontaa doorashooyin kala duwan oo aad ku dari karto oo aad ku habaynayso xadka.

Waxaad ku dari kartaa Qaababka Lines^{(Line Styles)} , Presets , Midabada,^(Colors,) oo waxaad ku dari kartaa Khadadka Xuduudka^{(Border Lines)} adiga oo dooranaya xariiqyada xuduudaha ee ku wareegsan muraayadda horudhaca ama guji gudaha muraayadda horudhaca.

Marka aad ku darto waxa aad rabto, dhagsii OK; xuduud ayaa ka muuqan doonta unugga la doortay.

2] Sida^(How) looga saaro xuduudaha unugga xaashida shaqada ee Excel

Waxaa jira saddex doorasho oo aad ka saari karto xuduudaha unugga xaashidaada shaqo.

Guji unugga ay xuduuddu ku taal.

Tabka guriga^(Home) ee kooxda xarfaha^(Font) , dhagsii astaanta xuduudka; Liiskeeda hoos-u-dhaca, dhagsii Xuduud^{(No Border)} No. Xadku wuu baaba'ayaa.

Ikhtiyaarka labaad waa in la xusho Xudduudaha Tirtir^{( Erase Border)} ee liiska hoos-u-dhaca ee xuduudaha.

Tirtir^(Eraser) ayaa soo bixi doona; dhagsii xariiqyada xudduudaha unuggu si aad xudduudaha unugu meesha uga baxdo.

Doorashada saddexaad^{(Option three)} waa inaad gujiso unugga meesha aad xuduudka leedahay

Tabka guriga^(Home) ee kooxda xarfaha , dhagsii Font Settings^{(Font Settings)} , falaar yar oo hoose.

Qaabka sanduuqa wada hadalka Cell ayaa soo bixi doona.^{(Format Cell)}

Guji tab xadka .^(Border)

On the Border tab, dhagsii xariiqyada horudhaca eegida si aad meesha uga saarto xuduudaha ama dhagsii khadadka horudhaca si aad meesha uga saarto xuduudaha unugga.

Guji OK _

Soohdinta ku wareegsan unugga waa la saaray.

Akhri soo socda^{(Read next)} : Sida loo sameeyo Hyperlink faylka jira ee Excel^{(How to create a Hyperlink for an existing file in Excel)} .

How to add or remove Cell Borders in Excel

In Microsoft Excel, on your worksheet, you can add and remove borders from your cell. To make your borders stand out, you can choose to add styles, thickness, colors, and how you want to layout these borders. This tutorial will explain how to add or remove borders to a cell in an Excel worksheet.

How to add or remove Cell Borders in Excel

In Microsoft Excel, borders are lines that form around a cell. In Excel, there are options to add both predefined cell borders and custom cell borders.

1] How to add borders to a cell in an Excel worksheet

Open Microsoft Excel.

Click on a cell in the worksheet.

On the Home tab in the Font group, you will see a border icon; click on it, you will see a list of predefined borders; click any choice you desire, it will automatically appear into the cell you selected.

There are two other options to add borders to your cells.

Option one is to click Draw Border in the Borders drop-down list.

A pencil will appear to draw the border around the cell.

You can add line styles and color in the drop-down list by clicking Line Styles and Line Color from the list.

Option two is to click Font Settings, a small arrow on the bottom in the Font group.

A Format Cells dialog box will appear.

Click the Border tab.

On the Border tab inside the dialog box, you will see various options to add and customize the border.

You can add Line Styles, Presets, Colors, and add Border Lines by selecting the border lines around the preview pane or click inside the preview pane.

Once you add what you want, click OK; a border will appear in the cell selected.

2] How to remove borders from a cell in an Excel worksheet

There are three options to remove borders from a cell in your worksheet.

Click the cell where the border is.

On the Home tab in the Font group, click the border icon; in its drop-down list, click No Border. The border will disappear.

Option two is to select Erase Border in the borders drop-down list.

An Eraser will appear; click on the cell borders’ lines to make the cell borders disappear.

Option three is to click the cell where you have the border

On the Home tab in the Font group, click Font Settings, a small arrow on the bottom.

A Format Cell dialog box will appear.

Click the Border tab.

On the Border tab, click the border preview lines to remove the borders or click the preview lines to remove the cell’s borders.

Click OK.

The border around the cell is removed.

Read next: How to create a Hyperlink for an existing file in Excel.

Related posts

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

• Sida loogu daro Multiple Formating qoraalkaaga hal unug oo Excel ah

• Sida loogu daro faallooyinka unugga Xaashida shaqada ee Excel

• 3 Siyood Oo Unugyada Excel Loogu Kala Qaybiyo

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

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

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

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida waqti loogu daro ama loogu daro Microsoft Excel

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

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

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

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel