How to Make a Row Float in Google Sheets
Google Sheets has a lot of options that can make it easier for you to enter and organize data. Some of these options don’t involve …
Google Sheets How-To Guides
Visit our collection of articles and tutorials that can help you improve your Google Sheets spreadsheets and fix problems you may be experiencing.
Not sure where to start? Check out our featured Google Sheets guides below:
- How to Wrap Text in Google Sheets – change the way that text is laid out in the cells of your spreadsheet.
- How to Subtract in Google Sheets – use a formula to subtract one cell or value from another one.
- How to Make Google Sheets Alphabetical Order – learn how to sort your spreadsheet alphabetically by one of the columns in the file.
How to Freeze Columns in Google Sheets
If you’ve worked on a big spreadsheet in Google Sheets and you needed to reference data in the first column, then you might have been …
How to Make a Header Row in Google Sheets
I use header rows in almost every spreadsheet that I create in Google Sheets. Not only does it help me to make sure that I …
How to Remove Strikethrough in Google Sheets
Some formatting options will have a minimal amount of effect on the appearance of data. For example, changing the font size or using a different …
How to Convert a Google Sheets File to a PDF
One of the best features of working with Google apps like Google Sheets is how well they work when you are doing an online collaboration. …
How to Save as a CSV from Google Sheets
The CSV file format is very versatile, and it provides a means to view and edit data in a lot of different applications. If you …
How to Subtract in Google Sheets
Spreadsheet applications like Microsoft Excel and Google Sheets are more than just a way to organize and display data. They are also powerful applications capable …
How to Create a Named Range in Google Sheets
You can create a named range in a Google spreadsheet by selecting the cells for the range, clicking the Data tab and choosing Named ranges, …
How to Make Cells Red if a Number is Less Than Zero in Google Sheets
When you are poring over a large amount of data in a spreadsheet it can be easy to miss the important values. One way that …
How to Enable Iterative Calculation in Google Sheets
Many people that use Google Sheets won’t encounter problems with the settings that it has in the default configuration. But if your spreadsheet contains a …
How to Remove Dollar Sign in Google Sheets
Once you have all of the data in your spreadsheet you might decide that it’s time to format it appropriately. Google Sheets can often do …
How to Search in Google Spreadsheet Files (An Easy 3 Step Guide)
Finding data within a large spreadsheet file can be tedious, if not impossible. Fortunately, you have some options when you are trying to figure out …
How to Download a Google Sheet as an Excel File
As a Google Apps user, it is really easy to share and collaborate on spreadsheet files with other people that also use Google Sheets. But …
How to Embed Google Sheets in WordPress
Adding media content to your website is a great way to give your readers additional information and resources. But if you are using Google Docs …
How to Insert a Picture In Google Sheets
While much of the content that you might be adding to your spreadsheets is going to be letters and numbers, you might occasionally need to …
How to View or Hide Gridlines in Google Sheets on an iPhone
Gridlines are an oddly important thing to consider when you are editing data in a spreadsheet. They can be incredibly useful in making sure that …
How to Wrap Text in Google Sheets
When you have a lot of text in one of the cells of your spreadsheet, you may find that you can’t see all of it. …
How to Remove Fill Color 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 …
How to Vertically Center Cell Data in Google Sheets
When you need to make the cells in your spreadsheet taller you will find that the data in those cells is displayed at the bottom …
How to Add Borders in Google Sheets
The Google Sheets application has a lot of different tools to customize the appearance of your cells. But perhaps one of the most useful ones …
How to Indent Text in Google Sheets
The formatting that you apply to information in a document or a spreadsheet can be just as important as the information itself. Whether this is …
How to Alphabetize on Google Sheets
There are a lot of tasks that someone might perform manually in Microsoft Excel or Google Sheets before they realize that there is a way …
How to Unmerge Cells in Google Sheets
Spreadsheet applications like Microsoft Excel and Google Sheets provide you with options to create a merged cell. This is a useful option when you need …
How to Remove Google Sheets Notes
Whether you are collaborating with a group of individuals or working on a complex spreadsheet that requires some additional details, the ability to add notes …
How to Do Google Sheets Left Align
When you start typing numbers into a cell in Google Sheets, that data will appear at the right side of the cell by default. This …
How to Hide Column in Google Sheets
Spreadsheet applications like Microsoft Excel and Google Sheets provide you with ways to format data, select how that data prints, and adjust how it looks …
How to Turn Off Google Sheets Autocomplete
Making your life more efficient is the goal of almost every electronic device that you use on a regular basis. Whether it’s your phone trying …
How to Add a Title in Google Sheets
The term “title” when working with a spreadsheet can mean the name of your workbook or the worksheet tab, or it might even be referencing …
How to Delete Multiple Rows in Google Sheets
Often you will need to delete the data in a spreadsheet. Whether that data is no longer relevant, or it is simply incorrect, it’s rare …
How to Merge Cells in Google Sheets
A standard cell layout in Google Sheets is going to include a series of rows and columns that contain one cell in each column for …
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 …
How to Print on One Page in Google Sheets
Spreadsheet applications like Google Sheets have a set amount of data that they will print on one page by default. Therefore you may run into …
How to Change Row Height in Google Sheets
Typically the rows and columns in your Google Sheets spreadsheet will automatically adjust to accommodate the data contained within them. But your spreadsheet needs may …
How to Repeat the Top Row on Every Page in Google Sheets
Have you ever viewed a printed spreadsheet and had to keep checking to see which column a cell belonged to? Use these steps to repeat …
How to Change the Width of Multiple Columns in Google Sheets
Adjusting the size of the columns and rows in a spreadsheet application, like Google Sheets, is helpful in making data easier to read. But when …
How to Insert a Column in the Google Sheets iPhone App
When working with data in a spreadsheet, it’s very common to adjust the rows or columns within that spreadsheet. We don’t always know the exact …
How to Ungroup Columns in Google Sheets
Grouping columns in spreadsheet applications like Microsoft Excel provides you with a simple method to hide and unhide large groups of data at once. A …
How to Stop Freezing Rows in Google Sheets
You can unfreeze a row in Google Sheets by selecting the View tab at the top of the window, choosing Freeze, then clicking No Rows. …
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 …
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 …
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 …
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 …
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 …
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. …
How to Publish Google Sheet to the Web as a PDF
While webmasters can create and format tables on their Web pages to display data, Google Sheets can look better, plus you can update them much …
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 …
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 …
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 …
How to Force Text to the Next Line in Google Sheets
If you type a lot of text into a cell in Google Sheets, there’s a good chance that much of it won’t be visible. While …
How to Put the Date and Time in the Header in Google Sheets
Do you print the same spreadsheet a lot, to the point where it’s becoming difficult to tell which printed copy is which? While multiple copies …