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 then Allow Users to Edit Ranges. This advanced option allows multiple users (for example, … Continue reading
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 exercise how we can limit the movement in a protected sheet. To limit the … Continue reading
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 from other users we secure it through the password, and when we want to send … Continue reading
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) when we want to secrete formula from users, or if we … Continue reading
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 OK, or use Signatures Services from the Microsoft Office Marketplace.
To enter a password: 1. Select File -> Save as. 2. Click Tools button, select General Options. 3. In General Options dialog box, enter passwords into Password to open and Password to modify boxes, and click OK.
Why it is important to protect a workbook? To prevent the structure from being changed. To prevent sheets from being deleted. To prevent new sheets from being inserted. To prevent hidden sheets from being opened. To protect a workbook: 1. … Continue reading
MS-Excel 2013 allows you to add the digital signature to the workbook files. After checking the spreadsheet and verifying all the details, with the digital signature we can confirm if we are the authorized person for the same. Let’s understand … Continue reading
When a sheet is hidden and the workbook is not protected, it will still appear in the list of hidden sheets in the Unhide box (from the Format menu, select Sheet, and then Unhide). To prevent hidden sheets from appearing … Continue reading
In this example, the sheet is divided into two parts: an area where movement is allowed (the Scroll Area), and an area where movement is restricted (that is, a protected area), without protecting the sheet. Set the Scroll Area range … Continue reading