How to name, comment and protect cells in Excel
The following article shows you how to name, comment and protect cells in Excel.
1. Name the data cell.
- Normally, the data cell with the default name is the combination of the column and row order that makes up the cell. For example, cell B5 is named B5.
How to name, comment and protect cells in Excel Picture 1
- To change the name of a cell, do as follows:
+ Click on the cell to be named -> in the formula bar enter the name in the Name Box field -> press Enter -> so the cell has been named:
How to name, comment and protect cells in Excel Picture 2
2. Add notes to the data box.
Step 1: Click on the box you want to add notes -> Review -> New Comment:
How to name, comment and protect cells in Excel Picture 3
Step 2: A TextBox appears entering the text of the note:
How to name, comment and protect cells in Excel Picture 4
- Cells with notes usually have small red triangle in the top right corner of the cell:
How to name, comment and protect cells in Excel Picture 5
- When you move to the cell containing the note -> it is displayed:
How to name, comment and protect cells in Excel Picture 6
- In case you want to edit the note, do the following: Click on the cell containing the note -> Review -> Edit Comment:
How to name, comment and protect cells in Excel Picture 7
- After entering the note content, the results will be:
How to name, comment and protect cells in Excel Picture 8
3. Protect data cells.
Step 1: Right-click the cell to be protected -> Format Cells:
How to name, comment and protect cells in Excel Picture 9
Step 2: The Format Cells dialog box appears -> select Tab Protection -> select Locked:
How to name, comment and protect cells in Excel Picture 10
Step 3: Right-click the sheet name -> Protect Sheet to set password protection:
How to name, comment and protect cells in Excel Picture 11
Step 4: A dialog box appears enter the password in the Password to unprotect sheet, can choose to add some features for users in the Allow all users of this worksheet to section -> select OK:
How to name, comment and protect cells in Excel Picture 12
Step 5: A dialog box appears asking for password again -> retype the correct password -> click OK to finish.
How to name, comment and protect cells in Excel Picture 13
- After setting protection, click the protected data box to edit the data -> Excel gives the following notice:
How to name, comment and protect cells in Excel Picture 14
So your data is protected.
- In case you want to edit the data -> Unprotect data on the sheet by:
+ Right-click on the sheet name -> Unprotect sheet:
How to name, comment and protect cells in Excel Picture 15
+ Enter the password you have set -> click OK.
How to name, comment and protect cells in Excel Picture 16
- After clicking OK you can edit your data arbitrary.
Above is a detailed guide on naming, annotating and protecting data cells in Excel 2013.
Good luck!
You should read it
- How to delete cells in Excel
- Merge cells in Excel
- How to color formula cells in Excel automatically
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- How to insert pictures into an Excel comment box
- Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel
- How to split cells, combine cells in Excel
- How to calculate and color blank cells in Excel
- How to Lock Cells in Excel
- How to merge cells in Excel - Instructions to merge cells in Excel 2010, 2013, 2016
- Instructions on how to create diagonal lines in Excel box
- How to split 1 cell into 2 cells in Excel - Split cells in Excel