‍

In this article, you will learn how to attach a note to a cell in Google Sheets.

‍

A note inserted in a cell is helpful to notify your collaborators of what they need to care about when they look at the cell.

‍

‍

How to add a note to a cell in Google Sheets

‍

With shortcut

‍

• Select a cell in which you want to insert a note.

‍

• Press “Shift”+”F2”, which brings up a text box.

‍

• Type texts in the text box.

‍

• Click somewhere outside of the text box.’

‍

Without shortcut -1 

‍

• Select a cell in which you want to insert a note.

‍

• Right-click → “Insert note”.

‍

• Type texts in the text box.

‍

• Click somewhere outside of the text box.

‍

‍

Without shortcut - 2

‍

• Select a cell in which you want to insert a note.

‍

• Navigate to the “Insert” tab → “Note”.

‍

• Type texts in the text box.

‍

• Click somewhere outside of the text box.

‍

‍

You see a small black triangle at the top right corner of the cell if the note is inserted successfully.

‍

   Why spend hours creating spreadsheets, when we have already done the work for you?

   100+ financial spreadsheet templates, all free and ready for you now.

   Free Spreadsheet Templates

‍

‍

How do you show a note in Google Sheets?

‍

It is very simple. The note automatically pops up when you hover or put your cursor on a cell containing a note.

‍

‍

How to edit an existing note in Google Sheets

‍

You can edit an existing note by double-clicking the cell containing the current note. If you want to expand the text box, left-click the stripe at the bottom right of the text box and drag it until you get enough space for your texts.

‍

‍

‍

How to delete a note in Google Sheets

‍

Method 1

‍

• Double-click the cell including the note you want to remove.

‍

• Delete all texts in the text box

‍

• Click somewhere outside of the text box.

‍

Method 2

‍

• Right-click on a cell with a note, which brings a pop-up menu.

‍

• Select “Delete notes“.

‍

‍

‍

What's the difference between a comment and a note in Google Sheets?

‍

A comment and a note are common because both can leave some texts in a text box. However, a comment is functionally superior to a note. The difference between a comment and a note is as follows: with a comment function, you can 

‍

• tag someone;

‍

• assign a comment as a task to someone;

‍

• tell who left the comment

‍

• save a thread in the comment history

‍

• re-open a saved conversation if necessary

‍

• reply to a comment another collaborator left; and

‍

• check previous interaction

‍

In conclusion, you can use the two functions well, depending on your purpose.

‍

‍

How do I add a comment to a cell in Google Docs?

‍

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

‍

   Learn how LiveFlow can save you hours a month on financial reporting!

   Just 30 minutes can change the way your business operates forever.

   Book a Demo