TOP

Copy comment to cell

Comment > Copy comment to cell

This tool copies a cell's comment into its formula.

In this way, you can, for example, restore a saved formula or an old cell value.

You can also use the function GETCOMMENT() , which returns the comment text of the specified cell.


Screenshot

Before copying:

Comment > Copy comment to cell

After copying:

Comment > Copy comment to cell

Running this tool

Click YLC Utilities > Comment > Copy comment to cell :

Comment › Copy comment to cell

Quick solution

Just use the next tool in the menu LO Calc :

YLC Utilities » Comment » Copy comment to cell

This is much faster than manually copying each cell's comment into its formula.

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. LO Calc , the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Copy comment to cell by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in LibreOffice Calc .


Additional keywords for this tool:
transfer comments to cell values, comments, formulas, annotations, comment field, edit comment, copy comment to cell, copy formula