Add Cell's Value or Formula to Comment...

ASAP Utilities › Objects & Comments › 2. Add Cell's Value or Formula to Comment...

This tool adds each cell's value or formula as a legacy comment (note) in the selected cells. You can:

Choose to use the cell's value or formula

Use the content of the current cell or from a cell to the left or right

Replace existing comments or insert the content at the beginning or end

Choose whether to include a username, auto-fit the comment size, or reset the comment's position

Control how Excel displays comments and indicators (this is a global Excel setting, see note below) This tool works with legacy comments (called notes in modern Excel), not threaded comments. It's useful for:

Documenting formulas directly within the worksheet

Adding explanations or reminders next to cell values

Creating annotated reports or templates for others to review Note:
The display setting refers to the global Excel setting that controls how comments and indicators are shown.
You can find it under:
File > Options > Advanced > Display > For cells with comments, show...
Changing it in the form will immediately update this Excel setting.

Screenshots

Objects & Comments › 2 Add Cell's Value or Formula to Comment...

Starting this tool

Click ASAP Utilities › Objects & Comments › 2. Add Cell's Value or Formula to Comment...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords for this tool:
cell to comment, add formula to comment, add value to comment, insert cell value as note, insert formula as note, comment with cell contents, Excel comment automation, annotate cell values, add notes in Excel cells, auto comment with formula, show formula in note, cell content to sticky note

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Edit, Extract, and Manage Comments and Notes...

Select All Objects

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.