Ask Your Question
0

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:

Support http://mainelegislature.org/LawMakerWeb/rollcall.asp?ID=280048537&chamber=H&serialnumber=498

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

pierre-yves samyn gravatar image

Hi

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)?

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 51 times

Last updated: Oct 09 '16