Select the shape that you want to apply to the comment box. This will enable the “Change Shape” button in the Quick Access Toolbar. Click on the border of the selected Comment. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. In the Ribbon, select “Review” –> “Edit Comment”.ģ. Auto-size comment box to fit its content in a worksheet 1. Select the cell where you have inserted the comment and that you wish to change the shape.Ģ. How to Change the Shape of Comment Box in Microsoft Excel ?.ġ. You should see the “Change Shape” button in the Quick Access toolbar. In the Excel Options dialog, choose the “Drawing Tools – Format Tab” from the “Choose commands from” dropdown box and then select “Change Shape” from the list of commands and click the “Add button” to add this to the Quick Access toolbar. Click the Quick Access toolbar dropdown list in the top bar of the Excel 2016 and select “More Command” from it.Ģ. How to Add the Change Shape Command to the Quick Access toolbar in Excel 2016 ?ġ. We need to first add the change shape command to the Quick Access toolbar in Excel 2016.Ģ.
0 Comments
Leave a Reply. |