The range that you protect with a password does not have to be made of adjacent cells. You can now enter data in cell B3 and in any other cell in the range B2:B6, but you cannot enter data in any of the cells D2:D6 without first providing the correct password for that range. Type rangeone in the Enter the password to change this cell box, and then click OK. When you type D, the Unlock Range dialog box appears.
To help prevent modification of data and to help protect confidential information, limit access to any Excel files that contain such information by storing them in locations available only to authorized users. With enough time, users can obtain and modify all the data in a workbook, as long as they have access to it. These features also help prevent other users from making accidental changes to data.Įxcel does not encrypt data that is hidden or locked in a workbook. You can use these features to present information more clearly by hiding data or formulas that might confuse some users. The features in Microsoft Excel that are related to hiding data and protecting worksheets and workbooks with passwords are not intended to be mechanisms for securing data or protecting confidential information in Excel. In addition, if you use Windows 2000, you can apply group-level passwords and user-level passwords to different ranges. This is a change from earlier versions of Excel, in which one password applies to the entire worksheet, which might have several protected ranges. Note: You can also use VBA code to protect a sheet.In Microsoft Excel 2002 and in later versions of Excel, you can now use passwords to protect specific ranges in your worksheets. This means you have completely protected your worksheet from viewing. Now, if you try to unhide the sheet, you’ll see that the unhide option is disabled. Reenter the password to confirm and click OK.In the Ribbon, go to Review > Protect Workbook. Right-click the sheet you want to protect (here, Sheet1), and click Hide.To completely lock a sheet for viewing, follow these steps: You can hide Sheet1 by right-clicking it and selecting Hide.Īs a result, this sheet is hidden, but if you right-click on any of the other sheets’ tabs, you can unhide it by clicking Unhide. Say you have an Excel file with three sheets (Sheet1, Sheet2, and Sheet3). If you only hide the sheet without protecting it, users can still unhide the sheet and view it. In Excel, you can completely hide and protect a worksheet from being viewed by hiding and then protecting the worksheet. This tutorial will demonstrate how to password protect an Excel sheet from being viewed.
0 kommentar(er)
