Tame your computer – comment combination

5 May

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 a recent 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!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: