Written by Allen Wyatt (last updated October 30, 2021)
This tip applies to Excel 97, 2000, 2002, and 2003
Jean-Marc is having a problem with comment boxes in his workbooks. It seems that every time he opens an Excel workbook in which he previously inserted comments, those comments have changed size. For example, if he inserts a 2" by 2" comment (or places a picture inside a comment box), the next time he opens the workbook only half the picture shows in a much larger comment box. Jean-Marc is wondering if there is a way to make the comment boxes retain the same size as he originally sets them.
The solution seems to be related to how the comment is created. How you view comments is controlled by three option buttons on the View tab of the Options dialog box. If you choose to view Comments & Indicators, then the sizes of your comments should remain static. If you choose to view only the indicators, then Excel chooses how and where to display the comment each time it is redisplayed.
If you don't want your comments to always be visible, but you still want them to retain their sizes, then the only option is to develop a macro that will do the resizing for you.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3160) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!
If you frequently add comments to cells in a worksheet, Excel provides a variety of tools you can use to manage those ...
Discover MoreOne way that you can view comments in a worksheet is to have them appear when you hover the mouse pointer over a cell. If ...
Discover MoreOne of the pieces of information that Excel can maintain relative to a workbook is a set of comments of your choice. ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments