How Do I Change The Default Size For Notes In Excel

How to auto-size comment box to fit its content in Excel?

When yous insert comments to cells, the size of the annotate box is the default. If you enter a lot of contents into it, some of the content will not be visible direct. Is information technology possible to fit the size of the annotate box to its content automatically?

Auto-size comment box to fit its content in a worksheet
Auto-size comment box to fit its content in a range of cells
Easily auto-size comment box to fit its content in active sheet or all sheet with an amazing tool

Automobile-size annotate box to fit its content in a worksheet

In Excel, you can drag the comment box to your demand size manually one by one, just if there are numerous comment boxes need to be resized, this way will be tedious and time-consuming. In this case, you can apply the post-obit VBA lawmaking.

1. Agree downwards the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

ii. Click Insert > Module, and paste the following macro in the Module window.

VBA code: Motorcar-size annotate boxes in a worksheet

            Sub FitComments() 'Updateby20140325 Dim xComment As Comment For Each xComment In Application.ActiveSheet.Comments     xComment.Shape.TextFrame.AutoSize = True Next End Sub

iii. And so press F5 key to run this code, and all of the annotate boxes in the active worksheet have been resized to fit their contents as following screenshot shown:

doc autosize comment1

Tip: This code only work in the electric current worksheet, and it cannot automatically resize the new comment boxes y'all add.

Machine-size comment box to fit its content in a range of cells

If you only demand to auto-size a range of prison cell comment boxes, you tin use the following VBA code.

1. Hold downwardly the ALT + F11 keys, and information technology opens the Microsoft Visual Basic for Applications window.

ii. Click Insert > Module, and paste the following macro in the Module window.

VBA code: Auto-size annotate boxes in a range of cells

            Sub Fitrangecomments() 'Updateby20140325 Dim rng As Range Dim WorkRng As Range xTitleId = "KutoolsforExcel" Ready WorkRng = Application.Pick Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8) For Each rng In WorkRng     If Not rng.Comment Is Aught So         rng.Annotate.Shape.TextFrame.AutoSize = True     Stop If Next Terminate Sub

3. And so press F5 key to execute this lawmaking, and a prompt box will appear to remind you selecting a range of cells that you lot desire to resize the comment boxes, see screenshot:

doc-resize-comment-box3

4. And then click OK, your selected jail cell annotate boxes accept been machine-fitted to the annotate contents.

Tip: This lawmaking cannot automatically resize the new comment boxes y'all add.

Auto-size comment box to fit its content in agile sheet or all sheet

You tin try the AutoFit Comment utility of Kutools for Excel to automatically resize a ll comment boxes in active sheet or all sheets in Excel. Please do equally follows.

Earlier applying Kutools for Excel, please download and install information technology firstly.

1. For auto resizing comment boxes to fit their content in agile canvas, please click Kutools > More than > AutoFit Comment > Agile canvass.

And if you desire to auto resize all annotate boxes in the whole workbook, please click Kutools > More > AutoFit Comment > All sheets. See screenshot:

Then all comment boxes are automatically resized to fit their content. See screenshot:

Notes:

1. After car resizing the comment boxes, when editing the comment again, the comment box will automatically aggrandize or shrink with the content.
2. For the new comments y'all inserted, yous need to enable this AutoFit comment utility over again to resize all new inserted comment boxes.

If yous want to accept a gratuitous trial ( thirty-day) of this utility, please click to download information technology, and then go to apply the operation according above steps.

Easily auto-size comment box to fit its content

Related manufactures:

How to change the shape of annotate box in Excel?
How to change all comment formats in cells in Excel?
How to list all comments to a new worksheet or workbook in Excel?
How to insert picture or epitome in comment in Excel?

The Best Part Productivity Tools

Kutools for Excel Solves Nigh of Your Issues, and Increases Your Productivity past 80%

Reuse: Quickly insert complex formulas, charts and anything that yous have used before; Encrypt Cells with password; Create Mailing List and ship emails...
Super Formula Bar (hands edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Forestall Duplicate Cells; Compare Ranges...
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Notice in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add together Text, Remove past Position, Remove Infinite; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Avant-garde Sort past calendar month/calendar week/solar day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on central columns; Separate Information into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or arrangement. Full features 30-twenty-four hours free trial. sixty-24-hour interval coin back guarantee.

kte tab 201905

Role Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

Enable tabbed editing and reading in Give-and-take, Excel, PowerPoint , Publisher, Admission, Visio and Project.
Open up and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every mean solar day!

officetab bottom