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 […]

How to Enable Change Notifications in Google Sheets

Do you have a spreadsheet on which you are collaborating with a team of people, and you would like to know whenever someone makes a change, like merging some cells? If you are currently opening the sheet repeatedly throughout the day to see what is different, then you might benefit from using the notification rules […]

How to Remove Cell Shading in Google Sheets

Cell shading is an effective way to draw attention to data in your spreadsheet without having to modify the actual data itself. But you may have a cell to which you have previously applied a fill color, only to find that the data has changes, or that the formatting of the document dictates the removal […]

How to Insert a Column in Google Sheets

When you start creating a spreadsheet from scratch, you may have a good idea what the final layout of that spreadsheet will entail. In the case of smaller and simpler sheets, there might only be a few columns of data to work with, making it unlikely that something new will arise which dictates the addition […]

How to Delete Non-Contiguous Rows in a Google Sheets Spreadsheet

You may already be familiar with how to delete a row in Google Sheets, as it is a useful way to fix a problem that is very common when editing spreadsheets. While deleting a single row in this manner isn’t particularly time-consuming or inefficient, it can become so if you need to delete a lot […]

How to Delete a Column in Google Sheets

Deleting and editing data in a cell in Google Sheets is often as simple as clicking on a cell and typing the new information that you want to appear in that cell. While this is effective when you need to modify individual cells, however, it is less effective when you have an entire column of […]

How to Clear Formatting in Google Sheets

There is a large assortment of formatting options that you can apply to a cell in Google Sheets. Some of these formatting options are easy to find and edit, but others may be a little tougher to track down. If you discover that there is a lot of formatting options applied to a cell and […]

How to Print Gridlines in Google Sheets

Gridlines in a spreadsheet are important for providing visual representation of the boundaries of a cell. It makes it easier to tell which characters belong to which cell. And while this is important when you are editing a spreadsheet in Google Sheets on your computer, it is just as important when someone is reading the […]

How to Delete a Row in Google Sheets

Does your Google Sheets spreadsheet have rows that you don’t need or want? Empty rows, or incorrect data, can be a problem for any spreadsheet, so you might be looking for a way to quickly delete rows that aren’t necessary. Fortunately Google sheets lets you delete rows in a manner similar to how you would […]

How to Show Formulas in Google Sheets

The beauty of formulas in spreadsheets is their ability to perform calculations for you. Often this occurs with the help of a mathematical operator in combination with a cell location. In most cases the most important part of this scenario is the value that the formula produces, but you might find yourself needing to know […]