How Do I Change The Default Comment Box Size In Excel

Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an before version (Excel 2003 or earlier), this tip may non work for y'all. For a version of this tip written specifically for earlier versions of Excel, click hither: Static Sizes for Comment Boxes.

Static Sizes for Comment Boxes

Jean-Marc is having a problem with annotate boxes in his workbooks. Information technology seems that every fourth dimension he opens an Excel workbook in which he previously inserted comments, those comments take changed size. For example, if he inserts a 2" past ii" comment (or places a picture within a comment box), the next time he opens the workbook merely one-half the picture shows in a much larger comment box. Jean-Marc is wondering if there is a mode to make the comment boxes retain the same size as he originally sets them.

The solution seems to be related to how the annotate is created. How you lot view comments is controlled past three option buttons in the Display group of the Advanced option of the Excel Options dialog box. If you lot choose to view Comments & Indicators, so the sizes of your comments should remain static. If you cull to view only the indicators, then Excel chooses how and where to display the comment each time information technology is redisplayed.

If you don't want your comments to e'er be visible, but yous nonetheless want them to retain their sizes, so the just 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 (9424) applies to Microsoft Excel 2007, 2010, and 2013. You lot tin can detect a version of this tip for the older carte du jour interface of Excel here: Static Sizes for Comment Boxes.

Writer Bio

With more l non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a reckoner and publishing services visitor. Acquire more about Allen...

More FROM ALLEN

Irresolute Dialog Box Pull-Down Listing Detail Order

When selecting options inside menus, Give-and-take often displays boosted options in dialog boxes. While customizing the ...

Detect More

Adjusting Infinite Before

If you demand to conform the space that appears before a paragraph, there are several means you can approach the adjustment. ...

Discover More than

Adjusting Row Height for a Number of Worksheets

Adjusting the top of a row or range of rows is relatively easy in Excel. How practice you arrange the elevation of those same ...

Notice More than

More ExcelTips (ribbon)

Copying Comments to Cells

Need to copy whatever is in a annotate into a prison cell on your worksheet? If yous have lots of comments, manually doing this ...

Observe More

Locking the Size of Pictures in Comments

Excel allows you lot to place pictures inside of comments. If yous exercise this, you may take experienced a situation where the ...

Observe More

Irresolute Annotate Color for a Single User

The default color used to format comments is determined by Windows, non Excel. You tin adapt the formatting of ...

Observe More

Source: https://excelribbon.tips.net/T009424_Static_Sizes_for_Comment_Boxes.html

Posted by: baileypludenis.blogspot.com

Share this post