Maxaa dhacaya haddii aad rabto in aad xidhid unugyo xaashida shaqada ah laakiin aanad ku xidhin dhammaan xaashida shaqada? Gudaha Microsoft Excel , waxaad ka xiri kartaa unug gaar ah ama unugyo dadka isku dayaya inay wax ka beddelaan macluumaadka muhiimka ah ee ku jira ama iyaga.

Sideen uga dhigaa unug aan la tafatirin karin gudaha Excel ?

Si aad unuggaga uga dhigto mid aan la tafatirin karin gudaha Excel , waa inaad xirtaa unugga oo aad isticmaasho furaha sirta ah si aad u ilaaliso macluumaadka aad rabto in aan la tafatirin karin. Qufulka qolkaaga waxa kale oo ay ka ilaalin kartaa xogtaada in la tirtiro.

Sida loo xidho unugyada Excel

Si aad unugyada ugu xidho Microsoft Excel , raac hababka hoose.

1. Bilaw Microsoft Excel
2. Dooro unugyada aad rabto inaad xirto
3. Tabka Guriga^(Home) , ee kooxda toosinta^(Alignment) , guji falaarta yar ee midig ee hoose
4. Sanduuqa wada hadalka^(Format) unugyada qaabaynta ayaa furan; dhagsii ilaalinta^(Protection) tab
5. Hubi in sanduuqa qufulka la doortay
6. Kadib dhagsii OK
7. Dooro unugyada aad u oggolaan doonto isticmaaleyaasha inay wax ka beddelaan
8. Kooxda toosinta^(Alignment) , guji falaarta yar ee midig ee hoose, mar labaad
9. Qaabka unugyada sanduuqa wada hadalka, ka saar sanduuqa hubinta ee qufulka^(Format)
10. Guji OK
11. Guji tab dib u eegista
12. Kooxda Ilaali^(Protect) , dooro xaashida Ilaalinta^{(Protect Sheet)} oo mar kale codso ilaalinta

Bilaw Microsoft Excel .

Dooro unugyada aad rabto inaad xirto.

On the Home tab, In the alignment group, guji falaarta yar ee midig ee hoose ama midig-guji unugga la doortay oo guji Qaabka Unugyada^{(Format Cells)} .

Sanduuqa wada hadalka Unugyada Qaabka^{(Format Cells)} ayaa furan.

Sanduuqa wada hadalka, dhagsii ilaalinta^(Protection) tab.

Bogga Ilaalinta^{(Protection )} tab, hubi haddii sanduuqa hubinta la doortay.

Kadib dhagsii OK .

Hadda, dooro unugyada aad u oggolaan doonto isticmaaleyaasha inay wax ka beddelaan.

Kooxda toosinta^(Alignment) , guji falaarta yar ee midig ee hoose, mar labaad.

Sanduuqa wada hadalka Unugyada Qaabka^{(Format Cells)} , ka saar sanduuqa hubinta ee qufulka.

Kadib dhagsii OK .

Guji tab dib u eegista^(Review) ee ku taal bar menu-ka.

Kooxda Ilaali^(Protect) , dooro xaashida Ilaalinta^{(Protect Sheet)} oo mar kale codso ilaalinta.

Waxaad ogaan doontaa inaad wax ka beddeli karto qaybo ka mid ah xaashida shaqada, laakiin maaha dhammaanteed.

Haddii aad hayso su'aalo ku saabsan casharrada, noogu soo sheeg faallooyinka.

How to lock cells in Excel formula to protect them

What if you want to lock some cells on your wоrkshеet but not the entire worksheet? In Microsoft Excel, you can lock a specific cell or cells from people trying to edit essential information in it or them.

How do I make a cell non-editable in Excel?

To make your cell non-editable in Excel, you have to lock the cell and use a password to protect the information you want to be non-editable. Locking your cell also can prevent your data from being deleted.

How to lock cells in Excel

To lock cells in Microsoft Excel, follow the methods below.

1. Launch Microsoft Excel
2. Select the cells you want to lock
3. On the Home tab, in the Alignment group, click the bottom right small arrow
4. A Format cells dialog box is open; click the Protection tab
5. Check if the lock checkbox is selected
6. Then click OK
7. Select the cells that you will allow users to edit
8. In the Alignment group, click the bottom right small arrow, again
9. In the Format cells dialog box, uncheck the lock checkbox
10. Click OK.
11. Click the Review tab.
12. In the Protect group, select Protect Sheet and reapply protection

Launch Microsoft Excel.

Select the cells you want to lock.

On the Home tab, In the Alignment group, click the bottom right small arrow or right-click the selected cell and click Format Cells.

A Format Cells dialog box is open.

In the dialog box, click the Protection tab.

On the Protection tab page, check if the lock checkbox is selected.

Then click OK.

Now, select the cells that you will allow users to edit.

In the Alignment group, click the bottom right small arrow, again.

In the Format Cells dialog box, uncheck the lock checkbox.

Then click OK.

Click the Review tab on the menu bar.

In the Protect group, select Protect Sheet and reapply protection.

You will notice that you can edit some parts of the worksheet, but not all of it.

If you have questions about the tutorial, let us know in the comments.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

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

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo OR shaqada Excel si loo go'aamiyo haddii xaaladdu run tahay

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel

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

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

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

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