In Excel, comments can be useful to give a suggestion for a change, a question to one of your colleagues, or any other text that relates to part of the worksheet. During yesterday’s training session one of my course participants asked whether it was possible to add a single comment to more than one cell.
Here’s how:
1. Right-click the first cell with which the comment is to be associated.
2. Select the Insert Comment option from the shortcut menu.
3. Type the text of the comment.
4. Copy the cell containing the comment. (CTRL+C, anyone?)
5. Select all cells that should have the same comment. (Hold down your CTRL key to select cells that are not next to one another.)
6. Right-click any of the selected cells and select Paste Special to open the Paste Special dialogue box.
7. Select the Comments radio button.
8. Click OK.
Thanks for the inspiration, Maxine!
By the way, if you want to print the comments, you might want to have a look at tip 142. An oldie, but a goodie!
PS I'm committed to sharing the best of what I know with others so please don't keep these tips a secret. If you enjoyed today's tip, please forward it to anyone you feel may benefit or reprint it (with full copyright and subscription information) in your newsletters and message boards.
Got a tip to share? Submit it by emailing karen@roem.co.uk - if your tip is selected, I'll publish it along with your name; the bragging rights will last a lifetime.
15 April 2013
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at http://www.roem.co.uk
__________________________________________