How to Add a Note in Google Sheets

Author: Iqbal | Guide: Google Sheets |

Just like comments, you can also make a note in google sheets. In fact, it is one of the most easy-to-use features of the application.

You can make a note in google sheets for various purposes. If you want to add special comments or instructions for the viewers or the contributors of the sheet. Then, we would advise you to add notes to make the sheet easier for them to understand. We hope you know that anyone can edit and format Google sheets in-app or even online. Let us now move forward with the learning process with the help of this article.

Add a Note in Google Sheets

Make a Note in Google Sheets in 6 Steps

Step-1 Open Your Google Sheet: To make a note in google sheets, you have to first open the sheet in which you want to add the particular note.

You can open the Google sheet in two ways:

  • Either download the Google Sheets app and then open the sheet in the app.
  • Or, you can also open the sheet in your web browser with the help of the link of the Google sheet.
image titled Make a Note in Google Sheets step 1

Step-2 Select The Cell to Add Note: Then in the next step, you have to simply select your cell where you want to add the note.

Selecting the cell is not a very hectic technique. Just click on the cell where you want to add your note. And, the cell would be selected with just a single click.

image titled Make a Note in Google Sheets step 2

Step-3 Click On The 'Insert' Button: On the top of your Google sheet, you will find the 'Insert' button.

You have to choose the 'Insert' Button to move forward with the next steps.

image titled Make a Note in Google Sheets step 3

Step-4 Click on 'Note': Then, a list menu of the Insert button will open up.

In this list menu, you have to scroll down until you see the option that says 'Note'. Then, click on this 'Note' option now.

image titled Make a Note in Google Sheets step 4

Step-5 Type Out Your Note: A special Note window will appear on your Google sheets screen.

  • Click on the Note window that appears.
  • Then, type the Note that you want to add in the cell.
image titled Make a Note in Google Sheets step  4

Step-6 The Note Is Now Added: After clicking on 'Enter', your note will be added to the cell that you have chosen previously.

  • A small upward pointing arrow will appear on the top right corner of your cell.
  • You can look at the picture below for reference. You can see your note by clicking on this arrow.
image titled Make a Note in Google Sheets step 5
 

FAQ

How Can I Show Notes in Google Sheets?

There are two ways in which you can see or show the notes in your Google spreadsheet. These two ways are:

  • You can either hover over the cell in your Google sheet in which the comment. It will show you the comment then.
  • Or, you can click on the cell to open or close the comment.

You can also download this file in MS Excel format.

How Can I Make/Add Notes on Google Docs?

Just like the Google Sheets app, you can also add notes to your files and documents with the help of the Google Docs application.

We have mentioned the steps for your understanding below:

  • On your device, first, open your word document or text file in the Google Docs application.
  • Then, from the right side, you have chosen the 'Keep' option.
  • From the side panel on the right, you have to find the note you want to add. Or, you can also type your note here.
  • Finally, click and drag your note to your document to add it.

Is It Possible To Use Sticky Notes in Google Docs?

Google Docs does not have any in-built feature to add sticky notes to your documents. But still, it lets to add them anyways.

It is not an easy process. Therefore, carefully read the steps given below to learn them:

  • First of all, open any sticky notes app on your device.
  • Now, you can now write out your ideas on sticky notes.
  • Then, save it.
  • Install the 'Post-It' mobile app.
  • The post-it app will let you capture those sticky notes in digital form or in the form of a photo.
  • Then, you can simply add the sticky note as a photo to your documents.

 

 

 

 

 

Another Method

You can make a note in Google Sheets just like you used to add sticky notes in your books. It helps in giving certain specific information. Have you ever left a note on the fridge or table for others at your home to instruct or remind them of something? Or just a grocery shopping list so that you don't forget to buy anything? Well, notes do the same thing in Google Sheets. But what about adding comments then? Notes and Comments both have different purposes. But first, let us learn how to make a note.

Add a Note in Google Sheets: 4 Steps

Step-1 Open Google Sheets App: On your mobile device, look for the icon of google sheets. It looks like an A4-size green sheet of paper having a little fold on the top-right corner. It has white outlined cells over it.

  • If you cannot find it, download it from the play store.
  • Type 'Google Sheets' in the search bar.
  • After that, look for the described icon.
  • Once you find it, install it and open it.

Step-2 Tap on The Cell: On opening the google sheets application, you will see a list of your created and shared documents. Select the sheet you want to work on.

  • To make a note in Google Sheets, select the cell for which you want to add a note.
  • The selected cell must be highlighted with blue outlines around it.

image titled Make a Note in Google Sheets step 2

Step-3 Long Press and Three-Dot Icon: You will have to long press the cell of your choice. By doing so, a floating menu will open up above the cell.

  • In that menu, you will see a three-dot option at the far right end of it.
  • If the cell has any textual or numerical value, you will see the three-dot option
  • If the cell does not contain any value, you will directly see the option of Note at the far right.

image titled Make a Note in Google Sheets step 3

Step-4 Click on Note: Whatever the case as described above, you have to look for the option reading 'Note.' By clicking it, you see a little textbox in front of you.

  • Add the instruction, information, reminder, or whatever that you want to add as a note.
  • Click on OK and thus, this is how you make a note in Google Sheets.

image titled Make a Note in Google Sheets step 4

Now you might wonder what is the use of adding notes. Isn't it just like adding comments in google sheets? Well, technically, they might seem one and the same. But their utility makes a difference. A note is a simple reminder, that is mostly personal in Google Sheets. However, comments are more for shared google sheets with others. 

  • In comments, you can tag a specific person, talk in the same comment's text box, respond to each other, give feedback, and so on.
  • So, comments are more interactive, and a teamwork thing.
  • Notes are usually for one's own understanding.
  • You can add a note in an attendance sheet to signify that a specific student remains absent a lot and you need to check on him.

Thus, like this, there can be several other personal uses for using notes in Google Sheets. It can even be used in shared documents when you don't require any response from others and just need to inform or instruct.

Was this article helpful ?

No