How to Clear All Notes in Google Sheets

Sometimes the information in a cell in your spreadsheet requires some extra explanation. There are a couple of different approaches that you can use to convey that information, but one of the options in Google Sheets is to add notes to cells. These notes are then indicated by a small black triangle at the upper-right corner of the cell.

But those notes might only be necessary for you or your team, and you might want to get rid of them before distributing your spreadsheet to others. Fortunately you can quickly remove all of the notes from your spreadsheet in Google Sheets by following our guide below.

See also

How to Remove All of the Notes from a Spreadsheet in Google Sheets

The steps in this article were performed in Google Chrome, for the Web browser version of Google Sheets. Following this tutorial will cause all of the notes in the cells in your worksheet to be cleared. If you would prefer to clear notes from a smaller selection, then you will need to individually select those cells (by holding down the Ctrl key on your keyboard as you click them).

Step 1: Go to your Google Drive at and open the spreadsheet from which you would like to clear the notes.

Step 2: Click the gray box to the left of the column A heading and above the row 1 heading. This selects the entire sheet. As mentioned earlier, you can select smaller groups of cells instead if you only want to clear notes from some of your cells.

select all of the cells in your spreadsheet

Step 3: Click the Edit tab at the top of the window.

click the edit tab at the top of the window

Step 4: Select the Clear notes option at the bottom of this menu.

how to clear notes in google sheets

Do you have a bunch of cells in your spreadsheet that have different formatting, and you would like to normalize it? Learn how to clear formatting in Google Sheets so that you don’t need to individually adjust format settings. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.