Skip to content
Solve Your Tech
Menu

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 float a row in Google Sheets

How to Make a Row Float in Google Sheets

June 29, 2023February 14, 2023 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Rows
how to freeze columns in Google Sheets

How to Freeze Columns in Google Sheets

June 15, 2023February 8, 2023 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Columns, Google Sheets How-To Guides
how to create a Google Sheets header row

How to Make a Header Row in Google Sheets

September 22, 2023January 28, 2023 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Header, Rows
how to remove strikethrough in google sheets

How to Remove Strikethrough in Google Sheets

June 20, 2023January 8, 2023 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Strikethrough
how to convert a google sheets file to a pdf

How to Convert a Google Sheets File to a PDF

August 11, 2023November 10, 2022 by Matthew Burleigh

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. …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, PDF
how to convert from google sheets to csv

How to Save as a CSV from Google Sheets

August 4, 2023November 9, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Converting, CSV, Featured Sheets, Google Sheets How-To Guides
How to Subtract in Google Sheets

How to Subtract in Google Sheets

July 18, 2023November 8, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Featured Sheets, Formulas, Google Sheets How-To Guides
how to create a named range in google sheets

How to Create a Named Range in Google Sheets

May 30, 2023November 8, 2022 by Matthew Burleigh

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, …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Worksheets
How to Make Cells Red if a Number is Less Than Zero in Google Sheets

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

July 3, 2023November 8, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Fonts, Google Sheets How-To Guides
how to turn on iterative calculations in google sheets

How to Enable Iterative Calculation in Google Sheets

July 19, 2023November 8, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Formulas, Google Sheets How-To Guides
how to remove dollar sign in google sheets

How to Remove Dollar Sign in Google Sheets

June 30, 2023November 8, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Symbols
how to search in google sheets

How to Search in Google Spreadsheet Files (An Easy 3 Step Guide)

August 29, 2023November 3, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Searching
open the google sheet to download

How to Download a Google Sheet as an Excel File

June 19, 2023October 17, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Converting, Downloads, Google Sheets How-To Guides
how to embed Google Sheets

How to Embed Google Sheets in WordPress

June 22, 2023October 17, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, WordPress
how to insert picture in google sheets

How to Insert a Picture In Google Sheets

June 21, 2023October 17, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Pictures
How to View or Hide Gridlines in Google Sheets on an iPhone

How to View or Hide Gridlines in Google Sheets on an iPhone

June 8, 2023October 17, 2022 by Matthew Burleigh

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 …

Read More

Categories Mobile Devices Tags Google Sheets How-To Guides, Lines
how to wrap text in Google Sheets

How to Wrap Text in Google Sheets

August 4, 2023October 4, 2022 by Matthew Burleigh

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. …

Read More

Categories Web Browsers and Applications Tags Alignment, Google Sheets How-To Guides
how to remove cell shading in google sheets

How to Remove Fill Color in Google Sheets

June 19, 2023October 4, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Fill Color, Google Sheets How-To Guides
how to center vertically in google sheets

How to Vertically Center Cell Data in Google Sheets

June 19, 2023September 22, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Centering, Google Sheets How-To Guides
how to add borders in google sheets

How to Add Borders in Google Sheets

July 31, 2023July 5, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Borders, Google Sheets How-To Guides
how to add indentation to cells in Google Sheets

How to Indent Text in Google Sheets

June 30, 2023March 9, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Indenting
how to alphabetize in google sheets

How to Alphabetize on Google Sheets

July 15, 2023February 18, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Columns, Google Sheets How-To Guides
How to Unmerge Cells in Google Sheets

How to Unmerge Cells in Google Sheets

July 25, 2023January 19, 2022 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Alignment, Google Sheets How-To Guides
how to clear notes in google sheets

How to Remove Google Sheets Notes

June 28, 2023November 22, 2021 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Notes
how to left align numbers in Google Sheets

How to Do Google Sheets Left Align

July 3, 2023November 15, 2021 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Alignment, Google Sheets How-To Guides
how to hide a column in google sheets

How to Hide Column in Google Sheets

July 21, 2023August 25, 2021 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Columns, Google Sheets How-To Guides
turn off autocomplete in google sheets

How to Turn Off Google Sheets Autocomplete

July 8, 2023July 27, 2021 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Utilities
how to print the document title in google sheets

How to Add a Title in Google Sheets

September 22, 2023June 7, 2021 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Header, Titles
how to delete multiple rows in google sheets

How to Delete Multiple Rows in Google Sheets

July 15, 2023May 12, 2021 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Featured Sheets, Google Sheets How-To Guides, Rows
how to merge cells in google sheets

How to Merge Cells in Google Sheets

June 30, 2023March 25, 2021 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Featured Sheets, Google Sheets How-To Guides, Worksheets
how to make a graph in google sheets

How to Make a Graph in Google Sheets

July 19, 2023February 22, 2021 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Utilities
fit spreadsheet one page printing google sheets

How to Print on One Page in Google Sheets

July 5, 2023December 23, 2020 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Printing
how to change row height in Google Sheets

How to Change Row Height in Google Sheets

June 19, 2023December 3, 2020 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Rows
how to repeat the top row on every page in google sheets

How to Repeat the Top Row on Every Page in Google Sheets

July 11, 2023November 20, 2020 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Printing, Rows
how to resize multiple columns in google sheets

How to Change the Width of Multiple Columns in Google Sheets

June 29, 2023November 20, 2020 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Columns, Featured Sheets, Google Sheets How-To Guides
how to add a column in the Google Sheets iPhone app

How to Insert a Column in the Google Sheets iPhone App

July 3, 2023August 3, 2020 by Matthew Burleigh

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 …

Read More

Categories Mobile Devices Tags Columns, Google Sheets How-To Guides, iPhone How-To Guides
how to ungroup columns in Google Sheets

How to Ungroup Columns in Google Sheets

June 30, 2023June 26, 2020 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Columns, Google Sheets How-To Guides
How to Stop Freezing Rows in Google Sheets

How to Stop Freezing Rows in Google Sheets

May 30, 2023May 8, 2019 by Matthew Burleigh

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. …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Rows, Worksheets
How to Download a Graph or Chart as a Picture from Google Sheets

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

June 23, 2023March 25, 2019 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Downloads, Google Sheets How-To Guides
How to Delete a Graph or Chart from Google Sheets

How to Delete a Graph or Chart from Google Sheets

June 30, 2023March 21, 2019 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Deleting, Google Sheets How-To Guides
3 Ways to Create a New Worksheet in Google Sheets

3 Ways to Create a New Worksheet in Google Sheets

August 22, 2023March 5, 2019 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Worksheets
How to Use a Different Date Format in Google Sheets

How to Use a Different Date Format in Google Sheets

June 24, 2023March 4, 2019 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Time
How to Add Color to a Column in Google Sheets

How to Add Color to a Column in Google Sheets

June 15, 2023February 12, 2019 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Fill Color, Google Sheets How-To Guides
How to Change Recalculation Settings in Google Sheets

How to Change Recalculation Settings in Google Sheets

August 1, 2023February 7, 2019 by Matthew Burleigh

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. …

Read More

Categories Web Browsers and Applications Tags Formulas, Google Sheets How-To Guides
How to Publish Google Sheet to the Web as a PDF

How to Publish Google Sheet to the Web as a PDF

June 27, 2023February 4, 2019 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, PDF

How to Lock Cells in Google Sheets

July 20, 2023December 12, 2018 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Worksheets
how to create a filter in google sheets

How to Create a Filter in Google Sheets

June 16, 2023August 7, 2018 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Columns, Google Sheets How-To Guides
how to apply a layout in google slides

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

September 7, 2023July 12, 2018 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Defaults, Google Sheets How-To Guides
how enable text wrapping google sheets

How to Force Text to the Next Line in Google Sheets

June 26, 2023April 19, 2018 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Breaks, Google Sheets How-To Guides
how print date and time google sheets

How to Put the Date and Time in the Header in Google Sheets

June 30, 2023April 16, 2018 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Google Sheets How-To Guides, Header
Older posts
Page1 Page2 Next →

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

  • iPhone
  • iPad
  • Apple Watch
  • Google Docs
  • Google Sheets
  • Google Slides
  • Google Chrome
  • Microsoft Excel
  • Microsoft Outlook
  • Microsoft Powerpoint
  • Microsoft Windows
  • Microsoft Word
  • Firefox
  • Photoshop
  • Gmail
  • Amazon Fire TV
  • Google Drive
  • Microsoft Edge

info@solveyourtech.com
4845290651
2138 W. Union Blvd.
#1037
Bethlehem, PA 18018
United States

  • SolveYourTech YouTube
  • SolveYourTech Facebook
  • SolveYourTech Instagram
  • SolveYourTech Twitter
  • SolveYourTech Pinterest
  • SolveYourTech LinkedIn
  • SolveYourTech TikTok
  • Newsletter
  • Affiliate Disclaimer
  • Terms of Use
  • Privacy Policy
  • Contact
  • About Us
© SolveYourTech.com 2023
  • Featured
  • Categories
    • Article Topics
    • Application Guides
    • Device Guides
    • Reviews
  • Programs
    • Excel
    • Outlook
    • Powerpoint
    • Windows
    • Word
  • Devices
    • iPhone
    • iPad
    • Apple Watch
    • Fire TV
  • Web Apps
    • Chrome
    • Docs
    • Sheets
    • Slides
  • Store