Video:How to Add Comments in Excelwith Don Schechter
You can provide context to your data by inserting comments in Excel cells. Learn how to insert comments in Microsoft Excel.See Transcript
Transcript:How to Add Comments in ExcelHi! I'm Don Schechter for About.com Computing. Today I'll show you how to make comments in Microsoft Excel.
Why Add Comments in Excel Documents?Open Microsoft Excel, and I'll open a saved document. What I would like to do is add a few comments to the data you see here, so when I send it people can not only view the data but any additional information to help explain the data. It's a great way to communicate with other people looking at the data without cluttering up the spreadsheet.
Insert a Comment in an Excel CellSo Ill just click on cell B7, right click and choose 'Insert Comment.' A small box will appear with the name of your computer. This is where you can type your comment. I'll type 'Highest Monthly Sales.' I'll click 'off,' and now you can see a little colored triangle in the corner of the cell. If I move my mouse over the cell and hover, the comment will appear.
Adjust the Comment BoxesI'll add another comment to cell C3. This time I'll go up to 'Insert' on the toolbar and click 'Comment.' I'll type in 'Average Sales for Feb.' You can resize the comment box if you wish by dragging the handles around the box. This makes it easier to see the data if your comment is short. Your comments can be a paragraph or two to help explain the data. You can adjust the comment box as you like it.
Thanks for watching. To learn more, visit us online at computing.about.com.
About videos are made available on an "as is" basis, subject to the User Agreement.