On the Home tab, in the Cells group, select Format and then select Protect Sheet.ī. On the Home tab, in the Cells group, select Format and then select Lock Cell.Ī. Unlock cells: We want you to only select the data in C5:C9.ī. Note: You are welcome to download the workbookto practice.Īpplies To: Microsoft ® Excel ® 2010, 2013, 2016.ġ. In today’s tip, using the below example, we’ll show you how to protect the entire worksheet except for the data range C5:C9, using four easy steps. You also have the option to remove the protection from a worksheet. You can protect certain worksheet or workbook elements, with or without a password. Worksheet Protection prevents someone from accidentally or deliberately changing, moving, or deleting important data from a worksheet or workbook. Are there parts of your Microsoft ® Excel ® worksheet that you wish you could protect? For instance you want to protect certain cells that contain certain formulas and important data, then Worksheet Protection is the answer.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |