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.

Preventing Auto-Corrections in Google Sheets: A Step-by-Step Guide

April 2, 2024 by Kermit Matthews

Stop the frustration of auto-corrections in Google Sheets with our easy step-by-step guide to prevent unwanted changes in your data.

Categories Google Sheets, Tutorials

Enhancing Readability in Google Sheets: Tips for Darker Gridlines

April 2, 2024 by Kermit Matthews

Struggling to read your Google Sheets? Boost readability with darker gridlines! Check out our tips for clearer data visualization.

Categories Google Sheets, Tutorials

Securing Google Sheets: How to Hide Tabs from Specific Users

April 2, 2024 by Kermit Matthews

Protect sensitive data in Google Sheets by hiding tabs from certain users. Learn how to easily secure your spreadsheets with these tips.

Categories Google Sheets, Tutorials

Creative Cell Formatting in Google Sheets: How to Split Cells Diagonally

April 2, 2024 by Kermit Matthews

Learn how to split cells diagonally in Google Sheets for unique and creative data presentation. Perfect for organizing complex information!

Categories Google Sheets, Tutorials

Customizing Google Sheets Pie Charts: Display Values, Not Percentages

April 2, 2024 by Kermit Matthews

Learn how to customize Google Sheets pie charts to show values instead of percentages for a more accurate data representation.

Categories Google Sheets, Tutorials

Creating a Searchable Database in Google Sheets for Better Data Handling

April 2, 2024 by Kermit Matthews

Learn how to create a searchable database in Google Sheets for efficient data handling. Follow our step-by-step guide for easy organization!

Categories Google Sheets, Tutorials

Center Across Selection: Unify Text Display in Google Sheets

April 2, 2024 by Kermit Matthews

Learn how to use the ‘Center Across Selection’ feature in Google Sheets to effortlessly align and unify the display of your text data.

Categories Google Sheets, Tutorials

How to Insert Multiple Checkboxes in a Single Google Sheets Cell: A Step-by-Step Guide

April 2, 2024 by Kermit Matthews

Struggling to organize data? Learn how to insert multiple checkboxes in a single Google Sheets cell with our easy step-by-step guide.

Categories Google Sheets, Tutorials

Filtering Data for Personalized Views in Google Sheets: A How-To Guide

April 2, 2024 by Kermit Matthews

Learn how to filter data in Google Sheets for a personalized view with our step-by-step guide. Get the most out of your data today!

Categories Google Sheets, Tutorials

Removing Formulas from Google Sheets: Preserve Your Data

April 2, 2024 by Kermit Matthews

Keep your data intact while removing formulas in Google Sheets. Follow our simple steps to preserve your information without losing any calculations.

Categories Google Sheets, Tutorials

How to Make Google Sheets Mobile Fill Down: A Step-by-Step Guide

March 15, 2024 by Kermit Matthews

Want to make your life easier when using Google Sheets on your mobile device? Filling down data can save you a ton of time, especially …

Read More

Categories Google Sheets

How to Highlight Every Other Row in Google Sheets: A Step-by-Step Guide

March 1, 2024January 24, 2024 by Kermit Matthews

Highlighting every other row on Google Sheets is all about making your data visually easier to follow. At a glance, you can distinguish between rows, …

Read More

Categories Google Sheets

How to Hide Rows on Google Sheets on PC or Mac: A Step-by-Step Guide

March 1, 2024January 24, 2024 by Kermit Matthews

Hiding rows on Google Sheets is a nifty trick to keep your spreadsheet looking clean and organized. It’s quite simple to do on a PC …

Read More

Categories Google Sheets

How to Format Cells on Google Sheets on Android: A Step-by-Step Guide

January 24, 2024 by Kermit Matthews

Formatting cells on Google Sheets on Android is a simple process that can be accomplished in just a few steps. First, select the cell or …

Read More

Categories Google Sheets

How to Make Cells Bigger on Google Sheets for PC & Mac Users

January 19, 2024 by Kermit Matthews

Making cells bigger on Google Sheets is a simple task that can be accomplished in a few clicks. By adjusting the row height or column …

Read More

Categories Google Sheets

How to Rename Columns on Google Sheets for PC and Mac Users

January 16, 2024 by Kermit Matthews

Renaming columns in Google Sheets on a PC or Mac is a simple process. Just double-click on the column header you wish to rename, type …

Read More

Categories Google Sheets

How to Save Google Sheets on PC or Mac: A Guide to Backing Up Work

January 12, 2024 by Kermit Matthews

Saving Google Sheets on your PC or Mac is a straightforward process. By backing up your work, you can ensure that your data is safe …

Read More

Categories Google Sheets

How to Unlink a Form on Google Sheets: Step-by-Step Guide

January 11, 2024 by Kermit Matthews

Unlinking a form on Google Sheets is a straightforward process. Simply open the form you want to unlink, click on the “Responses” tab, and select …

Read More

Categories Google Sheets

How to Upload and Share a Spreadsheet on Google Docs: A Step-by-Step Guide

January 11, 2024 by Kermit Matthews

Uploading and sharing a spreadsheet on Google Docs is a straightforward process. First, go to Google Drive and click on the ‘New’ button, then select …

Read More

Categories Google Sheets

How to Total a Column on Google Sheets on PC or Mac: A Step-by-Step Guide

January 10, 2024 by Kermit Matthews

Totalling a column on Google Sheets is as simple as clicking a few buttons. You just have to select the column you want to total, …

Read More

Categories Google Sheets

How to Subtract Cells in Google Sheets: A Step-by-Step Guide

January 10, 2024 by Kermit Matthews

Subtracting cells in Google Sheets is a straightforward task. All you need to do is type in a simple formula: “=cell1-cell2” where cell1 is the …

Read More

Categories Google Sheets

How to Sort on Google Sheets on Android: A Step-by-Step Guide

January 9, 2024 by Kermit Matthews

Sorting data in Google Sheets on Android is a breeze. First, open the app and the sheet you want to work with. Then, select the …

Read More

Categories Google Sheets

How to Edit Google Sheets on Mobile: A Step-by-Step Guide

January 4, 2024 by Kermit Matthews

Editing Google Sheets on mobile is a breeze! Simply download the Google Sheets app from your app store, open the spreadsheet you want to edit, …

Read More

Categories Google Sheets

How to Make a Google Sheets File Public

November 7, 2023 by Kermit Matthews

To make a Google Sheets file public, you simply need to adjust the sharing settings within the file. Click on the ‘Share’ button, then click …

Read More

Categories Google Sheets

How to Specify a Header Row in Google Sheets

November 7, 2023 by Kermit Matthews

Specifying a header row in Google Sheets is a straightforward task. Simply click on the row number at the left of the row you want …

Read More

Categories Google Sheets

How to Split Columns in Google Sheets

November 7, 2023 by Kermit Matthews

Splitting columns in Google Sheets is a simple process that can be achieved by using the “SPLIT” function or the “Text to Columns” feature. These …

Read More

Categories Google Sheets

How to Convert XLSX to Google Sheets

November 7, 2023 by Kermit Matthews

Converting an XLSX file to Google Sheets is a straightforward process. First, go to Google Drive, click on ‘New,’ and select ‘File Upload.’ Then choose …

Read More

Categories Google Sheets

How to Insert Date in Google Sheets

November 7, 2023 by Kermit Matthews

Inserting the current date in Google Sheets can be accomplished by using the CTRL + ; (semicolon) keyboard shortcut. Click on the cell where you …

Read More

Categories Google Sheets
how to save a Google Sheets file as a CSV

How to Save a Google Sheets File as a CSV

May 6, 2023January 19, 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

May 12, 2023December 15, 2022 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?

October 15, 2023July 29, 2022 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

May 14, 2023July 19, 2022 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

April 30, 2023July 15, 2022 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)

May 11, 2023June 24, 2022 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!)

May 3, 2023June 17, 2022 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)

May 2, 2023June 9, 2022 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

April 30, 2023May 12, 2022 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

May 13, 2023April 28, 2022 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

May 11, 2023April 7, 2022 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

April 27, 2023April 5, 2022 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

May 18, 2023March 18, 2022 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

May 19, 2023March 8, 2022 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

May 2, 2023March 8, 2022 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

May 7, 2023February 3, 2022 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

May 7, 2023December 7, 2021 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

May 12, 2023November 15, 2021 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

May 21, 2023October 28, 2021 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

May 4, 2023October 4, 2021 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

May 8, 2023September 16, 2021 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

May 7, 2023May 25, 2021 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
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 2025
  • Popular
  • iPhone
  • Excel
  • Word
  • Docs
  • Sheets
  • Tutorials