Ask Your Question

How do I append all cell annotations to their cell's contents?

asked 2016-10-09 02:37:24 +0200

user24601 gravatar image

updated 2016-10-09 02:38:44 +0200

I'm a noob for spreadsheets FYI.

I have an xlsx doc that contains annotations (comments) for some cells, but I want to export the comments as well, within the cell that the comment belongs to, as appended content.

See attached image. example spreadsheet

I want the cell content of the one annotated in the image to be the following:


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-10-09 08:21:27 +0200

pierre-yves samyn gravatar image


AFAIK this would only be possible with macro.

But this raises other problems:

  • Would it treat all cells containing comments or only some (which)?
  • The cells are too small to fully display their contents, should enlarge? how (width, height)?


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-09 02:37:24 +0200

Seen: 97 times

Last updated: Oct 09 '16