Cell Comments & Notes

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

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

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 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 threaded comments and notes from selected cells. When multiple worksheets are selected, all comments and notes on those sheets will be deleted.

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

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