Share via

AUTOFIT EXCEL COMMENTS

Anonymous
2012-03-11T00:04:10+00:00

Greetings! Is it possible in MS EXCEL 2010 to set up EXCEL comments so the boxes would automatically fit the comment contents.

When I copy and paste material into a comment, often the lower half of the contents will be truncated, so I have to open the comment window and resize it.

This is a problem when the spreadsheet contains a lot of comments. It would be nice to be able to format the comments globally so the size of the window automatically fits the comment data. Is there a way to accomplish this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-03-11T00:16:35+00:00

Was this answer helpful?

1 person found this answer helpful.
0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-07-18T18:57:56+00:00

    Warning: AutoSize will convert comment to a single line (unless there are line breaks). Will look bad for longer comments.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2012-03-11T02:45:51+00:00

    Thanks, Gary's Student. I forgot to ask: if I run this macro, after I have already inserted some comments, are all the comments, past and future, affected? That is, future comments will autosize?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-03-11T02:09:16+00:00

    Give it a try and post back.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-03-11T01:45:13+00:00

    Yikes! A scavenger hunt. I guess this is the macro I should use, right?

    Sub FitComments() Dim c As Comment For Each c In ActiveSheet.Comments c.Shape.TextFrame.AutoSize = True Next c End Sub

    Was this answer helpful?

    0 comments