Topic: Comments

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

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 Do you want to extract text from a bunch of comments and enter the text into worksheet cells? Excel has no intrinsic way of doing this, but you can use a macro to make short work of the task. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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

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 Do you need a comment to apply to more than one cell? Built-in comments are only applicable to a single cell, but you can create a workaround that uses text boxes, if desired. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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

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