Protecting a worksheet is a two-part process that initially may appear to be slightly counter-intuitive. Protecting the cells in a shared worksheet means that the cells or range cannot be modified. The latter security measure is to ensure no one can access a workbook without the proper credentials - a key to get in. Keep in mind that protecting worksheet data is different than protecting a workbook with a password. The following steps show how to protect critical data while allowing users to enter information in only the fields you want them to access. Whatever it is, people should just keep their hands off it!įortunately, Excel makes it possible to prevent people from changing things. Maybe it’s equipment part numbers, or a shipping-cost calculation. Do you have a shared worksheet in Microsoft Excel 365 containing important data or carefully-constructed formulas you don’t want altered, accidentally or deliberately? Perhaps it’s the standard hourly rate.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |