How do I change the default size of a comment box in Excel? To change the default size of a comment box in Excel, select the cell where the comment has been placed.

When you try to edit a legend using the Format Legend dialog box, Excel lets you change the legend's color, border and shadow, along with several other stylistic elements.