A picture says a thousand words, but numbers sometimes need more explanation. Have you ever looked at a spreadsheet of data and had some questions about the numbers you see? On the other hand, have you ever wanted to clarify something about the data you’re providing to someone else? Give your data context by adding notes to individual cells. This tip shows you how simple it is to insert comments in Excel and format them.
Insert Comments in Excel
Inserting comments can give the viewer additional insight about your data and allow you to ask questions. To add a comment, right-click the desired cell and select Insert Comment. Enter the appropriate text into the comment box, including the default name if appropriate. Any cells with comments will have a red indicator in the top right corner of the cell. Hover your cursor over cells with red indicators to see the comment.
Formatting Inserted Excel Comments
By default, when you insert comments in Excel, they are formatted with Tahoma as the font with a font size of 9. You can adjust these attributes and more by editing your comment. Right-click on a cell containing a comment, then click the Edit Comment command in the drop-down menu. Use the options in the Font and Alignment groups of the Home tab to change the style of your comment.
For more customization, right-click on the border of the comment and select Format Comment. The Format Comment window gives you additional font, color, size, and alignment options. To delete a comment, right-click on the cell containing the comment and choose Delete Comment.
Additional Excel Resources
This just scratches the surface on what you can learn in Microsoft Excel! We offer multiple courses in Excel 2013, from beginner introductions to Excel to advanced classes, to classes on Pivot Tables and more. Check out our Course Schedule to learn more.
Subscribe to Monthly Training Updates
Receive monthly productivity and training insights, software tips, and notices of upcoming classes!