Skip to content
Live2Tech
Menu

Google Sheets

How-to guides and tutorials to help you perform specific tasks and use the Google Sheets spreadsheet application.

how to save a Google Sheets file as a CSV

How to Save a Google Sheets File as a CSV

Last Updated On May 6, 2023 by Kermit Matthews

The CSV file type might seem somewhat basic when you are dealing with a spreadsheet, but it’s a very versatile file type that works with …

Read More

Categories Google Sheets Tags Files
how change slide dimensions google slides

How to Change Slide Dimensions in Google Slides

Last Updated On May 12, 2023 by Kermit Matthews

Your Google Slides dimensions can be a pretty important part of your presentation when you want to print it. The standard size of a Google …

Read More

Categories Google Sheets
why google sheets toolbar missing 1 Why Is My Google Sheets Toolbar Missing?

Why Is My Google Sheets Toolbar Missing?

Last Updated On May 5, 2023 by Kermit Matthews

Are you trying to make some edits to a spreadsheet that you have in Google Sheets, but you either don’t see the menus at the …

Read More

Categories Google Sheets
how to lock a row in Google Sheets

How to Lock a Row in Google Sheets

Last Updated On May 14, 2023 by Kermit Matthews

There are some things you can do with your spreadsheets that make them easier for others to read, but also easier for you to edit. …

Read More

Categories Google Sheets Tags Featured Sheets Guides, Rows
how to resize multiple columns in Google Sheets

How to Make All Columns Same Width – Google Sheets

Last Updated On April 30, 2023 by Kermit Matthews

Blank spreadsheets in Google Sheets have a default column width of 100 pixels. But as you start adding data to those cells and adjusting their …

Read More

Categories Google Sheets
how to print the workbook title in google sheets

How to Make a Title in Google Sheets (An Easy 5 Step Guide)

Last Updated On May 11, 2023 by Kermit Matthews

While you may have already figured out how to give your Sheets file a name by changing it in Google drive or at the top …

Read More

Categories Google Sheets
how restore version history google sheets 5 Google Sheets Restore Version Guide (Just 6 Easy Steps!)

Google Sheets Restore Version Guide (Just 6 Easy Steps!)

Last Updated On May 3, 2023 by Kermit Matthews

While you can fix a lot of problems on a computer with the “Undo” option, you might not realize that a mistake has been made …

Read More

Categories Google Sheets
how insert image cell google sheets 3 How to Lock an Image in Google Sheets (An Easy 5 Step Guide)

How to Lock an Image in Google Sheets (An Easy 5 Step Guide)

Last Updated On May 2, 2023 by Kermit Matthews

If you’ve ever had a picture in a cell in a spreadsheet and had it not move when you were adjusting your layout, then you …

Read More

Categories Google Sheets
how to print with gridlines in google sheets

How to Print Gridlines in Google Sheets

Last Updated On April 30, 2023 by Kermit Matthews

Gridlines are a crucial part of many spreadsheets in applications like Microsoft Excel and Google Sheets. They can make data easier to understand, so you …

Read More

Categories Google Sheets
how to set row height google sheets 3 How to Set Google Sheet Row Height

How to Set Google Sheet Row Height

Last Updated On May 13, 2023 by Kermit Matthews

While the default height of your rows and your cells in Google Sheets are ideal for single lines of data, you may be adding a …

Read More

Categories Google Sheets Tags Featured Sheets Guides, Rows
how to disable autocomplete in google sheets

How to Turn Off Autocomplete in Google Sheets

Last Updated On May 11, 2023 by Kermit Matthews

If you’ve ever been typing in an application like Google Docs or Google Sheets and had it offer suggestions or fill in information, then you …

Read More

Categories Google Sheets
print entire google sheets workbook

How to Print Your Entire Workbook in Google Sheets

Last Updated On April 27, 2023 by Kermit Matthews

When you print in a spreadsheet application like Google Sheets or Microsoft Excel you may have more experience printing individual worksheets. Since configuring a spreadsheet …

Read More

Categories Google Sheets
how change cell border color google sheets 4 How to Change Cell Border Color in Google Sheets

How to Change Cell Border Color in Google Sheets

Last Updated On May 18, 2023 by Kermit Matthews

Formatting your cells in a spreadsheet application like Microsoft Excel or Google Sheets is an important component to making your data easier to read. One …

Read More

Categories Google Sheets
how to sort a column in google sheets

How to Sort Highest to Lowest in Google Sheets

Last Updated On May 19, 2023 by Kermit Matthews

While spreadsheet applications like Microsoft Excel and Google Sheets have a multitude of uses, perhaps one of the main reasons to employ this type of …

Read More

Categories Google Sheets
how to unhide sheets in google sheets

How to Unhide Sheets in Google Sheets

Last Updated On May 2, 2023 by Kermit Matthews

Google Sheets has an option that you can use to hide some of the worksheet tabs in your file. This is helpful when you have …

Read More

Categories Google Sheets
how to put page numbers in Google Sheets header

How to Put Google Sheets Page Numbers at the Top of the Page

Last Updated On May 7, 2023 by Kermit Matthews

Numbering pages in a document is often a requirement for schools or organizations, but they may not have a similar requirement for spreadsheets. You can …

Read More

Categories Google Sheets
how to change the file name in google sheets

How to Change a File Name in Google Sheets

Last Updated On May 7, 2023 by Kermit Matthews

Do you find it difficult to manage your files in Google Drive because the names aren’t descriptive enough? Sometimes we may have an idea of …

Read More

Categories Google Sheets
how to hide a worksheet tab in google sheets

How to Use the Google Sheets Hide Sheet Tool

Last Updated On May 12, 2023 by Kermit Matthews

A Google Sheets file is a workbook that can contain a number of individual worksheets within it. Each of these worksheets is identified by a …

Read More

Categories Google Sheets
how to delete a column in google sheets

How to Delete Columns in Google Sheets

Last Updated On May 21, 2023 by Kermit Matthews

When you are editing a Google Sheets spreadsheet, especially if it contains a lot of data, then it’s not uncommon to need to delete an …

Read More

Categories Google Sheets Tags Columns, Featured Sheets Guides
how to view equations in Google Sheets

How to Find the Google Sheets Show Formulas Setting

Last Updated On May 4, 2023 by Kermit Matthews

Google Sheets can make calculations a lot simpler with the help of equations and formulas. But as you enter formulas into the cells in your …

Read More

Categories Google Sheets
how add color tabs google sheets 2 How to Change the Color of the Sheet Tab in Google Sheets

How to Change the Color of the Sheet Tab in Google Sheets

Last Updated On May 8, 2023 by Kermit Matthews

If your Google Sheets file has a lot of worksheets, finding the right one can be difficult. This is made even worse when the tabs …

Read More

Categories Google Sheets
how to choose how often Google Sheets refreshes

How to Change Google Sheets Recalculate Settings

Last Updated On May 7, 2023 by Kermit Matthews

Many of the formulas that you might add to a spreadsheet in Google Sheets are going to rely on cell locations. If you change something …

Read More

Categories Google Sheets
how to print landscape in google sheets

How to Change the Orientation of a Printed Spreadsheet in Google Sheets

Last Updated On May 13, 2023 by Kermit Matthews

Does it seem like your printed spreadsheet isn’t making the best use of the space on the page? If it seems like you aren’t fitting …

Read More

Categories Google Sheets
how to clear formatting in google sheets

How to Clear Formatting from a Cell in Google Sheets

Last Updated On May 5, 2023 by Kermit Matthews

When you enter data or text into an application like Google Sheets or Google Docs you can elect to change a formatting option for that …

Read More

Categories Google Sheets
how to make a histogram in Google Sheets

How to Make a Histogram on Google Sheets

Last Updated On May 15, 2023 by Kermit Matthews

Google Sheets provides you with many of the same options that you would find in Microsoft Excel, including the ability to create charts and graphs. …

Read More

Categories Google Sheets
how to remove Google Sheets gridlines

How to Remove Lines in Google Sheets

Last Updated On April 26, 2023 by Kermit Matthews

Google Sheets files will display the gridlines on your screen by default when you create a new spreadsheet, and it will even include them by …

Read More

Categories Google Sheets
how to add color to cells in google sheets

How to Add Color to Cells in Google Sheets

Last Updated On May 12, 2023 by Kermit Matthews

Documents that only contain black text on a white background can sometimes be tough to read. it can even make it difficult for people to …

Read More

Categories Google Sheets Tags Background
how to add borders in google sheets

How to Add Borders to Cells in Google Sheets

Last Updated On May 4, 2023 by Kermit Matthews

Have you ever seen a spreadsheet that had different colored lines between its cells, or the lines seemed darker? If you liked that effect then …

Read More

Categories Google Sheets Tags Borders
how change transparency google docs picture 3 How to Make a Picture More Transparent in Google Docs

How to Make a Picture More Transparent in Google Docs

Last Updated On May 3, 2023 by Kermit Matthews

While some of the images that you add to a document will look perfectly fine as they are, you might have pictures that need some …

Read More

Categories Google Sheets
how insert picture google sheets iphone 3 How to Insert a Picture in the Google Sheets iPhone App

How to Insert a Picture in the Google Sheets iPhone App

Last Updated On May 5, 2023 by Kermit Matthews

The steps in this article are going to show you how to insert a picture from your iPhone into a cell in one of your …

Read More

Categories Google Sheets
how copy multiple rows google sheets 2 How to Copy Multiple Rows in Google Sheets

How to Copy Multiple Rows in Google Sheets

Last Updated On May 16, 2023 by Kermit Matthews

This article is going to show you how to copy more than one row in Google Sheets so that you can paste it into a …

Read More

Categories Google Sheets Tags Featured Sheets Guides, Rows
how to use autofill in google sheets 5 How to Use Autofill in Google Sheets

How to Use Autofill in Google Sheets

Last Updated On May 5, 2023 by Kermit Matthews

When you are adding data to a spreadsheet in Google Sheets, it’s very likely that some of that data will fall into a pattern. Whether …

Read More

Categories Google Sheets
how download google sheets chart png 3 How to Download a Google Sheets Chart as a PNG

How to Download a Google Sheets Chart as a PNG

Last Updated On May 8, 2023 by Kermit Matthews

The steps in this article are going to show you how to download a chart or graph in your Google Sheets spreadsheet as a .png …

Read More

Categories Google Sheets
what gray bar google sheets 0 What is the Gray Bar in My Google Sheets Spreadsheet?

What is the Gray Bar in My Google Sheets Spreadsheet?

Last Updated On May 14, 2023 by Kermit Matthews

The steps in this guide are going to show you the setting in Google Sheets that will let you add or remove the gray bar …

Read More

Categories Google Sheets
how create google sheets drop down 6 How to Create a Google Sheets Drop Down Menu

How to Create a Google Sheets Drop Down Menu

Last Updated On April 22, 2023 by Kermit Matthews

The steps in this guide will show you how to create a drop down menu in Google Sheets. This menu will be either created from …

Read More

Categories Google Sheets
how remove checkboxes google sheets 3 How to Remove Multiple Checkboxes in Google Sheets

How to Remove Multiple Checkboxes in Google Sheets

Last Updated On May 19, 2023 by Kermit Matthews

Google Sheets provides a simple way for you to add a checkbox to your spreadsheet. Simply click the Insert tab at the top of the …

Read More

Categories Google Sheets Tags Objects
how view cell history google sheets 2 How to View Cell History in Google Sheets

How to View Cell History in Google Sheets

Last Updated On April 25, 2023 by Kermit Matthews

Google Sheets has long had an option that allowed you to view the history of a file. You could open up the Version History, select …

Read More

Categories Google Sheets
how download xls google sheets 2 How to Download an Excel Version of a Google Sheets File

How to Download an Excel Version of a Google Sheets File

Last Updated On May 19, 2023 by Kermit Matthews

Google Sheets is very similar to Microsoft Excel in many ways and, for a large number of users, is a perfectly acceptable replacement. Sheets lets …

Read More

Categories Google Sheets
how to hide column google sheets 2 How to Hide a Column in Google Sheets

How to Hide a Column in Google Sheets

Last Updated On May 5, 2023 by Kermit Matthews

Sometimes when you are creating a spreadsheet you will focus first on adding all of the data, then format everything so that it is more …

Read More

Categories Google Sheets
how rename worksheet tab google sheets 2 How to Rename a Google Sheets Worksheet Tab

How to Rename a Google Sheets Worksheet Tab

Last Updated On May 6, 2023 by Kermit Matthews

Google Sheets, much like Microsoft Excel, lets you add new worksheets to your file. This makes it easy for you to organize all of your …

Read More

Categories Google Sheets
how remove cell borders google sheets 3 How to Remove Cell Borders in Google Sheets

How to Remove Cell Borders in Google Sheets

Last Updated On May 4, 2023 by Kermit Matthews

Cell borders are useful in spreadsheet applications for providing a visible outline around cells of importance, or when you are printing your spreadsheet. But your …

Read More

Categories Google Sheets
how to insert a checkbox in google sheets

How to Insert a Checkbox in Google Sheets

Last Updated On May 1, 2023 by Kermit Matthews

Spreadsheets can be used for a number of different purposes, but one common one is to create a form that is distributed to other people. …

Read More

Categories Google Sheets Tags Featured Sheets Guides, Objects
how to apply alternating colors in google sheets

How to Apply Alternating Colors to Rows in Google Sheets

Last Updated On May 19, 2023 by Kermit Matthews

Spreadsheet data can be difficult to read on a screen or on a printed page, especially when you are dealing with a lot of data …

Read More

Categories Google Sheets
how to randomize a range in google sheets

How to Randomize a Data Selection in Google Sheets

Last Updated On May 8, 2023 by Kermit Matthews

While spreadsheet applications are useful for their ability to calculate and manipulate data, situations may arise where you don’t want your data in a specific …

Read More

Categories Google Sheets
how to merge cells in google sheets

How to Merge Cells in Google Sheets

Last Updated On April 30, 2023 by Kermit Matthews

When you first create a spreadsheet in Google Sheets it will contain a series of cells arranged into rows and columns. These cells will be …

Read More

Categories Google Sheets
how center data horizontally google sheets

How to Center Data Horizontally in Google Sheets

Last Updated On May 12, 2023 by Kermit Matthews

The data that you enter into your cells in Google Sheets often receives some default formatting based on the type of data it is. For …

Read More

Categories Google Sheets
how to split data into columns in google sheets

How to Split Full Names in Google Sheets

Last Updated On April 24, 2023 by Kermit Matthews

Data formatting is something that many people don’t consider when they are first creating a spreadsheet, but it often becomes an issue later in the …

Read More

Categories Google Sheets
how to stop sharing a link to a google sheets file

How to Stop Sharing a Link to a Google Sheets File

Last Updated On May 2, 2023 by Kermit Matthews

Google Drive makes it very easy for you to share a link to one of the Google Sheets files that you’ve created. Simply turn on …

Read More

Categories Google Sheets
how to protect a worksheet in google sheets

How to Protect a Worksheet in Google Sheets

Last Updated On May 8, 2023 by Kermit Matthews

The collaboration feature in Google Sheets makes it easier for a group of people to work on the same file. But if you have shared …

Read More

Categories Google Sheets
how to apply currency formatting in google sheets

How to Apply Currency Formatting in Google Sheets

Last Updated On May 18, 2023 by Kermit Matthews

Many of the spreadsheets that people work with in Google Sheets involve money. But it’s possible that the cells containing those monetary values are either …

Read More

Categories Google Sheets
Older posts
Page1 Page2 Next →

Join Our Free Newsletter

Featured guides and deals

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

  • About Us
  • Contact
  • Disclaimer
  • Privacy Policy
© Live2Tech.com 2023
  • Popular
  • iPhone
  • Excel
  • Word
  • Docs
  • Sheets