olzvisions.blogg.se

How to make excel read only with password
How to make excel read only with password













how to make excel read only with password

Click File – Save As, and choose one folder where you will save this spreadsheet.ģ. Anyone who wants to make changes to it firstly needs to unprotect the Excel spreadsheet with the correct password. Finally, press Ctrl + S to save the spreadsheet. A protects sheet dialog will pop up, keep the checkbox next to Protect worksheet and contents of locked cells checked, you can also choose what actions the users of this spreadsheet can do, type a password used to unprotect the spreadsheet, and then click OK.Ħ. The document will be auto-saved and its title marked with read-only and one yellow message on the top to discourage others from editing. Click in the box and choose Mark as final.ġ0. Select the first option, Protect a workbook.ĩ. Save your file – press either file and choose to save or ctrl + s and choose a location of where you want it to be saved.Ĩ. Input data into the cells as well as the formulas that your data will utilize in calculations.Ĥ. Open excel application on your computerģ.















How to make excel read only with password