Excel now saves the excel workbook as a read-only file with a password. Consequently, excel will get back to the General Options dialog, press Save.Again enter the password when the Confirm Password prompt box appears and press OK.From the box, put a checkmark on the Read-only recommended and type a suitable password in the Password to modify field. Upon clicking on the General Options, the below dialog box shows up.Now, give a name to the excel file and go to the bottom section of the window to choose General Options from the Tools.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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |