Isticmaalka qaacidada ee Excel waxay ka dhigi kartaa hawl maalmeedkaaga mid sahlan. Excel waxay leedahay qaacidooyin loogu talagalay ku dhawaad ​​dhammaan hawlgallada. Markaad taas dhahdo, haddii aad rabto inaad qariso qaacidooyinka haddii aad la wadaagto xaashidaada Excel asxaabtaada ama madaxa waad sameyn kartaa sidaas. Dhammaan hababka iyo shaqada xisaabinta waa laga qarin karaa daawadayaasha haddii aad ku qariso qaacidooyinkaaga xaashida Excel . Sidee u qabtaa? Aan aragno!

Sida loo qariyo Formula gudaha Excel

Qaababka waxa lagu soo bandhigay barta qaacidada sida ka muuqata sawirka hoose. Haddii kale, si aad u muujiso qaacidada, waxaad riixi kartaa 'Show Formulas ' ee qaybta Hanti-dhawrka Formula^{(Formula Auditing)} ee tab Formulas .

Haddi aanad doonayn in qaaciidooyinka ay u muuqdaan isticmaalayaasha fiirsada xaashidaada, waad qarin kartaa oo aad ilaalin kartaa xaashida. Si tan loo sameeyo, dooro unugyada aad rabto inaad qariso qaababkooda.

Marka xigta, u gudub tab 'Home'. Ka raadi qaybta Unugyada^(Cells) dhanka Midigta^(Right) . Qaybtan, dooro Qaabka^(Format) oo ka dooro Qaabka Unugyada^{(Format Cells)} liiska hoos-u-hoosaadka ah.

Isla markiiba, sanduuqa wada hadalka Unugyada Qaabka^{(Format Cells)} waa inuu ka soo baxaa shaashadda kombiyuutarkaaga. Marka tani dhacdo, u beddel tab 'Ilaalinta'. Halkaa, dooro sanduuqa calaamadaynta qarsoon^(Hidden) oo ku dhufo 'OK'.

Talaabada u danbeysa waa in aad ilaaliso xaashida shaqada ee Excel^{(Excel Worksheet)} si aad u dhamaystirto qarinta hababka. Guji qaabka^{(Click Format)} qaybta Unugyada^(Cells) ee tabka Guriga mar labaad. ^(Home)Hadda, ka dooro Ilaalinta Sheet^{(Protect Sheet)} ka menu-hoos u dhaca.

Marka lagu soo bandhigo sanduuqa wada hadalka, hubi waxa ku jira unugyada xidhan iyo sanduuqa calaamadaynta xaashida shaqada ee Ilaalinta^(Protect) in la doortay. Waxaa lagaa doonayaa inaad geliso furaha sirta ah goobta sirta^(Password) ah.

Geli eraygaaga sirta ah mar kale gudaha Gelida^(Reenter) erayga sirta ah si aad u sii wado wax ka beddelka sanduuqa xaqiijiso erayga sirta^{(Confirm Password)} ah oo guji OK.

Marxalad kasta, haddii aad dareento inaadan ilaalin xaashida oo aad tusto qaacidooyinka mar kale, dooro xaashida aan la ilaalin^(Unprotect) oo geli erayga sirta ah ee badbaadsan sanduuqa sirta ah ee Sheet^{(Unprotect Sheet)} -ka.

Gudaha Oggol^(Allow) dhammaan isticmaalayaasha xaashidan shaqada inay liis gareeyaan sanduuqa, dooro sanduuqyada calaamadaynta hawlaha aad rabto inaad u ogolaato isticmaalayaashu inay qabtaan. Guji OK^{(Click OK)}

Hadda arag sida aad uga faa'iidaysato isticmaalka ugu wanaagsan ee sanduuqa Magaca ee Excel .^{(Now see how you van make the best use of Name Box in Excel.)}

How to hide Formula in Microsoft Excel sheets

Using the formula in Excel can make уour day-to-day tasks easier. Excel has formulas for almost all the operations. Having said that, if you want to hіde formulаe if уou are sharіng your Excel spreadsheet with your colleagues or bоss you can do ѕo.  All the formulas and the calculation work can be hidden from the viewers if you hide your formulas in an Excel ѕheet. How do you do it? Let’s see!

How to hide Formula in Excel

The formulas are displayed in the formula bar as shown in the screenshot below. Alternatively, to display the formula, you can click ‘Show Formulas’ in the Formula Auditing section of the Formulas tab.

If you don’t want the formulas visible to users viewing your spreadsheet, you can hide them and protect the sheet. To do this, select the cells whose formulas you want to hide.

Next, move to ‘Home’ tab. Look for the Cells section to the Right. From this section, choose Format and select Format Cells from the drop-down menu.

Instantly, the Format Cells dialog box should pop up on your computer screen. When this happens, switch to ‘Protection’ tab. There, select the Hidden check box and Hit ‘OK’.

The final step is to protect your Excel Worksheet to finish hiding the formulas. Click Format in the Cells section of the Home tab again. Now, select Protect Sheet from the drop-down menu.

When presented with the dialog box, make sure the contents of locked cells and the Protect worksheet check box is selected. You will be required to enter a password in the Password field.

Enter your password again in the Reenter password to proceed edit box on the Confirm Password dialog box and click OK.

At any stage, should you feel to unprotect the sheet and show the formulas again, select Unprotect sheet option and enter the saved password in Unprotect Sheet password box.

In the Allow all users of this worksheet to list box, select the check boxes for the tasks you want to allow the users to perform. Click OK.

Now see how you van make the best use of Name Box in Excel.

Related posts

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sideen u hagaajin karaa Runtime Error 1004 gudaha Microsoft Excel?

• Sidee Loo Xidhaa Ama Loo Furaa Unugyada Excel? (2022)

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

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

• Sida loo sameeyo sanduuqa sanduuqa Microsoft Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida Loo Abuuro Oo Loo Badbaadiyo Xaashiyaha Faafinta Excel ee Microsoft Office ee Android

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Hagaaji qaladka Excel stdole32.tlb gudaha Windows 10

• Hagaaji Soo Celinta Xogta. Sug dhowr ilbiriqsi oo isku day inaad mar kale gooyso ama nuqul ka sameyso qaladka Excel

• Casharrada Aasaasiga ah ee Microsoft Excel - Barashada Sida loo Isticmaalo Excel

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

• Fix Excel wuxuu sugayaa codsi kale si loo dhamaystiro ficil OLE

• Sida loo rakibo oo loo isticmaalo add-ins gudaha Microsoft Word iyo Excel ee iPadka

• Microsoft Excel waxay fureysaa xaashi maran halkii faylka