How to defend cells in Excel with out locking the whole sheet?

Asked 1 year ago
Updated 1 year ago
Viewed 98 times

1 Answer


0

Overview:

In Succeed, you might safeguard exact cells without locking the entire sheet through the utilization of the “Protect Sheet” trademark related to portable designing choices. 

How to defend cells in Excel with out locking the whole sheet

 

  • Design the cells: Right-click on the picked cells and pick "Format Cells" from the setting menu. In the Arrangement Cells discussion compartment, go to the "Protection" tab. Uncheck the "Locked" choice, and snap on “OK.” Even when the sheet is protected, this will guarantee that those cells remain unlocked.
  • Safeguard the sheet: Presently, visit the “Review” tab at the Succeed strip and snap on “Protect Sheet” in the "Changes" organization. In the "Protect Sheet" exchange compartment, you might set a secret key in the event that you need to limit your access to the covered sheet. Pick the choices you need, along with allowing clients to pick locked cells, and snap "OK."
  • Affirm the wellbeing: Succeed will enact you to go into a secret word to confirm the security. Once shown, the cells that were currently not settled on and organized as opened may be covered. Clients can, in any case, draw in with the opened cells, even as the covered cells will remain protected from upgrading.
  • To discard security: To make changes to the safeguarded cells later, you could unprotect the sheet via going lower back to the “Review” under the tab, select "Unprotect Sheet," what's more, entering the secret phrase whenever set off.

You can protect specific Excel cells without locking the entire sheet by following these steps. This lets you control access to specific parts of your spreadsheet while still allowing users to freely interact with other cells.

Read more: How can you add comments to a cell in excel

answered 1 year ago by Baishakhi Ghosh

Your Answer