Haddii aad si xamaasad leh u abuurtay xaashida Excel , waxaa laga yaabaa inaad rabto inaad dadka kale ka joojiso inay isbedel sameeyaan. Waxa aad tan ku samayn kartaa adigoo baranaya sida loo xidho unugyada xaashida Microsoft Excel .

Tababarkan, waxaan sidoo kale ku tusi doonaa sida loo ilaaliyo xaashiyaha iyo dhammaan buugaagta shaqada ee Excel si looga joojiyo dadka inay isbedel ku sameeyaan dukumeentiga oo dhan, oo ka soo horjeeda dhowr unug. Tan waxaa la socda, waxaan sidoo kale dabooli doonaa sida loo ilaaliyo ilaalinta xaashiyaha Excel .

Sida loo ilaaliyo xaashida ^(Sheet)Excel si looga hortago tafatirka

Waxaad isticmaali kartaa sifada xaashida shaqada si aad dadka uga joojiso inay beddelaan xaashida Excel . Si tan loo sameeyo, fur buug kasta oo Excel ah oo dooro tabka dib u eegista ee ka sarreeya liiska ^(Review)Ribbon . Tabaha dib u eegista^(Review) waxay ku yaalaan inta u dhaxaysa Data iyo View tabs.

Si aad u ilaaliso hal xaashi oo Excel ah , dhagsii xaashida Ilaalinta^{(Protect Sheet)} , oo ku taal qaybta Ilaalinta^(Protect) ee liiska Ribbon . Waxaad hadda u dajin kartaa furaha sirta^{(set a password)} ah xaashida.

Liiska soo-booda ee xaashida Ilaalinta^{(Protect Sheet)} wuxuu u oggolaanayaa in la xakameeyo astaamaha Excel ee loo isticmaali karo xaashida. Waxaad ka saari kartaa astaamaha aad rabto inaad xannibto. Si aad dadka uga joojiso in ay isbeddel ku sameeyaan unugyada xaashida Excel , hubi in aad calaamadda ka saartid ikhtiyaarka unugyada Qaabka .^(Format)

Xulashada Walxaha Tafatirka^{(Edit Objects)} waxay mudan tahay xus gaar ah halkan. Haddii aad gabto, dadku waxay wali awood u yeelan doonaan inay socodsiiyaan macros ku dhex jira faylkaaga Excel , laakiin ma tirtiri karaan. Guji OK^{(Click OK)} marka aad dhammayso

Tani waxay ilaalin doontaa xaashida xaashida ee Excel ee aad ku shaqaynayso, laakiin haddii aad haysato dukumeenti xaashiyo badan leh, waa inaad isticmaashaa ikhtiyaar kale si aad uga hortagto dhammaan noocyada tafatirka.

Si aad uga joojiso dadka inay ku daraan, guuraan, ama tirtiraan xaashida ku jira buugaaga shaqada ee Excel , tag tabka dib u eegista^(Review) oo dhagsii Ilaalinta Buuga Shaqada^{(Protect Workbook)} . Waxaad arki doontaa soo-bax ciwaankiisu yahay Ilaalinta Qaab^{(Protect Structure)} -dhismeedka iyo Daaqadaha^(Windows) . Ku dar furaha sirta ah si aad dadka uga joojiso inay si sahal ah isbedel u sameeyaan, oo dooro OK marka aad dhammayso.

Ku quful unugyo gaar^{(Lock Specific Cells)} ah xaashida Excel

Si aad unugyo gaar ah ugu xidho xaashida ^(Windows)Excel , fur xaashida faafinta oo taabo Ctrl+A Windows ama Command+A ee Mac si aad u doorato dhammaan unugyada. Markaas, taabo Ctrl+1 on Windows ama Command+1 on Mac si aad u furto Format Cells daaqada. Waxa kale oo aad furi kartaa pop-up-kan adiga oo riixaya Ctrl+Shift+F Windows ama adiga oo isticmaalaya Command ^(Windows)Command+Shift+Fkiiboodhka^{(keyboard shortcut)} Mac.

Haddii ay dhibaato kaa haysato kiiboodhkaga, dooro tabka Guriga ee ka sarreeya menu-ka ^(Home)Ribbon oo taabo calaamadda fallaadha ee ku taal geeska hoose-midig ee qaybta xarfaha^(Font) . Waxa kale oo aad midig-guji kartaa unug kasta oo aad doorato Qaabka Unugyada^{(Format Cells)} .

Dooro^(Select) tabka Ilaalinta, ka saar sanduuqa calaamadaynta ee ^(Protection)quful^(Locked) , oo dooro OK.

Hadda waa inaad heshaa oo doorataa unugyada ama tirada unugyada aad rabto inaad xidho. Marka aad taas sameyso, mar kale taabo Ctrl+1 , oo aad tab ilaalinta . ^(Protection)Calaamadee sanduuqa la quful^(Locked) oo guji OK. Tani waxay xiri doontaa unugyo gaar ah oo ku jira Microsoft Excel , laakiin waxaa jira hal tallaabo oo dheeraad ah ka hor intaadan joojin kuwa kale inay tafatiraan unugyadan.

Guji^(Click) tab dib u eegista^(Review) oo dooro ikhtiyaarka xaashida Ilaalinta^{(Protect Sheet)} . Ku dar furaha sirta ah halkan, oo dhex mara liiska xulashooyinka ku jira pop-upka. Ka saar wax kasta oo aad rabto inaad xannibto, ka dibna dooro OK. Xaqiiji eraygaaga sirta ah oo dooro OK mar kale.

Tani waxay xannibi doontaa unugyo gaar ah oo ku jira Microsoft Excel . Waxaad awood u yeelan doontaa inaad wax ka beddesho unugyada furan faylka Excel , laakiin ma aha kuwa aad xidhay. Xasuusnoow haddii aad codsatay qaabeynta shuruuda ka hor inta aadan ilaalin xaashida, qaabeynta ayaa u sii socon doonta sidii la filayey xitaa haddii unugyada qaar ay xiran yihiin.

Sida Loo Xiro Kala^(Range) - duwanaanshaha Unugyada^(Cells) gudaha Excel

Waxa kale oo aad u oggolaan kartaa dadka inay isticmaalaan erayga sirta ah si ay wax uga beddelaan noocyo kala duwan oo unugyo ah oo ku jira xaashida shaqada ee Excel^{(Excel worksheet)} . Tani waxay kuu ogolaanaysaa inaad dejiso furaha sirta ah ee goonida ah si aad u ilaaliso xaashida Excel iyo erayga sirta ah ee unugyada kala duwan ee kasta oo aad rabto in dadku wax ka beddelaan.

Marka ay dadku wax ka beddelaan unugyada xaashida, ma ilaalin doonaan dhammaan dukumeentiga. Tani waxay kuu ogolaanaysaa inaad quful unugyada caanaha oo kaliya u ogolaato dadka inay isticmaalaan furaha sirta ah si ay wax uga beddelaan unugyada halka xogta gelinta ay lagama maarmaan tahay.

Si taas loo sameeyo, fur xaashida oo dooro qaacidooyinka dukumeentiga, ama dooro safafka^(rows) ama tiirarka oo dhan. Hadda u gudub tab dib u eegista^(Review) oo dooro Oggolow^{(Allow Edit Ranges)} wax ka beddelka kala duwanaanshaha .

Gudaha Oggolow ^(Allow) Isticmaalayaasha^(Users) inay wax ka beddelaan Tirooyinka^{(Edit Ranges)} pop-upka, dhagsii New . Tani waxay furi doontaa Range Cusub^{(New Ranges)} oo soo booda ah oo leh dhammaan unugyada aad dooratay.

Sii kan cinwaan si ay u fududaato in la helo, sida Unugyada Galinta Xogta ee Qufulan^{(Locked Data Input Cells)} . Geli^(Enter) furaha sirta ah ee tirada unugyada, dhagsii OK, oo xaqiiji erayga sirta ah. Ugu dambeyntii, isticmaal sifada Sheetka Ilaalinta^{(Protect Sheet)} si aad u quful xaashida. Waxaad hadda awoodi doontaa inaad isticmaasho erayga sirta ah si aad u saxdo tirada unugyada ee aad hadda qeexday.

Sii wad Barashada^(Learning) iyo Sahaminta Microsoft Excel^{(Exploring Microsoft Excel)}

Hadda oo aad baratay sida loo xidho unugyada Microsoft Excel , waa inaad sii wadaa sahaminta abka si aad u ogaato gudaha.

Marna aad daah uma aha inaad bilowdo barashada aasaaska^{(start learning the basics)} . Waxaad sidoo kale hubin kartaa sida loo barbardhigo laba faylal oo kala duwan oo Excel ah oo aad muujisid faraqa^{(compare two different Excel files and highlight the differences)} u dhexeeya kuwa.

How to Lock Cells in Microsoft Excel

If you’ve painstakingly created an Excel sheet, you might want to stop others from making chаnges. You can do this by learning how to lock cells in Microsoft Excel sheetѕ.

In this tutorial, we’ll also show you how to protect sheets and entire workbooks in Excel to stop people from making changes to the entire document, as opposed to a few cells. Along with this, we’ll also cover how to unprotect sheets in Excel.

How to Protect Sheet in Excel to Prevent Editing

You can use the protect worksheet feature to stop people from changing your Excel sheets. To do this, open any Excel workbook and select the Review tab above the Ribbon menu. The Review tab is located between the Data and View tabs.

To protect a single Excel sheet, click Protect Sheet, which is located in the Protect section of the Ribbon menu. You can now set a password for the sheet.

The pop-up menu for Protect Sheet allows granular control over Excel features that can be used on the sheet. You can uncheck the features you want to block. To stop people from making changes to cells in your Excel sheet, be sure to uncheck the Format cells option.

The Edit Objects option deserves a special mention here. If you disable it, people will still be able to run macros embedded in your Excel file, but will not be able to delete it. Click OK when you’re done.

This will protect the Excel spreadsheet you’re working on, but if you have a document with multiple sheets, you will have to use a different option to prevent all types of editing.

To stop people from adding, moving, or deleting sheets in your Excel workbook, go to the Review tab and click Protect Workbook. You’ll see a popup titled Protect Structure and Windows. Add a password to stop people from making changes easily, and select OK when you’re done.

Lock Specific Cells in an Excel Sheet

To lock specific cells in an Excel sheet, open the spreadsheet and press Ctrl+A on Windows or Command+A on Mac to select all cells. Then, press Ctrl+1 on Windows or Command+1 on Mac to open the Format Cells window. You can also open this pop-up by pressing Ctrl+Shift+F on Windows or by using the Command+Shift+F keyboard shortcut on Mac.

If you’re having issues with your keyboard, select the Home tab above the Ribbon menu and press the arrow icon in the bottom-right corner of the Font section. You may also right-click any cell and select Format Cells.

Select the Protection tab, uncheck the Locked check box, and select OK.

Now you should find & select the cells or range of cells that you want to lock. Once you’ve done that, press Ctrl+1 again, and go to the Protection tab. Check the Locked check box and click OK. This will lock specific cells in Microsoft Excel, but there’s one more step before you can stop others from editing these cells.

Click the Review tab and select the Protect Sheet option. Add a password here, and go through the list of options in the pop-up. Uncheck everything you want to block, and then select OK. Confirm your password and select OK again.

This will block specific cells in Microsoft Excel. You will be able to edit unlocked cells in the Excel file, but not the ones you’ve locked. Remember that if you’ve applied conditional formatting before protecting the sheet, the formatting will continue to trigger as expected even if some cells are locked.

How To Lock a Range of Cells in Excel

You can also allow people to use a password to edit a specific range of cells in your Excel worksheet. This lets you set a separate password to protect the Excel sheet and a second password for each range of cells you want people to edit.

When people edit cells in your sheet, they will not have to unprotect the entire document. This will allow you to lock formula cells and only allow people to use a password to modify cells where data input is necessary.

To do this, open a spreadsheet and select formulas in the document, or select entire rows or columns. Now go to the Review tab and select Allow Edit Ranges.

In the Allow Users to Edit Ranges pop-up, click New. This will open a New Ranges pop-up that has all the cells you’ve selected.

Give this a title to make it easy to find, such as Locked Data Input Cells. Enter a password for the range of cells, click OK, and confirm the password. Finally, use the Protect Sheet feature to lock the sheet. You’ll now be able to use this password to edit the range of cells that you just defined.

Keep Learning and Exploring Microsoft Excel

Now that you’ve learned how to lock cells in Microsoft Excel, you should keep exploring the app to know it inside out.

It’s never too late to start learning the basics. You can also check out how to compare two different Excel files and highlight the differences between those.

Related posts

• Sida loogu daabaco baqshadda gudaha Microsoft Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• Sida Loo Mideeyo Unugyada, Tiirarka & Safafka gudaha Excel

• Farqiga u dhexeeya Microsoft Excel Online iyo Excel ee Desktop

• Sida Loo Hagaajiyo Safka gudaha Excel

• Sida loo Isticmaalo If iyo Nsted Haddii Odhaahyada Excel

• Hagaha VBA Sare ee MS Excel

• Sida Dhakhso Loo Geliyo Safaf Badan gudaha Excel

• Sida loo isticmaalo Excel's What-If Analysis

• Safka Kooxda iyo Tiirarka ku jira xaashida shaqada ee Excel

• Sida Loo Fahmo Maxaa-Haddii Falanqaynta Microsoft Excel

• 4 siyaabood oo Excel loogu badalo Google Sheets

• Sida loo sameeyo shaxda Pie ee Excel

• Sida loo dayactiro nooc kasta oo Microsoft Office ah

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

• Sida Loo Muujiyo Tirada Word gudaha Microsoft Word

• U samee ama u abuur furaha-gaaban ee kiiboodhka ee Microsoft Office

• 4 siyaabood oo loo isticmaalo calaamadda jeeg ee Excel

• Xarunta Xogta Xaashida Shaqada ee Excel si loo daabaco