First time here? Check out the FAQ!
x

How can I protect my Excel spreadsheet?

0 votes
asked by
edited by

I need that each time I save the file, any information entered in the document be protected. For example if I fill five lines in the spreadsheet, then save, the next person that comes behind me and fills in his information can view mine but cannot change it. Can you help me?

1 Answer

0 votes
answered by (193k points)
edited by

In order to protect your information entered in the Excel file, you need to select the rows and columns that contain your data and to click on Protect Sheet from the Review tab. In the pop-up window, you can select the elements that you want users to be able to change and to enter a password for your information. Click OK and reenter the password. In order to remove the password, you need to select the sheet with your data and to press Unprotect Sheet. Enter the password and the spreadsheet will be unlocked. Click the Allow Users to Edit Ranges button and you will be able to give to a specific user permission to edit ranges in a protected worksheet. For further information, you can check the Microsoft Support web page.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...