One way is to go to the Review tab and pick the Notes drop-down arrow.

Your other option is to simplyright-clickthe cell and choose “New Note.”

You’ll see your name orExcel usernamefollowed by a colon in the yellow note box.

New Notes in the Notes menu on the Review tab

Simply pop in your note and then click anywhere in the sheet to close it.

The notes you add are saved automatically.

This is your indicator that a note is attached.

Note and comment settings in Excel

Simply snag the cell or hover your cursor over it to display the note.

Select “Advanced” on the left and scroll to the Display section on the right.

You’ll see three options below For Cells With Comments, Show.

Edit Note in the Notes menu on the Review tab

Alternatively, right-hit the cell and pick “Edit Note.”

Then place your cursor inside it to make your change.

you’re able to enable a setting to keep one or more notes visible.

Show/Hide Note in the Notes menu on the Review tab

To display a single note, pick the cell and go to the Review tab.

poke the Notes drop-down menu and pick “Show/Hide Note.”

you’re able to also right-poke the cell and choose “Show/Hide Note” in the shortcut menu.

Show All Notes in the Notes menu on the Review tab

To display all notes in your sheet, pick “Show All Notes” in the drop-down menu instead.

Alternatively, right-hit the cell containing the note and pick “Delete Note.”

Convert Notes to Comments

initiate the Review tab and grab the Notes drop-down menu.

Previous Note and Next Note in the Notes menu on the Review tab

Choose “Convert to Comments.”

You’ll see a pop-up message asking you to confirm this action.

Select “Convert All Notes” to continue.

Delete in the Comment section of the ribbon

Keep this handy feature in mind!

Convert to Comments in the Notes menu on the Review tab

Convert to Comments confirmation message

Notes converted to comments in Excel