Adding a Comment to a Cell

by Allen Wyatt
(last updated February 6, 2014)

As you are developing a spreadsheet, it can be helpful to add comments that explain your thinking. For instance, you might want to add a comment explaining what a particular cell value means, why a particular formula was used, or additional research that needs to be done. How you use comments is entirely up to you. Here's how you add them to a cell:

  1. Select the cell to which you want to add a comment.
  2. Choose Insert | Comment. Sheets shows a comment box beside the cell. (See Figure 1.)

    3. Figure 1. Adding a comment to a cell.

  3. Type your comment in the available space.
  4. Click Comment.

You'll notice that the comment remains visible beside the cell. If you move to a different cell, then the comment is hidden, but you can still see a small triangle at the upper-right corner of the cell containing the comment. Hover the mouse pointer over the cell with a triangle, and you'll see the comment. Select the cell with a triangle and the comment is also displayed.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Saving a Workbook Using Passwords

One of the security features built-in to Excel is the ability to save a workbook using a password that limits access to ...

Discover More

Floating Information in a Frozen Row

You can freeze information in rows or columns using one of the built-in features of Excel. As you move up or down in the ...

Discover More

Hiding the Taskbar when It is Not in Use

Don't like the Taskbar visible on the screen? You can easily hide it when you aren't using it by making just one small ...

Discover More
More DriveTips

Transposing Information in a Sheet

If you want to turn a range of cells by 90 degrees within a spreadsheet, you need to understand how Sheets can handle the ...

Discover More

Determining the Day of the Week

Need to know what the day of the week is? Sheets provides a handy function that can return a numeric value that ...

Discover More

Keeping Row and Column Headings in Sight

When you create a spreadsheet, it is common to place headings at the top of each column and the left of each row so you ...

Discover More
Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is four less than 5?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

Links and Sharing
OUR COMPANY
OUR PRODUCTS
OUR AUTHORS
OUR SITES
 

Copyright © 2019 Sharon Parq Associates, Inc.