Excel Comments Renamed Back to Excel Notes
Originally Excel had a feature called Notes that allowed us to add a note to a cell to provide additional information for ourselves or others. Then around 2000 Excel renamed them to comments. Now Excel is changing the name back to notes and introducing a new feature, starting with 1810, Comments.
Notes are a great way to add instructions, details, and explanations in our workbooks. With this change of name all the features of what we use to call comments remains including changing the shape, fill the background, and edit. All the commands are still available on the right mouse menu or the Review tab on the ribbon.
Notes are a great way to add instructions, details, and explanations in our workbooks. With this change of name all the features of what we use to call comments remains including changing the shape, fill the background, and edit. All the commands are still available on the right mouse menu or the Review tab on the ribbon.
You can take existing notes in a workbook and Convert to Comments as shown in the Notes drop down menu above.
The All New Excel Comments
The new Excel Comments provide improved collaboration with a threaded discussion. Using @mentions draws collaborators attention directly to your comments. When an @mention is made the person will receive an email with a link to the file to provide them with quick access and a simple response option. (The file must be shared with them or in a location they have access permissions) To create a comment you can right click the cell or select New Comment on the Review tab. Once your comment is completed click the Green arrow to send the comment to any @mentions you have included.
Note the new indicator icon in the top left of the cell containing a comment and the specific cell reference in the comment.
A sample of the email received by Demo is below, note the link to quickly open the file.
A sample of the email received by Demo is below, note the link to quickly open the file.
Selecting the Show Comments command on the Review tab opens a floating panel of comments on the right side of Excel. The panel shows the comments for the current sheet and can be moved to a different location including another monitor. This provides a view of all the comments for the sheet without hiding any information on the worksheet. The Previous Comment and Next Comment commands on the review tab provide a quick way to review all comments in a file, quickly flipping from worksheet to worksheet as required.
Since comments do not show on the sheet when selecting the Comments options on the sheet tab of Page Setup selecting As displayed on sheet will only print notes. Selecting At end of sheet will print both notes and comments.
The new comments in Excel is a welcome addition, providing a simple threaded conversation within our files to keep everyone current on the changes, items requiring their attention, and responses.
| notes_and_comments.xlsx |
RSS Feed