Topic: Comments

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Adding a Comment to Multiple Cells Adding a comment to a single cell is easy. What if you want to add the same comment to multiple cells, however? Here are some ideas on how you can accomplish this task. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Anchoring Comment Boxes in Desired Locations Comment boxes, when they pop up, always do so to the right of the column in which the comment appears. This can cause problems for some worksheet layouts, however. If you want more control over where comment boxes appear, you’ll appreciate the information in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Comments Don't Appear when Cell is Pointed To By default, comments associated with a particular cell should appear on-screen when you move the mouse pointer over that cell. If they don’t, then there may be a setting amiss or a more esoteric problem. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Copying Comments to Cells Need to copy whatever is in a comment into a cell on your worksheet? If you have lots of comments, manually doing this can be tedious. Here is a macro solution that will make quick work of the copying. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Copying Comments when Filtering The advanced filtering feature in Excel allows you to quickly copy unique information from one data list to another. If you want to copy the comments associated with that information, you are out of luck; advanced filtering won’t do it. There are workarounds you can use to get the same result, however. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Editing a Comment Close to Its Cell Have you ever tried to edit your comments, only to find that Excel displays them some distance from the cell to which they are attached? This happens more often than you might think. This tip explores some of the possible causes and provides some ideas on how you can fix the problem. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Editing Comments Once you’ve added a comment to a cell, you may want to later go back and make changes to it. This tip explains a few different ways you can make those changes. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Filtering for Comments Excel makes it easy to filter a data table based on various values in that table. It isn’t so easy to filter according to whether a cell contains comments or not. Here’s a few ways you can make the filtering easier. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Finding and Replacing Text in Comments Excel allows you to add comments to individual cells in your workbook. Unfortunately, Excel doesn’t provide a way to search and replace text in those comments. You can do it with a macro, however. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Formatting Text in Comment Boxes If you add comments to a worksheet, you might want to format the text contained in those comments. Excel doesn’t provide a lot of formatting capability for comment text, but the techniques discussed in this tip can help accomplish your designs. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Linking Comments to Multiple Cells In Excel, single comments are associated with single cells. If you want to have a comment be linked to multiple cells, you’ll need to use the workaround discussed here. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Managing Comments Using the Reviewing toolbar, you can easily manage the comments in a worksheet. This tip explains what comment-related tools the toolbar contains. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Pasting a Comment into Your Worksheet Excel allows you to not only put information into cells, but into comments attached to those cells. Here’s how to copy the information from a comment into a cell, using techniques you are already familiar with. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Placing Formula Answers in a Comment Excel won’t allow you to directly or automatically insert the results of a formula into a cell’s comment. You can, however, use a macro to place that result exactly where you want it. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Printing Comments Excel allows you to add comments to cells. At some point you may want to print out those comments, along with your worksheet. Doing so is easy, provided you know the setting to change. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Static Sizes for Comment Boxes Comment boxes can be resized as you like, but those sizes may not “stick” in Excel. This tip explains when they should stick and when they won’t. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Viewing Comments Comments can be added to individual cells in a worksheet. Excel provides several different ways you can view those comments. This tip discusses the methods and the provides the information you need to pick the best viewing method for your purposes. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tips, Tricks, and Answers

Macros 'Power Up' Excel!

Helpful Links

Great Info!

RSS Feeds