Khadadka Grid ee ku jira Microsoft Excel ayaa fududeynaya in la eego xogtaada. Si kastaba ha ahaatee, waad joojin kartaa khadadkan haddii aadan rabin inaad isticmaasho markaad samaynayso xaashida xaashida^{(making spreadsheets)} . Waxaa jira siyaabo badan oo meesha looga saari karo gridlines gudaha Excel .

Waad qarin kartaa, ka buuxin kartaa caddaan si aad uga dhigto inay ku baaba'aan bogga, ama waxaad samayn kartaa qaab-dhismeed aan isticmaalin khadadka.

Si degdeg ah uga saar Gridlines gudaha Excel^{(Quickly Remove Gridlines in Excel)}

Microsoft Excel waxay haysataa ikhtiyaar qeexaya in khadadka khadka ahi ay ku jiraan xaashiyahaaga faafinta iyo in kale. Waxaad joojin kartaa doorashadan si aad ugu qariso khadadka xaashida Excel .

Habkani wuxuu ku shaqeeyaa saldhig kasta, taas oo macnaheedu yahay inaad u fuliso tillaabooyinkan xaashi kasta oo shaqada si aad meesha uga saarto khadadka.

1. Ku fur xaashidaada Microsoft Excel kombayutarka^{(Microsoft Excel)} Windows ama Mac .
2. Dooro xaashida shaqada ee aad rabto in aad ka saarto xadhkaha hoose ee xaashida.
3. Dooro bogga Layout^{(Page Layout)} -ka ee ku yaal xagga sare ee interface -ka Excel .

1. Ha dooran sanduuqa Muuqaalka ee qaybta ^(View)Gridlines .

Isla markiiba, Excel waxay ku qarin doontaa^{(Excel will hide)} dhammaan khadadka xaashida shaqada ee hadda. Haddii aad jeclaan lahayd inaad soo celiso khadadka khadka, awood u geli sanduuqa View ee qaybta ^(View)Gridlines .

U beddelo midabka Gridline si aad uga saarto Gridlines gudaha Excel^{(Change the Gridline Color to Remove Gridlines in Excel)}

Siyaabo kale oo looga saaro xargaha xargaha xaashida shaqada ee Excel waa iyada oo la beddelo midabka grid-yada. Sida caadiga ah, Excel waxay u isticmaashaa midabka cawl khadadka. Haddii aad tan u beddesho caddaan, khadadkaagu si toos ah ayay u baabi'i doonaan.

Mar labaad, doorashadani waxay ku shaqaysaa ku salaysan warqad-shaqaale, taas oo macnaheedu yahay waa inaad raacdo tillaabooyinkan mid kasta oo ka mid ah warqadahaaga shaqo si aad meesha uga saarto khadadka.

1. Ku billow xaashida faafintaada Microsoft Excel .
2. Dooro xaashida shaqada ee aad rabto in aad ka saarto khadadka.
3. Dooro Faylka^(File) dhinaca bidix ee sare ee Excel ka dibna dooro Wax badan^(More) > Xulasho^(Options) dhanka bidixda ah.

1. Ka dooro Advanced ka dhanka bidix ee daaqada Excel Options .
2. Hoos ugu dhaadhac shayga saxda ah ee xulashada Bandhigga ee qaybta xaashida shaqada^{(Display options for this worksheet)} . Halkan, dooro midabka Gridline^{(Gridline color)} .

1. Dooro Cadaan^(White) liiska midabka.

1. Ka dooro OK dhanka hoose ee daaqada.

Dhammaan khadadka khadka waa in hadda lagu qariyaa xaashida shaqada ee hadda.

Codso Midabka Buuxi si aad uga saarto Gridlines gudaha Excel^{(Apply a Fill Color to Remove Gridlines in Excel)}

Waxaad buuxin kartaa midabka cad ee xaashidaada shaqada si aad uga dhigto xariiqyada khadka baaba'a. Ka dib^(Later) , haddii aad bedesho maskaxdaada, waxaad ka saari kartaa midabka buuxinta si aad dib ugu soo celiso khadadka.

1. Fur xaashida shaqada ee aad rabto inaad ka saarto khadadka.
2. Dooro unugyada aad rabto in aad ka saarto khadadka. Si aad uga saarto xadhkaha xadhkaha goosashada ee xaashidaada oo dhan, taabo Ctrl + A (Windows) ama Command + A ( Mac ) si aad u doorato xaashida shaqada oo dhan.

1. Dooro tabka Guriga^(Home) ee ku yaal xagga sare ee interface -ka Excel .
2. Dooro calaamada fallaadha hoose ee ku ag taal astaanta baaldiga oo dooro midabka cad .^(White)

1. Khadadka xariijimaha waa in hadda laga saaraa xaashida shaqada.

Si aad u soo celiso khadadka birta ah, ka dooro Maya Buuxi^{(No Fill)} liiska summada baaldiga.

Ka saar Gridlines Safafka gaarka ah ama Tiirarka Excel^{(Remove Gridlines From Specific Rows or Columns in Excel)}

Haddii aad raadinayso inaad ka saarto khadadka safafka gaarka ah ama tiirarka^{(specific rows or columns)} , isticmaal ikhtiyaarka xudduudaha^(Border) Excel . Doorashadani waxay kuu ogolaanaysaa inaad ka saarto khadadka xadhkaha goostay aagga la doortay ee xaashidaada.

1. Fur xaashida shaqada ee aad rabto inaad ku qariso khadadka.
2. Dooro safka ama tiirka aad rabto in aad ka saarto khadadka.
3. Midig ku dhufo^{(Right-click)} tiirka ama safka la doortay oo ka dooro Qaabka Unugyada^{(Format Cells)} liiska.

1. Dooro tab xuduudaha^(Borders) ee daaqada Qaababka Unugyada . ^{(Format Cells)}Kadib, dooro ikhtiyaarka Midabka oo dooro midabka ^(Color)cad^(White) .
2. Dooro Outline ka dibna gudaha^(Inside) qaybta Presets . Kadib, dooro OK xagga hoose.

Dib ugu noqo shaashadda xaashida shaqada, waxa aad ka heli doontaa khadadka aagga aad dooratay oo hadda maqan.

Had iyo jeer ka ilaali Gridlines Excel^{(Always Keep Gridlines Removed in Excel)}

Haddii aad rabto inaad samayso xaashiyaha mustaqbalkaaga oo aan lahayn khadadka, samee template Excel^{(an Excel template)} kaas oo aan isticmaalin khadadka si toos ah. Kadibna, xaashi kasta oo aad ku salaysay qaab-dhismeedkan ma yeelan doonaan khadadka xad-dhaafka ah.

Si aad u samayso template:

1. Fur Excel oo dooro Buug-shaqeedka Banaan^{(Blank workbook)} si aad u abuurto buug-shaqo cusub.

1. Shaashadda tafatirka, dooro tabka Layout Page ee xagga sare.^{(Page Layout)}
2. Ha doorin aragtida^(View) ikhtiyaarka ee qaybta Gridlines . Tani waxay curyaami doontaa khadadka shabakadaha xaashida shaqada ee hadda.

1. U keydi buuggaaga shaqada qaab qaab Excelle^(Excel) ah adiga oo dooranaya File > Keyd sida^{(Save As)} .
2. Ka dooro Template^{(Excel Template)} Excel ka menu -ka hoos u dhaca ee Buug -hawleedka.^{(Excel Workbook)}
3. Geli magac qaabkaaga (wax sida Gridline Free ) oo dooro Keydi^(Save) .

1. Si aad u isticmaasho template-ka si aad u samayso xaashida faafinta, fur Excel , dooro Cusub^(New) > Personal , oo liiska ku dhex dooro template-kaaga. Tani waxay abuuri doontaa buug-hawleed aan lahayn khadadka.

Ku daabac Gridlines gudaha Excel^{(Print Gridlines in Excel)}

Sida caadiga ah, gridlines lama daabicin markaad daabacdo xaashida Excel^{(print an Excel spreadsheet)} . Haddii aad jeclaan lahayd inaad daabacdo khadadka, awood u yeelo ikhtiyaarka abka Excel .

1. Ku billow xaashida faafintaada Microsoft Excel .
2. Dooro bogga Layout^{(Page Layout)} -ka ee ku yaal xagga sare ee interface -ka Excel .
3. Daar^(Gridlines) doorashada Daabacaada^(Print) ee qaybta Gridlines .

1. Riix Ctrl + P (Windows) ama Command + P ( Mac ) si aad u furto shaashadda daabacan. Waxaad arki doontaa muuqaalka hore ee daabacadu wuxuu muujinayaa khadadka, taas oo macnaheedu yahay xadhkahaaga la daabici doono marka aad daabacdo xaashida xaashida.

1. Si aad u joojiso khadadka daabacaadda, dami ikhtiyaarka Daabacaadda ee qaybta ^(Print)Gridlines .

Ka takhalusida Gridlines ee xaashida faafinta ee Excel^{(Getting Rid of Gridlines From Excel Spreadsheets)}

Iyadoo khadadka khadka dhexe ay ka dhigayaan habaynta xogta xaashiyahaaga Excel^(Excel) mid sahlan, had iyo jeer maaha inaad isticmaasho. Munaasabadaha marka aadan u baahnayn khadadka xargaha, hababka kor ku xusan waa inay kaa caawiyaan inaad ka saarto xargaha xaashida Excel .

How to Remove Gridlines in Excel

Gridlines in Microsoft Excel make іt easier to view your data. However, you can disable these gridlіnes if you don’t want to use them while making spreadsheets. There are multiple ways to remove gridlines in Excel.

You can hide them, fill them with white to make them disappear into the page, or create a template that uses no gridlines.

Quickly Remove Gridlines in Excel

Microsoft Excel has an option that defines whether or not gridlines appear in your spreadsheets. You can disable this option to hide gridlines in your Excel spreadsheets.

This method works on a per-worksheet basis, which means you’ll have to perform these steps for each worksheet to remove gridlines.

1. Open your spreadsheet with Microsoft Excel on your Windows or Mac computer.
2. Select the worksheet you want to remove gridlines from at the bottom of the spreadsheet.
3. Select the Page Layout tab at the top of the Excel interface.

1. Deselect the View box in the Gridlines section.

Immediately, Excel will hide all gridlines in your current worksheet. If you’d like to bring gridlines back, enable the View box in the Gridlines section.

Change the Gridline Color to Remove Gridlines in Excel

Another way to remove gridlines from an Excel worksheet is by changing the gridlines’ color. By default, Excel uses the grey color for gridlines. If you change this to white, your gridlines will automatically disappear.

Again, this option works on a per-worksheet basis, which means you’ll have to follow these steps for each of your worksheets to remove gridlines.

1. Launch your spreadsheet with Microsoft Excel.
2. Select the worksheet you want to remove gridlines from.
3. Select File at the top-left corner of Excel and then choose More > Options from the left sidebar.

1. Choose Advanced from the left sidebar on the Excel Options window.
2. Scroll down the right pane to the Display options for this worksheet section. Here, select the Gridline color option.

1. Choose White in the color list.

1. Select OK at the bottom of the window.

All gridlines should now be hidden in your current worksheet.

Apply a Fill Color to Remove Gridlines in Excel

You can fill the white color in your worksheet to make gridlines disappear. Later, if you change your mind, you can remove the fill color to get gridlines back.

1. Open the worksheet you want to remove gridlines from.
2. Select the cells you want to remove gridlines from. To remove gridlines from your entire worksheet, press Ctrl + A (Windows) or Command + A (Mac) to select your entire worksheet.

1. Select the Home tab at the top of the Excel interface.
2. Select the small down-arrow icon next to the bucket icon and choose the White color.

1. Gridlines should now be removed from your worksheet.

To bring gridlines back, choose No Fill from the bucket icon menu.

Remove Gridlines From Specific Rows or Columns in Excel

If you’re looking to remove gridlines from specific rows or columns, use Excel’s Border option. This option allows you to remove gridlines from the selected area in your spreadsheet.

1. Open the worksheet you want to hide gridlines in.
2. Select the row or the column you want to remove gridlines from.
3. Right-click the selected column or row and choose Format Cells from the menu.

1. Select the Borders tab on the Format Cells window. Then, select the Color option and choose the White color.
2. Choose Outline and then Inside in the Presets section. Then, select OK at the bottom.

Back on the worksheet screen, you’ll find gridlines from your selected area are now gone.

Always Keep Gridlines Removed in Excel

If you want to make your future spreadsheets without gridlines, create an Excel template that uses no gridlines by default. Then, any spreadsheets that you base on this template will have no gridlines.

To make this template:

1. Open Excel and select Blank workbook to create a new workbook.

1. On the editing screen, select the Page Layout tab at the top.
2. Deselect the View option in the Gridlines section. This’ll disable gridlines in your current worksheet.

1. Save your workbook as an Excel template by selecting File > Save As.
2. Choose Excel Template from the Excel Workbook dropdown menu.
3. Enter a name for your template (something like Gridline Free) and select Save.

1. To use this template to make spreadsheets, open Excel, select New > Personal, and select your template in the list. This will create a workbook without gridlines.

Print Gridlines in Excel

By default, gridlines aren’t printed when you print an Excel spreadsheet. If you’d like to print gridlines, enable an option in the Excel app.

1. Launch your spreadsheet with Microsoft Excel.
2. Select the Page Layout tab at the top of the Excel interface.
3. Enable the Print option in the Gridlines section.

1. Press Ctrl + P (Windows) or Command + P (Mac) to open the print screen. You’ll notice the print preview shows gridlines, which means your gridlines will be printed when you print your spreadsheet.

1. To disable printing gridlines, turn off the Print option in the Gridlines section.

Getting Rid of Gridlines From Excel Spreadsheets

While gridlines make arranging data in your Excel spreadsheets easier, you don’t always have to use them. For the occasions when you don’t need gridlines, the methods above should help you remove gridlines from your Excel spreadsheets.

Related posts

• 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 isticmaalo Excel's What-If Analysis

• Sida Loo Hagaajiyo Safka gudaha Excel

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

• Sida loo raad raaco Ku-tiirsanaanta gudaha Excel

• Sida Loo Dhaqaajiyo Columns gudaha Excel

• Sida Loo Abuuro VBA Macro Ama Script gudaha Excel

• Sida Loo Raadiyo Excel

• 2 siyaabood oo loo Isticmaalo Shaqada Transpose ee Excel

• Sida loo xisaabiyo Z-Score gudaha Excel

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

• Sida Looga Saaro Safka Kooban Ee Excel

• Sida Loo Sameeyo Liisaska Hoos-u-dhaca ee Isku Xirka Badan ee Excel

• Sida Taariikh ahaan loogu kala saaro Excel

• Adeegsiga Qalab Raadinta Hadafka ee Excel Maxaa-Haddii Falanqaynta

• Sida loo isticmaalo Flash Fill ee Excel

• Sida loo Isticmaalo If iyo Nsted Haddii Odhaahyada Excel

• Farqiga u dhexeeya Microsoft Excel Online iyo Excel ee Desktop