How to password protect an excel document

Deepak Gupta June 18, 2022
Updated 2022/06/18 at 3:49 PM

Excel is one of the most useful tools in Office 365, serving a multitude of things. If you want to prevent those with whom you share a certain document from being able to edit it, you can protect your sheet(s) with a password.

Find out how to do it!

<!–

PUB

–>

Despite its flaws, Office 365 is very complete and one of its most impressive tools is Excel. Through this program we can go beyond simple tables and perform true and complete data analysis, due to its infinity of options.

If you don't know, know that this tool has a security feature and that it is possible to add a password to documents, making them read-only for those who receive them. By setting a password, you ensure that the only people who edit the document are those you have authorized, blocking personalization of the sheet.

Password Protect an Excel Workbook

First, open the document you want to protect, going to File in the upper left corner.

excel

Then go to save as and select the folder where you want to see your saved file.

After the Save As option pop-up that you selected appears, make sure that the “Excel Workbook” is selected in the “Save as type” bar.

excel

Still in the pop-up, go to Tools and select General Options.

There, a new pop-up will open in which you must define the password that will be requested “to modify” the document. If you wish, you can also set a password “to open” as well.

Also select the “Recommended read-only” option.

After setting the password, confirm it in the box that appears next.

excel

When someone wants to open the document that you have protected, they will need to enter the password, or else select the reading option, which you have set as recommended.

Now, you know how to protect your Excel documents, ensuring that you only access and change them who you authorize.

Read too:

!function(f,b,e,v,n,t,s){if(f.fbq)return;n=f.fbq=function(){n.callMethod?
n.callMethod.apply(n,arguments):n.queue.push(arguments)};if(!f._fbq)f._fbq=n;
n.push=n;n.loaded=!0;n.version='2.0';n.queue=[];t=b.createElement(e);t.async=!0;
t.src=v;s=b.getElementsByTagName(e)[0];s.parentNode.insertBefore(t,s)}(window,
document,'script','https://connect.facebook.net/en_US/fbevents.js');
fbq('init', '1664527397186427'); // Insert your pixel ID here.
fbq('track', 'PageView');
(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/pt_PT/sdk.js#xfbml=1&version=v2.3&appId=122308327859118";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));

Share this Article
Leave a comment

Leave a Reply

Your email address will not be published. Required fields are marked *