How To Insert A Comment In Excel
+ How To Edit And Delete It!

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

When you’re collaborating with others on your spreadsheet, inserting comments can save you a lot of time.

Instead of emailing your comments back and forth or trying to communicate in the cells of the spreadsheet, you can leave a comment.

And it’s not just good for collaborating: it can also be a big help in remembering what you were thinking when you created the spreadsheet in the first place.

Excel’s commenting features are easy to access. Let’s get started!

Inserting a comment

To insert a comment, right-click on the cell you’d like to comment on and select Insert Comment:

insert-comment

After that, you’ll see a box appear; type your comment in the box, and click anywhere outside of the box to save it.

Now you’ll see a red corner on that cell:

comment-flag

Hold your mouse over that cell or click on it to see the comment:

view-comment

You can use comments for anything—ask for clarification, provide some detail on a cell, remind yourself to fill in information, or anything else you can think of.

Kasper Langmann, Co-founder of Spreadsheeto

Viewing comments

As you saw, you can mouse over a cell or click on it to view a comment.

But there are a few other useful ways you can view comments, too.

First, click over to the Review tab of the Ribbon.

comments-section

There’s an entire Comments section here that will help you work with comments.

If you click Show/Hide Comment, the currently selected cell’s comment will appear or disappear:

show-hide-comment

Using Show Comment will make the comment permanently visible (until you turn it off).

You can also select Show/Hide Comment from the right-click menu.

Kasper Langmann, Co-founder of Spreadsheeto

The Show All Comments button does the same, but for all the comments on the spreadsheet:

show-hide-all-comments

Finally, you can scroll through comments one at a time using the Previous and Next buttons.

This is especially useful when you want to look through a series of comments left by collaborators.

Kasper Langmann, Co-founder of Spreadsheeto

Editing and deleting comments

After some comments have been added to your spreadsheet, you may want to edit or delete them. Doing so is easy.

Just right-click on the cell with the comment and select Edit Comment or Delete Comment.

edit-delete-comment

If you choose to edit, your cursor will move to the text box and you can enter any text you like.

Choosing to delete gets rid of the comment.

You can also use the corresponding buttons in the Review tab, but right-clicking is usually much faster.

Kasper Langmann, Co-founder of Spreadsheeto

Using comments in OneDrive

Using comments in Excel Online (via OneDrive) is great for collaboration.

And, for the most part, it works in the same way. Right-click a cell to add a comment:

insert-comment-onedrive

You’ll notice, however, that comments are no longer “attached” to the cell you chose.

Instead, they appear in a panel on the right side of the screen:

onedrive-comments

And to view a comment, you can’t just click on the cell. You need to click the comment box above the cell when you select it:

show-comment-onedrive

Beyond that, it’s pretty much the same. Even the Review tab works similarly.

Use comments to be more productive

Most people think of using Excel comments when they’re working with others on a project.

But don’t underestimate their value on your own spreadsheets!

Forgetting where you got a number, why you put something where you did, or what you were going to do next can put a big damper on your productivity.

By reminding yourself of these things with comments, you’ll save yourself a great deal of time and frustration.