![]() Ranges: You can enable users to work in specific ranges within a protected sheet. For more information, see Display or hide formulas. Here's what you can lock in an unprotected sheet:įormulas: If you don’t want other users to see your formulas, you can hide them from being seen in cells or the Formula bar. ![]() To know the difference between protecting your Excel file, workbook, or a worksheet see Protection and security in Excel. To prevent users from adding, modifying, moving, copying, or hiding/unhiding sheets within a workbook, see Protect a workbook. To lock your file so that other users can’t open it, see Protect an Excel file. ![]() Protecting a worksheet is not the same as protecting an Excel file or a workbook with a password. It simply prevents users from modifying locked cells within the worksheet. Worksheet level protection is not intended as a security feature.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |