Sometimes you need to protect just some cells for security reasons or any other. In this tutorial we are going to learn how to lock cells to protect them using security features from Microsoft Excel.
Excel is a software program from Microsoft that uses spreadsheets to organize data with formulas and functions.
How to lock cells to protect them?
To lock cells follow these steps:
- Select the cells you don’t want to lock.
- On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window.
- On the Protection tab, unselect the Locked check box, and then click OK to close the popup.
- Note: This does not mean that the cells are unlocked. This mean that these cells are not ready to be locked.
- Select the cells you want to lock.
- On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window.
- On the Protection tab, select the Locked check box, and then click OK to close the popup.
- Note: This does not mean that the cells are locked. This mean that these cells are ready to be locked.
- On the Review tab in the ribbon, in the Changes group, select either Protect Sheet or Protect Workbook, and then reapply protection.
Where to learn more?
There are many features from excel that you can learn from beginner to advanced. Enroll to this course and you learn more features like:
- Creating effective spreadsheets
- Managing large sets of data
- Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)
- Create dynamic report with PivotTables
- Unlock the power and versatility of Microsoft Excel’s AddIn, PowerPivot
- Audit worksheet formulas to ensure clean formulas
- Automate your day-to-day tasks by mastering the power of Macros and VBA
For more information about this course click here.