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

How to Publish a Google Sheets File to the Web as a PDF

Making documents publicly accessible from your Google Account is one of the simplest ways to let other people view your work. There are a couple of different ways that you can accomplish this, including an option to simply publish the document and generate a link that you can send to people. If the document that […]

How to Lock Cells in Google Sheets

Occasionally when you have a cell or range of cells in a spreadsheet it contains data or a formula that can never change. As the creator of that spreadsheet you will likely remember that you shouldn’t edit anything in those cells, but spreadsheets that are sent to or shared with others are often edited in […]

How to Make a Graph in Google Sheets

Sometimes the data that you are creating in a spreadsheet is better understood if you can create a visual representation of that data. This is often best achieved by making a graph so, if you are working on a spreadsheet, you may find yourself wondering how to make a graph in Google Sheets. Fortunately this […]

How to Create a Filter in Google Sheets

Working with spreadsheets that contain a lot of data can be cumbersome, especially when you only need to display some of the information for certain scenarios. You may have previously considered hiding or deleting some rows or columns to simplify the view, but that can be tedious. One other way to customize the data displayed […]

How to Apply a Default Layout to a Slide in Google Slides

While there are a lot of different ways that you can use presentation software like Google Slides, much of the data that you are trying to present will fall into one of a number of categories. This commonality means that many slides will wind up looking similar to slides that other people also typically use. […]

How to Change Row Height in Google Sheets

The default row height in Google Sheets is ideal for data that is in the default font size, and only takes up one row in the cell. But if you have found that the current row size is either too big or too small, then you might decide that you need to adjust the size […]