How To Edit Comment To Cell In A Template Excel

Comments are quite useful when you desire to add some information about a cell/data point without changing the content of the cell.

I often use these when I am using formulas and I need to specify what a formula does and what a cell value means. If you're collaborating with others, yous can also add comments for other people's reference.

In this tutorial, I will show you all you need to know about comments – including how to insert comments in Excel, how to edit/delete comments, how to delete comments from the entire sail or workbook, etc.

But before I get alee and evidence y'all how to insert comments in Excel (or delete/edit comments), in that location is something important you need to know.

In Function-365, Microsoft has renamed the Annotate functionality as Notes. And so the traditional comments that y'all know (ane that shows a yellow box and small ruby-red triangle in the prison cell at pinnacle-right) are at present called Notes. And comments at present refer to a new feature that allows y'all to create threaded conversations. Here is an article about the difference between notes and comments

Bottom line – If you're NOT using Office 365, you don't need to worry virtually anything and a annotate remains unchanged. If you lot're using Role 365, comments are now referred to as Notes

How to Insert Comments in Excel (Shortcut)
Show All Comments/Notes
Navigate Through Comments (Previous/Next)
Re-create Comments
Delete Comments
- Delete Comments from a Selected Range or the Entire Worksheet
- Delete Comments from All the Worksheets at One Get
Copy All Comments In a Separate Worksheet
Convert Notes to Comments (Role 365 Simply)

How to Insert Comments in Excel (Shortcut)

If you want to insert a annotate in a prison cell in Excel, you can apply the below keyboard shortcut:

          SHIFT + F2          in Windows

and

          Command + F2          in Mac

Here is how to utilize this shortcut to insert a comment:

Select a cell where y'all want to insert a comment
Agree the Shift Central (or Control key if using Mac)
Printing the F2 key

The above steps would instantly add a annotate to the selected cell.

Now, you tin enter any text that you lot want in the annotate and and so hitting the Escape cardinal or click anywhere in the worksheet to brand that comment save in the cell.

In example yous select a range of cells and use the above shortcut, it would insert a annotate in the active cell just.

In case you don't prefer the shortcut method, beneath is another method to add together a annotate:

Correct-click on the cell in which you desire to add the comment
Click on New Comment (or New Note in instance you're using Office 365)

Show All Comments/Notes

If you desire all the comments to expand and show the text in it, you lot can do that easily with a single click:

Go to the Review tab
In the Comments group, click on Prove All comments

This will instantly evidence all the comments on the worksheet.

This works like a toggle button. And then if you lot click on information technology once more, it volition hide all the comments in the worksheet.

In case you're using Part 365, you lot need to click on the Notes choice so click on Show All Notes

Navigate Through Comments (Previous/Next)

If you desire to go through each comment ane past one, y'all can do that equally well. This tin can be useful when y'all accept a lot of comments and you desire to make certain you don't miss any while going through these comments.

Below are the steps to get through comments i past one:

Click the Review tab
In the Comments group, click on the Side by side pick to get to the Side by side comment (and Previous to go to the previous comment).

When you lot are navigating through these comments, only the comment that is active will be shown. The balance volition be subconscious. When you click on Next, it takes you to the next annotate and hides all the other comments.

If you lot're using Role 365 (where comments are now called Notes), you need to click on the Review tab, then click on the Notes choice and so click on the Next/Previous Annotation options. This has been made a bit hard if you lot have to utilise this choice a lot (every bit it now takes more clicks). One way to deal this could be to add the Next/Previous notes choice to the QAT (this option comes when you lot correct-click on the Next/Previous Note options).

Copy Comments

When you exercise a elementary re-create-paste, it will copy everything including the values, formulas, formatting and comments. So if you desire to copy-paste everything, all you need is the regular Control-C and Control-5

But what if yous only need to copy the comments (and goose egg else).

Excel allows y'all to exercise this using the Paste Special options.

Below are the steps to re-create and paste comments only in Excel:

Select all the cells that take the comments that yous want to re-create
Correct-click on whatsoever cell in the selection and and so click on Copy (or use Command + C keyboard shortcut)
Go to the cell where yous want to paste the comments.
Right-click and select Paste Special.
In the Paste Special dialog box, click on Comments (information technology will be 'Comments and Notes' if you're using Office 365)
Click OK

The above steps would only paste the comments and not the values/formatting/formulas.

This can be a useful thing when you lot accept two versions of the same file with different comments. You tin copy and paste all the comments in the latest version to make sure you've everything in ane place.

Delete Comments

There are different methods yous can utilize to Delete comments in Excel. The method y'all choose will depend on what comments you want to delete.

For example, if you only want to delete comments in a choice or from the entire worksheet, you lot tin use the like shooting fish in a barrel fashion – shortcut or option in the ribbon.

But if you want to delete comments from all the worksheets at one get, yous need to use VBA.

Let'south see both of these scenarios.

Delete Comments from a Selected Range or the Entire Worksheet

This ane is simple.

To delete all comments in a option, follow the beneath steps:

Right-click anywhere in the option
Click on Delete Comment (or 'Delete Note' if you're using Function 365)

In case you desire to remove comments from the entire worksheet, follow the below steps:

Click on the greyness triangle at the top-left of the Excel awarding. This will select the entire worksheet (or you tin can utilize Control + A + A)
Click the Dwelling tab
In the Editing group, click on Articulate
Click on Articulate Comments

The in a higher place steps would remove all the comments in the worksheet.

Annotation that when yous select the entire worksheet and and then right-click on whatever cell, you won't get the option to delete all the comments (or notes)

Delete Comments from All the Worksheets at One Go

Deleting comments from the entire workbook is a bit tricky. Y'all tin can become to each sheet and delete all the comments in each canvas, but this can become tedious if yous have a lot of sheets in the workbook.

A simple VBA code, in this instance, can do all the heavy lifting.

Below is the code that will become to each sail in the workbook and delete comments from the entire canvas:

For each ws in Worksheets: ws.cells.ClearComments: Next ws

The higher up lawmaking uses the For Each Adjacent loop to become through each worksheet in the workbook. And for each sheet, it uses the ClearComments method to remove all the comments at one go.

Since Microsoft has renamed comments to notes in Function 365, in hereafter, the higher up code may delete comments (new feature in O365) and you may accept to use the below lawmaking to delete notes (the comments in prior versions)

For each ws in Worksheets: ws.cells.ClearNotes: Next ws

As of now, both of these codes work and delete comments from the specified cells.

Now, allow me evidence y'all how to utilise this code.

Right-click on whatever canvass tab
Click on View code. This will open the VB Editor (y'all tin can also open the keyboard shortcut ALT + F11)
In the VB Editor, if you don't see the immediate window, click on the View choice in the menu and then click on Immediate window
Copy and Paste the to a higher place VBA macro code into the immediate window.
Place the cursor at the terminate of the line in the immediate window
Hit the Enter fundamental

The in a higher place steps will delete all the comments in the entire workbook.

Copy All Comments In a Separate Worksheet

It would be great to have a list of all the comments and all the text within each annotate every bit a list in the worksheet. This will brand it easy to go through the comments one by one (instead of navigating and jumping across cells in the canvass).

While this tin can not be done with an in-built feature, yous can get this done using VBA.

Hither is a detailed tutorial that shows how to get a list of all the comments in a separate worksheet.

Convert Notes to Comments (Function 365 Merely)

This feature is only available to the users of Office 365.

Since in that location are two types of comments now – comments and notes, information technology allows yous to alter notes to comments (not vice-versa).

So if you have traditional comments (now called notes in O365), you can hands convert these to comments using the below steps:

Click the Review tab
Click on the Notes option
Click on Convert to Comments
In the dialog box that opens, click on 'Convert All Notes'

The above steps would convert all the comments into Notes.

Notation that if you lot have any formatting or images in the comments, it would exist removed automatically.

Besides, y'all tin can not choose to catechumen some of the notes to comments and exit others as is. The above steps would change all the notes to comments in the entire worksheet.

And so this is all that there is to know about inserting and deleting comments in Excel.