Step 2 – select Info, then Protect Workbook. Password Protect an Excel Spreadsheet Click on the “Share” button, located in the upper left corner of the screen. When a user on the network opens the file in Excel, the file is locked for editing - this is the expected behavior. ![]() Protect Files On the next screen, expand the list of Open Files > right-click on the Locked Excel File and … In the Password to modify box, enter a password and click OK. How to Lock To begin, launch the "Run" dialogue box by simultaneously holding the "Windows" key and pressing "R". Step 3a – if you want to set a password to open the file, select “Encrypt with Password”. Now, you can choose the cells you specifically want to lock. Step 2: Import edit-restricted Excel file with click on "Open". how to password protect an excel file in onedrive. ![]() How to Lock The user stated left the company a long time ago, but in my experience it is not that unusual for Excel/Word to report the incorrect user. ![]() Step 1: Right, click on the excel cell you wish to protect then, Select ‘Format Cells’ from the menu displayed. There is a hidden file that starts with a ~ and then the filename of the XLS(X) file you are editing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |