Buzz
This article guides you on how to name, make notes, and protect cells in Excel.
1. Naming Data Cells:
- Typically, data cells default to a combination of the column and row order, forming the cell name. For example, cell B5 is named B5.
To change the name of a cell, follow these steps:
Select the cell you want to rename -> on the formula bar, enter the name in the Name Box -> press Enter -> now the cell is named.
2. Add a note to the data cell.
Step 1: Select the cell where you want to add a note -> Review -> New Comment:
Step 2: A TextBox will appear for entering note content:
- Note-containing cells usually have small red triangles in the upper right corner:
- When you hover over a cell with a note -> it will be displayed:
- If you want to edit the note, do the following: Click on the cell with the note -> Review -> Edit Comment:
- After re-entering the note content, the result is as follows:
3. Data Protection.
Step 1: Right-click on the data cell to be protected -> Format Cells:
Step 2: The Format Cells dialog appears -> select Tab Protection -> check Locked:
In Step 3: Right-click on the sheet -> Protect Sheet to set up the protection password.
Moving on to Step 4: A dialogue box appears for entering the password under Password to unprotect sheet, where you can choose additional features for users in the Allow all users of this worksheet to -> select OK:
Now, in Step 5: A dialogue box prompts you to re-enter the password -> re-enter the correct password -> click OK to complete.
- After setting up the protection, select the protected data cell to make edits -> Excel provides a notification:
Your data is now safely secured.
If you wish to modify the data -> Unprotect the data on the sheet by following these steps:
+ Right-click on the sheet name -> Unprotect sheet:
+ Enter the password you set -> press OK.
- Pressing OK allows you to customize your data as you wish.
Here is a detailed guide on how to name, annotate, and safeguard your data cells in Excel 2013.
Wishing you all the best in your endeavors!
