Resize Comment Contract For Free

If you want to resize a comment box, move the mouse pointer to one of the sizing handles on the corners or sides until it turns into a plus sign with arrows. Then, click and drag one of the handles to resize the comment box to your preferred size.

5. Ctrl+Shift+R: This shortcut will open the Resize Comment dialog box. From here, you can change the size of the comment box.

If you need to discuss data with other people, then use a comment. Notes (formerly called "comments" in earlier versions of Excel) don't have a Reply box. Notes are just for adding annotations or reminders in cells. If you don't need to have a discussion about the data, then use a note.

If you want to resize a comment box, move the mouse pointer to one of the sizing handles on the corners or sides until it turns into a plus sign with arrows. Then, click and drag one of the handles to resize the comment box to your preferred size.

An easy way to remember this keyboard shortcut; the F2 key edits the cells content, whereas Shift-F2 edits the cells comment.

To display an individual comment, right-click on the cell, and select Show/Hide Comments. To display all comments in the worksheet, go to the Review tab > Show all Comments.

If you just need to auto-size a range of cell comment boxes, you can use the following VBA code. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. Click Insert > Module, and paste the following macro in the Module window.

Line comments are your standard ctrl + / on Windows/Linux or cmnd + / on OSX. In languages where there are more than one type of comment, like JavaScript and most preprocessors, line comments only comment out a single line.