Then all comment boxes are automatically resized to fit their content. For auto resizing comment boxes to fit their content in active sheet, please click Kutools > More > AutoFit Comment > Active sheet.Īnd if you want to auto resize all comment boxes in the whole workbook, please click Kutools > More > AutoFit Comment > All sheets. Please do as follows.īefore applying Kutools for Excel, please download and install it firstly.ġ. You can try the AutoFit Comment utility of Kutools for Excel to automatically resize a ll comment boxes in active sheet or all sheets in Excel. Tip: This code cannot automatically resize the new comment boxes you add.Īuto-size comment box to fit its content in active sheet or all sheet And then click OK, your selected cell comment boxes have been auto-fitted to the comment contents.

Then press F5 key to execute this code, and a prompt box will appear to remind you selecting a range of cells that you want to resize the comment boxes, see screenshot:Ĥ. Set WorkRng = Application.InputBox('Range', xTitleId, WorkRng.Address, Type:=8) VBA code: Auto-size comment boxes in a range of cells Sub Fitrangecomments() If you just need to auto-size a range of cell comment boxes, you can use the following VBA code. Download and try it now! ( 30-day free trail) The Autofit Comment utility of Kutools for Excelcan help to quickly fit the size of the comment box to its content automatically in a worksheet as the below demo shown. One click to quickly fit the size of the comment box to its content automatically in Excel: Tip: This code only work in the current worksheet, and it cannot automatically resize the new comment boxes you add. Then press F5 key to run this code, and all of the comment boxes in the active worksheet have been resized to fit their contents as following screenshot shown: VBA code: Auto-size comment boxes in a worksheet Sub FitComments()įor Each xComment In ģ. Click Insert > Module, and paste the following macro in the Module window. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.Ģ. In this case, you can apply the following VBA code.ġ. In Excel, you can drag the comment box to your need size manually one by one, but if there are numerous comment boxes need to be resized, this way will be tedious and time-consuming. Is it possible to fit the size of the comment box to its content automatically?Īuto-size comment box to fit its content in a worksheetĪuto-size comment box to fit its content in a range of cellsĮasily auto-size comment box to fit its content in active sheet or all sheet with an amazing tool If you enter a lot of contents into it, some of the content will not be visible directly. When you insert comments to cells, the size of the comment box is the default. How to auto-size comment box to fit its content in Excel?

Excel for mac resize window