- Entering Data and Making Changes
- Entering Data
- Editing and Deleting Existing Data
- Zooming Into Your Data
- Undoing and Redoing Changes
- Copying and Pasting Data
- Freezing Rows and Columns
- Splitting a Worksheet
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Moving Data
- Finding Data
- Replacing Data
- Applying a Data Filter
- Sorting Data
- Adding and Managing Cell Comments
This chapter is from the book
This chapter is from the book
This chapter is from the book
Adding and Managing Cell Comments
Some cells contain data that requires an explanation or special attention. Comments provide a way to attach this type of information to individual cells without cluttering the cells with extraneous information. A red triangle indicates that a cell contains a comment, which you can view in several different ways. After a comment is in place, Excel makes it easy to edit or delete it.
)
Right-click the cell to which you want to add a comment.
Select Insert Comment.
Type the desired text into the comment area. When you’re finished, click anywhere in the worksheet to accept the comment.
The cell’s upper-right corner now contains a red triangle, indicating the presence of a comment. To view the comment, hover
the mouse pointer over the triangle.
Tip: Display Comments Without Hovering
You can make Excel display a cell’s comments without the need to hover over the cell. To do so, right-click the commented cell and select Show/Hide Comments. To re-hide the comment, right-click the commented cell and select Hide Comment.
)
To edit a comment, right-click on the commented cell.
Select the Edit Comment option.
To delete a comment, right-click on the commented cell.
Select the Delete Comment option.
