How to write notes, comments on Google Sheets
Similar to when creating annotations on Excel, Google Sheets now also supports users to write notes, comment to each data box. This note function adds a note to each data box on Google Sheets, allowing users to add any necessary information to their spreadsheet.
Especially with the group of people who work online with data sheets on Google Sheets, this note-taking feature helps team members to easily track group activity, even creating conversations to track public the work of each person.
Step 1:
Sign in to Google Sheets to open the content of the data sheet you want to annotate. Select the data box to add comments and comments on Google Sheets.
Then, right-click the box and select Insert Comment if you want to add a comment. In addition, users can also click on Insert Note to add a note to this data box.
Step 2:
A small dialog box appears to enter a comment for the data box. This data sheet will appear the name of the user. We just need to enter a comment and then click Comment to complete.
In case you click Insert note to add a note, we also enter the note in the small frame and then click to another box is okay.
Step 3:
In case you want to review all the existing comments on Google Sheets , click on the Comments button at the top of the right interface, under your account address. Soon a list of comments added in the data file will appear.
Click the Comments button again to close the comment list box.
Step 4:
If we want to delete the comment added to the data box, also click on the Comments button above. In the comment list appears the comment you want to delete, then click on the arrow icon.
Select the Delete option to delete this comment. If you want to reply to a comment, click Reply.
So you can note and comment on any data sheet on Google Sheets. When working online and working with groups of people, these comments will be fully displayed so we can follow them, and there are additional options such as hiding comments, replying to comments or deleting comments on Google. Sheets.
I wish you all success!
You should read it
- How to align spreadsheets before printing on Google Sheets
- How to enter 0 in Google Sheets
- How to create a phone number can be called on Google Sheets
- 6 useful functions in Google Sheets you may not know yet
- 5 Google Sheets features you should know
- How to view editing history on Google Sheets
- How to fix Google Sheets not allowing scrolling
- How to count words on Google Sheets
May be interested
- How to use comments, notes (comments) in Wordthe comment function in word helps you create notes for lines or paragraphs in word documents. you can note any line or paragraph when necessary. the following article shows how to use the comment (note) function in word.
- How to enter 0 in Google Sheetsnormally when entering 0 on google sheets, it will automatically disappear if that 0 is in front of the number line. so how to re-display 0 in google sheets.
- How to create a phone number can be called on Google Sheetsgoogle sheets has a call feature when entering phone numbers into data tables, via callers installed on the computer.
- How to view editing history on Google Sheetsgoogle sheets will automatically save the content edits on the file so that users can review it when needed, or restore the modified version.
- 6 useful functions in Google Sheets you may not know yetin this article, i will show you 6 useful functions for the google sheets spreadsheet that you should know such as vlookup, countif, sumif, join, index, ... in addition, you can refer to the functions. and other tips follow the link in the post.
- How to fix Google Sheets not allowing scrollinggoogle sheets is a free and easy to use spreadsheet application that works right out of the box. however, sometimes users face some glitches.
- How to count words on Google Sheetson google sheets, to count the number of words in each cell, users can use the formula with the counta function.
- How to write notes on Facebookthe function of writing notes on facebook helps users to freely write confidences, experiences, ... and share them with everyone. if you are familiar with blogs, the facebook note-writing feature is quite similar.
- How to set up the right to edit spreadsheets on Google Sheetswhen working on google sheets online, if you want to restrict editing of certain column or row data areas, you can set editing rights on google sheets.
- How to insert checkboxes on Google Sheetsadding checkboxes to optional list data on google sheets makes it easier for users to manage content.