How to Protect an Excel Sheet

Sometimes we want our sheets to be view only. We don't want the user to make any change to some specific sheet. In that case, we should protect or say...

Allowing Multiple Users to Edit Ranges in Microsoft Excel

In this article, we will learn how we can allow multiple users to edit the ranges in Microsoft Excel. From the Tools menu, select Protection, and t...

Limiting the Movement in a Protected Sheet in Microsoft Excel 2010

In this article, we will learn about how we can limit the movement in a protected sheet in Microsoft Excel 2010. Let’s understand with a simple e...

Protect and Unprotect Workbooks in Microsoft Excel

In this Excel tip we will learn how to unprotected excel and how to remove password from excel file Sometimes to protect our confidential workbook ...

Protecting Data by Hiding a Row(s) and Column(s) in Microsoft Excel 2010

In this article we will learn how we can protect the data by hiding a Row(s), and Column (s) in Microsoft Excel 2010. We hide the Row(s) and Column(s)...

Protecting Workbooks with a Digital Signature in Excel 2007

To set a Digital Signature: 1. Select File -> Finish -> Add a Digital Signature. 2. To get a digital ID or create your own digital ID click ...

Adding Passwords to Prevent Unauthorized Opening of a Workbook in Excel 2007

To enter a password: 1. Select File -> Save as. 2. Click Tools button, select General Options. 3. In General Options dialog box, enter passwor...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.