Excel password protect with read only option

Excel password protect with read only option password#

If you are on Excel 2010 onward you will likely see the Save As screen first, if you do select the More Options text to take you through to the Save As Window: Alternatively the shortcut command of holding down the ALT key and pressing F2 will take you directly through to the Save As window. With the Excel Workbook open that you want to make Read-Only the first step is to select File > Save As using either the Menu bar at the top of the screen or by pressing the Office button if you are on an older version of Excel. To turn your Excel workbook into a read-only workbook complete the following simple steps. The Read-Only method ensures any Excel workbook you publish or one that you email to other people around your business will stay exactly as you intended it to be, unless you specifically allow them the access to change the file.

Excel password protect with read only option password#

It forces all users that open the workbook to open using Read-Only mode, this means they will be unable to make any changes to the file unless they are given a password set by you. Read-Only WorkbooksДЄ read-only workbook is exactly what is says on the tin. In todayвЂ™s society where data and information is a highly valuable commodity, arguably the most valuable commodity, IT security and data protection should really be at the forefront of every Excel analysts mind. Protecting your Excel workbook is a topic all Excel Business Analysts should aim to understand and it is also a useful technique for securing your personal Excel files. You can deploy the Read-Only option to your Excel Workbook to prevent unauthorised users from making changes, find out how belowвЂ¦ A striped background will appear over the cells.There are times when you need to protect your Excel Workbook from unauthorised changes made by other users. To see protected cells, click View Protected ranges. Copy permissions from another range: Reuse the same permissions you set up on a different set of cells or sheet.Custom: Only the people you choose can edit the range or sheet.This option is only available when everyone in your domain can edit the spreadsheet. Only domain: If you use Google Sheets for work or school, only people in your domain can edit the range or sheet.Only you: Only you (and the owner if youвЂ™re not the owner) can edit the range or sheet.To choose who can edit the range or sheet: select 'Restrict who can edit this range.' Choose:.To show a warning when anyone makes an edit: Select 'Show a warning when editing this range.' It doesnвЂ™t block people from editing, but theyвЂ™ll see a message asking them to confirm if they really want to make an edit.Click Set permissions or Change permissions.If you want a set of cells to be unprotected in a sheet, check the box next to 'Except certain cells.' Range: To change or enter the range youвЂ™re protecting, click the spreadsheet icon and highlight the range in the spreadsheet.Click Add a sheet or range or click an existing protection to edit it.Click Data Protected sheets and ranges.Simultaneously lock the formatting of cells and allow users to edit input values.Important: When you protect a sheet, you canвЂ™t: