Excel: Add Comments to Excel Spreadsheets

Sometimes it’s helpful to add comments into an Excel spreadsheet that further explain unique aspects or source of individual cell data/formula for reference.

To add a comment to a cell, select the cell then press Shift+F2 or right click and choose Add a Comment.  When the comment box appears, it will contain the author’s name.  If you desire, the name can be cleared before text is entered.  Click anywhere on your spreadsheet to exit the comment.  Cells that have a comment attached have a small red triangle in the upper-right hand corner.

To change the size of the comment, click and drag any of its borders.

To edit the comment, right click and choose Edit Comment.

If you want to delete a cell comment, right click and choose Delete Comment.

By default, all Comments are hidden; to display the comment, hover over the cell with your mouse.  To display the comment all the time, right click and toggle the Show/Hide Comments command.

Looking For More?

Comments

Silicon Valley Accounting Solutions produces the Solution of the Week in order to share tips and shortcuts that promote process efficiency and highlight software features that may not be in your current toolbox. Please let us know if you have questions on how to accomplish a particular task or if you simply have a comment to share.

Even if you find that you know most of what you see here, it only takes one “Aha” to make regular visits worthwhile. To avoid missing any solutions, you may subscribe and have a new one delivered to your inbox each week.

Contact Us

We want to help you grow
your business, call us
at: (408) 844-4216 or
find out more here.

Controllership

When you need:
  • Clear processes for cash controls
  • Analysis of results
  • Customized reporting

Accounting

When you need:
  • Timely and accurate bookkeeping
  • Reconciliations and monthly closes
  • Familiarity with popular accounting software
Web Analytics