Adding comments in your Excel spreadsheet

There have been times I would have liked to have made a note or two in a spreadsheet so I could remember something associated with a piece of data. I wish I had known about adding comments, but I do now!

In this spreadsheet, I want to attach a comment to cell C10. I right-click on the cell and select the Insert Comment option:

excel-comments-20180511-1

A yellow comment section shows up, and I can start typing. I can put as much as I want out there, and I can also use the handle buttons around the yellow comment field to reformat the box to make it wider or longer. I can tell I have a comment attached to this cell as there is a red triangle in the upper-right corner of the cell:

excel-comments-20180511-2

If I right-click on that cell again, I’ll see options to Edit, Delete, or Hide the comment:

excel-comments-20180511-3

You can also use the Review > Comments area of the Excel Ribbon Bar to do all the same functions plus a few more, such as showing all the comments at once:

excel-comments-20180511-4

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s