To change the default size of a comment box in Excel, select the cell where the comment has been placed. Then right-click and choose Show/ Hide Comments. Click anywhere on the edge of the comment box. Now take the mouse pointer over the little square that appears in the lower-right corner of the comment box.