DW Faisalabad New Version

DW Faisalabad New Version
Please Jump to New Version
  • Working with Tables
  • While there are four types of database objects in Access, tables are arguably the most ... read more

    Monday, 8 May 2017

    Protect Sheet

    When you share an Excel file with other users, you may want to protect a worksheet to help prevent it from being changed.

    1. Right click a worksheet tab.

    2. Click Protect Sheet.



    3. Enter a password.

    4. Check the actions you allow the users of your worksheet to perform.

    5. Click OK.



    Note: if you don't check any action, users can only view the Excel file!

    6. Confirm the password and click OK.



    Your worksheet is protected now. To unprotect a worksheet, right click on the worksheet tab and click Unprotect Sheet. The password for the downloadable Excel file is "easy".
    .