How to Add a Note in Google Sheets

Video google sheet notes

In this article, I’ll show you how to attach a note to a cell in Google Sheets. But why would you want to add a note to a cell? Well, sometimes it’s useful to notify your collaborators about something they should consider when looking at a specific cell. Keep reading to discover how to do this easily.

How to Add a Note to a Cell in Google Sheets

Using a Keyboard Shortcut

  1. Select the cell where you want to insert a note.
  2. Press “Shift” + “F2” to bring up a text box.
  3. Enter your note in the text box.
  4. Click outside the text box.

Without a Keyboard Shortcut – Method 1

  1. Select the cell where you want to insert a note.
  2. Right-click and select “Insert note.”
  3. Enter your note in the text box.
  4. Click outside the text box.

Insert note without a shortcut in Google Sheets

Without a Keyboard Shortcut – Method 2

  1. Select the cell where you want to insert a note.
  2. Go to the “Insert” tab and select “Note.”
  3. Enter your note in the text box.
  4. Click outside the text box.

Once the note is successfully inserted, you will see a small black triangle in the upper-right corner of the cell.

How to View a Note in Google Sheets

It’s very simple. The note will automatically appear when you hover or place your cursor on a cell that contains a note.

How to Edit an Existing Note in Google Sheets

You can edit an existing note by double-clicking on the cell that contains the current note. If you want to enlarge the text box, click on the bottom right bar of the text box and drag it until you have enough space for your notes.

How to enlarge a text box for a note in Google Sheets

How to Delete a Note in Google Sheets

Method 1

  1. Double-click on the cell that contains the note you want to delete.
  2. Delete all the text in the text box.
  3. Click outside the text box.

Method 2

  1. Right-click on a cell that contains a note.
  2. Select “Delete note” from the context menu.

How to delete a note in a cell in Google Sheets

What’s the Difference Between a Comment and a Note in Google Sheets?

Comments and notes are similar because they both allow you to leave information in a text box. However, comments offer more advanced features. Here are the differences:

  • Comments allow you to tag someone.
  • Comments can be assigned as a task.
  • Comments indicate who left them.
  • Conversations in comments can be saved and reopened.
  • Collaborators can reply to a comment.
  • Comments allow you to check previous interactions.

In conclusion, you can use these two features according to your objective.

How to Add a Comment to a Cell in Google Sheets

Check out this article to learn how to attach a comment to a cell in Google Sheets.

Related posts