How do you insert a comment into an entire row or column, or a range of cells? – Satish
Satish, there’s no built-in method for inserting the same comment into multiple cells. For the record, I don’t think inserting a comment into an entire row or column would be a good idea. However, I can see a user wanting to do so with a range—even a non-contiguous range.
Allen Wyatt has provided the best solution that I know of for this type of task: Adding a Comment to Multiple Cells. You’ll learn how to copy a comment, and he provides a macro that will insert a comment into multiple cells.
Thanks to Allen Wyatt and to David McAfee for sharing it with me, as a possible solution to your question.