How to Unmerge Cells in Google Sheets

Merging cells in a spreadsheet is useful when you are formatting data and have a section where you need to display information across many cells. But it can also cause a bit of a headache when you are sorting and moving data, and you may find yourself with some merged cells that no longer need […]

How to Make Cells Red if a Number is Less Than Zero in Google Sheets

In Microsoft Excel there is a number formatting option where you can have Excel automatically change the color of a number to red if the value of that number is less than zero. This is very helpful for many situations where you might use Excel, so if you are formatting a spreadsheet in Google Sheets, […]

How to Stop Freezing Rows in Google Sheets

Many of the issues that you might encounter when working with a spreadsheet may not actually have anything to do with the data in your cells. After you’ve gone through the trouble of generating your data and created all your formulas and charts, you may find that you’re having trouble simply navigating through all of […]

How to Download a Graph or Chart as a Picture from Google Sheets

Creating charts or graphs from your data in Google Sheets provides you with an effective way to display information to your audience. The actual process of creating that chart can be quite simple, so once you have added all of your data to your spreadsheet, you don’t need to fret about a complicated additional task. […]

How to Delete a Graph or Chart from Google Sheets

Google Sheets is a great alternative to Microsoft Excel, and provides you with many of the tools that make Excel such an appealing application. One of these tools allows you to create a graph or chart to provide a visual representation of your data. But you may find that the chart or graph you create […]

3 Ways to Create a New Worksheet in Google Sheets

When you create a new workbook file in Google Sheets it will have one worksheet tab by default. In many cases this is going to be fine, but some spreadsheet needs will dictate that you add more worksheets to that file. This is something that you can do in Google Sheets, and there are several […]

How to Use a Different Date Format in Google Sheets

Date formatting has long been an issue for spreadsheet users. Sometimes a spreadsheet won’t recognize an input as a date and assign it a weird number, while other times it will put the date into a format that is different than what you want to use. Fortunately you do have some control over how your […]

How to Wrap Text in Google Sheets

The steps in this guide are going to show you how to wrap text in a Google Sheets spreadsheet. There are several text-wrapping options to choose from, so you will be able to select the one appropriate to your needs. Open the Google Sheets file. Select the cell(s) for which to adjust the text wrapping […]

How to Add Color to a Column in Google Sheets

When you are creating a spreadsheet that is going to be shared with other people, it’s common to have a particular column of data that is more important than others. But if there is a sufficient amount of information in your spreadsheet, you might be concerned that the importance of that data might get lost […]

How to Change Recalculation Settings in Google Sheets

When you make a change in one of your Google Sheets spreadsheets, certain functions will recalculate so that you always have the most current information. These functions include NOW, TODAY, RAND and RANDBETWEEN. But your needs might require these items to recalculate more frequently than that, such as every hour, regardless of changes, or even […]