You cannot change the size of the default comment but you can use a macro to
create a comment and change its size:
Sub NewComment()
On Error Resume Next
With ActiveCell.AddComment.Shape
.Width = 100
.Height = 60
.Visible = msoTrue
.Select
End With
End Sub
