Protect A Workbook


Excel offers numerous levels of protection for your work.   You can protect a whole workbook, worksheet, columns, rows or even individual cells. If you want to prevent other user opening your whole workbook, then it you need to protect it.  It’s easy to do.

Choose File- Save As- Options.

We want to password protect the whole workbook Enter a password to modify- enter a password, this will prevent anyone opening, saving or making changes to the workbook unless you know the password to the workbook.

Click OK.

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts