Insert a comment

How to insert a comment using the Excel, VBA and Shortcut methods

METHOD 1. Insert a comment using cell option

EXCEL

Right-click on a cell > Click Insert Comment > Write a comment

1. Right-click on the cell where you want to insert a comment.
2. Click Insert Comment.
Note: in this example we are inserting a comment in cell B2. 		Right-click on a cell and click Insert Comment

3. Write the comment in the comment box. Write the comment

METHOD 2. Insert a comment using ribbon option

EXCEL

Select the cell > Review tab > Comments group > Click New Comment > Write a comment

1. Select the cell where you want to insert a comment.
Note: in this example we are inserting a comment in cell B2. 		Select a cell in which to insert a comment

2. Select the Review tab. Select the Review tab

3. Click New Comment in the Comments group. Click New Comment

4. Write the comment in the comment box. Write the comment

METHOD 1. Insert a comment using VBA

VBA

Sub Insert_Comment()
'add a new comment in cell ("B2") and insert "Quantity of bread left." as the comment

Worksheets("Analysis").Range("B2").AddComment "Quantity of bread left."

End Sub

OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Range: The Range object is a representation of a single cell or a range of cells in a worksheet.
PREREQUISITES
Worksheet Name: Have a worksheet named Analysis.

ADJUSTABLE PARAMETERS
Cells to insert a comment: Select the cell in which to insert a comment by changing the cell reference ("B2") in the VBA code to any cell in the worksheet.
Worksheet Selection: Select the worksheet in which you want insert a comment by changing the Analysis worksheet name, in the VBA code, to any worksheet in the workbook.
Comment: Change the comment by replacing the comment "Quantity of bread left." in the VBA code.

Insert a comment using a Shortcut

SHORTCUT

WINDOWS SHORTCUT

Shift
F2

NOTES
Select the cell in which you want to insert a comment and then action the shortcut.

Explanation about how to insert a comment

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to insert a comment using the Excel, VBA and Shortcut methods.

Excel Methods: Using Excel you can insert a comment in the selected cell with the ribbon option or a cell option.

VBA Methods: Using VBA you can insert a comment in a cell that has been specified in the VBA code.

Shortcut Methods: Using a Shortcut you can instantly insert a comment box in selected cell.