After browsing, the Save As dialog appears.Next, from the Excel Ribbon, go to the File tab.First go to the corresponding datasheet, where we have the data.So, now I will make the excel file read-only and will apply a password to restrict unwanted access and modification of data. Anyone who wants to open and modify the excel document must enter the correct password in the password text.Step by Step Guideline to Make Excel Workbook Read Only with Password Step 1: Use File Tab from Excel Ribbonįor instance, we have a dataset containing some products’ month-wise sales data. After setting a password for the excel document, each time the excel document is open, it will be protected by the following dialog box. You can encrypt a Microsoft Excel 2003 document with the way above. On the "Save As" window type a name for this excel document then click "Save". On the menu bar, click "File" to open the drop-down list. In the confirming dialog box, type your password to open to confirm. In the following window, select an encryption type in the list. In addtion: If you want to select an advanced encryption type, click "Advanced…". Anyone who has no the password to modify can read-only the document, but he cannot modify the document. Typing a password in the Password to modify text means that you are setting a password to protect the modifying privilege. Important: Typing a password in the Password to open text means that you will set a password to protect the excel document's access permission. Type a password to protect the privilege to modify in the Password to modify text. Type a password to encrypt the excel document in the Password to open text.
On the menu bar of the file window, click "Tools" to open the drop-down list then select "Options".Ģ. Open your workbook in Microsoft Excel 2003. Then how to set a password to protect a Microsoft Excel 2003 spreadsheet? The method is easy as below.ġ. So that anyone who accesses the document must enter the correct password. For security’s sake of data, it is necessary to encrypt an excel spreadsheet. Microsoft Excel 2003 is commonly-used to record data. Many of our work cannot do without Microsoft Office. How to Set/Create a Password to Protect a Microsoft Excel 2003 Spreadsheet
0 kommentar(er)
