This put up describes how to autofit remark field in Excel. Whereas including a big remark in a cell in Microsoft Excel, you will have seen that solely part of it’s seen to you by default. You want to manually resize the remark field to see the remainder of the remark information. Whereas that is okay for one or two feedback, resizing every remark field when there are a variety of feedback in an Excel sheet may be tiresome and time-consuming. This put up explains how you need to use some Excel settings to mechanically resize the remark field to match your complete remark information.

How to Autofit Comment Box in Excel?

There are 2 methods in which you’ll be able to autofit the remark field in Excel:

Utilizing the Format Comment possibility
Utilizing VBA Code

Allow us to see these in element.

How to Auto Measurement Excel Comment Box to match its content material

1] Autofit Comment Box in Excel utilizing the Format Comment possibility

Proper-click on the cell which has the remark and choose the Present/Conceal Feedback possibility. This can make the remark field seen (with out mouse hover).
Take your mouse cursor wherever on the outer fringe of the remark field and right-click when the mouse pointer turns right into a ‘4 Way Arrow’ image.
Choose the Format Comment… possibility.
Within the Format Comment window, change to the Alignment tab.
Examine the Computerized dimension checkbox.
Click on on the OK button.

You’ll discover that the remark field has been resized to present your complete remark content material.

Notes:

The above methodology will auto-size the chosen remark field solely. To auto-size all remark containers in the energetic Excel sheet, use the subsequent methodology.
The primary distinction between utilizing the ‘Automatic size’ possibility and manually resizing the remark field is that the ‘Automatic size’ possibility dynamically modifications the dimensions of the remark field. So in case you’ve enabled this selection, the remark field will mechanically regulate to the brand new dimension in case you replace the remark. Whereas in case you’ve not enabled it, you should have to manually resize the remark field each time you replace the remark.

2] Autofit Comment Box in Excel utilizing VBA Code

Click on on the Developer tab.
If you happen to can’t discover the Developer tab, you may allow it in Excel. Go to File > Extra… > Choices. Choose Customise Ribbon on the left panel. Choose Primary Tabs in the dropdown on the left-hand aspect. Then choose Developer and add it to the column on the appropriate. Choose OK. You’ll now see the Develop tab in your Excel sheet.
From the choices out there in the Developer Tab, click on on Visible Fundamental on the acute left.
Then click on on Insert > Module.

Kind the next code in the code editor window that seems:

Sub FitComments()
    Dim c  As Comment
    For Every c In ActiveSheet.Feedback
        c.Form.TextFrame.AutoSize = True
    Subsequent c
Finish Sub

Run the code. This code will mechanically resize all remark containers in your Excel sheet to match their respective remark information.

The above strategies will enhance the width of the remark field to match your complete remark information in a single line if the remark doesn’t have any line breaks. So in case your remark information is longer than the width of your display, you should have to use the horizontal scroll bar on the backside of the display to see your complete remark. To resolve this challenge, you may set the peak and width of the remark field to make your complete content material seen in your PC display.

Right here’s the VBA code to repair the peak and width of the remark field in Excel:

Sub ResizeALLcomments()
    Dim c  As Object
    For Every c In ActiveSheet.Feedback
        c.Form.Width = 
        c.Form.Peak = 
    Subsequent c
Finish Sub

The above code will repair the width and top of the remark field to the user-specified values ( and ). You’ll be able to set these values in accordance to the size of your remark information. For instance, you may set the width as 200 and the peak as 100. Don’t use any quotes or unit (equivalent to cm) with the worth of width and top in this code.

This sums up how to autofit remark field in Excel. Hope you discover this handy.

Associated: How to insert an image right into a remark in Microsoft Excel.

How do I develop all feedback in Excel?

There are 2 methods to develop feedback in Excel. You’ll be able to develop feedback one after the other or develop all of the feedback in one go. To develop particular person feedback, right-click on the cell that has the remark and choose the Present/Conceal Feedback possibility. To develop all of the feedback, go to the Overview tab on high of the Excel sheet and choose the Present/Conceal Comment possibility.

How do you align a remark field in Excel?

Excel permits you to change the align remark field or format of a remark in Home windows 11/10. To format the remark textual content, choose a part of the textual content or your complete remark textual content after which right-click and choose the Format Comment possibility. Select the specified Font, Font Type, Measurement, and Results, after which click on on OK. The remark shall be formatted.

Learn Subsequent: How to add a Tooltip in Excel and Google Sheets.

Source link

How to Autofit Comment Box in Excel?