Excel

Cell Comments & Notes

Comments vs. notes

Microsoft recently changed its naming convention for comments. "Comments" now refers to threaded comments that support replies and resolution, while "notes" now refers to what was formerly known as "comments".

Resolve Comments

Resolve unresolved comments in selected cells. When multiple worksheets are selected, all unresolved comments on those sheets will be resolved.

Reopen Comments

Reopen resolved comments in selected cells. When multiple worksheets are selected, all resolved comments on those sheets will be reopened.

Fix Notes

Cell notes (formerly called "comments") can become displaced relative to their parent cells, and/or become flattened (height = zero) very quickly while modeling. Macabacus' Fix Comment tool restores selected cells' comments to their default positions relative to their parent cells, and optionally resizes. When multiple worksheets are selected, this operation will be performed on all comments on those sheets.

In the Excel > Format > Other section in Macabacus' Settings dialog, you can specify whether you want to both reposition and resize comments, or just reposition them. If you elect to resize comments, you can specify whether you want Macabacus to resize comments to fit content, or resize comments to default dimensions.

Remove Author

Remove the author's name from all cell notes in the active workbook. This might be handy when you want to send a workbook to a client but maintain anonymity for the workbook's creator, for example.

Delete Comments & Notes

Delete threaded comments and notes from selected cells. When multiple worksheets are selected, all comments and notes on those sheets will be deleted.

Ctrl
Alt
Shift
D

Delete Resolved Comments

Delete threaded comments marked resolved from selected cells. When multiple worksheets are selected, all resolved comments on those sheets will be deleted.

Delete Empty Notes

Delete all notes in the active workbook that contain no text other than the author's name.

This documentation refers to Macabacus version 9.0.7. Some features and descriptions of these features may not
apply to older versions of Macabacus. Update your Macabacus software to take advantage of the latest features.