Skip to content
Live2Tech
  • iPhone
  • Windows
    • Windows 11
    • Windows 10
  • Office
    • Word
    • Excel
    • Powerpoint
    • Outlook
  • Google
    • Google Docs
    • Google Sheets
    • Google Slides
    • Gmail
    • Chrome
    • Google Drive
  • Mac & Apple
    • Mac
    • iPad
    • Apple Watch
  • All Tutorials

Google Sheets

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

How to Use the QUERY Function in Google Sheets

November 15, 2026November 5, 2026 by Kermit Matthews

Type =QUERY(range, “select … where …”, 1) to filter, sort, and total data in one formula. This guide explains the syntax, clause order, text, number and date conditions, GROUP BY and PIVOT, cell references, Col1 notation, IMPORTRANGE, and how to fix common QUERY errors. Continue Reading How to Use the QUERY Function in Google Sheets

Categories Google Sheets

How to Convert a Range to a Table in Google Sheets: A Step-by-Step Guide

November 10, 2026September 4, 2026 by Kermit Matthews

Converting a range to a table in Google Sheets is a straightforward process that enhances your data analysis. By transforming a simple range into a… Continue Reading How to Convert a Range to a Table in Google Sheets: A Step-by-Step Guide

Categories Google Sheets
Spreadsheet with a COUNTIF formula counting how many cells contain a word

How to Count How Many Times a Word Appears in Google Sheets

November 10, 2026December 6, 2024 by Kermit Matthews

Count a word in Google Sheets with COUNTIF, use wildcards for partial matches, and SUMPRODUCT with SUBSTITUTE to count repeats inside cells. Continue Reading How to Count How Many Times a Word Appears in Google Sheets

Categories Google Sheets
Spreadsheet Find and replace dialog searching all sheets for a word with match case and search within formulas options, and matching cells highlighted

How to Search for a Word in Google Sheets

November 10, 2026July 5, 2024 by Kermit Matthews

Search for a word in Google Sheets with Ctrl+F, search all sheets with Find and replace, and use COUNTIF, FILTER, or highlighting to find every match. Continue Reading How to Search for a Word in Google Sheets

Categories Google Sheets
Spreadsheet settings dialog on the General tab with the Locale dropdown highlighted

How to Change the Language in Google Sheets

November 14, 2026May 29, 2024 by Kermit Matthews

Change the Google Sheets menu language in your Google Account, set a spreadsheet locale for dates and numbers, and translate cells. Continue Reading How to Change the Language in Google Sheets

Categories Google Sheets

How to Recover a Google Sheet: A Step-by-Step Guide to Restoration

November 10, 2026May 17, 2024 by Kermit Matthews

Learn how to restore a deleted or lost Google Sheet with this step-by-step guide. Follow these easy instructions to recover your important data effortlessly. Continue Reading How to Recover a Google Sheet: A Step-by-Step Guide to Restoration

Categories Google Sheets

How to Do Correlation in Google Sheets

November 10, 2026May 16, 2024 by Kermit Matthews

Learn how to calculate correlation in Google Sheets with our step-by-step guide, from data input to using the CORREL function for insightful analysis. Continue Reading How to Do Correlation in Google Sheets

Categories Google Sheets
Spreadsheet Drawing dialog with the Shape menu open showing Shapes, Arrows, Callouts and Equation options

How to Insert Shapes in Google Sheets

November 10, 2026May 15, 2024 by Kermit Matthews

Insert shapes, arrows, and callouts in Google Sheets with Insert > Drawing, then move, resize, edit, or turn a shape into a clickable button. Continue Reading How to Insert Shapes in Google Sheets

Categories Google Sheets

How to Add a Watermark in Google Sheets (4 Workarounds)

November 10, 2026May 15, 2024 by Kermit Matthews

Learn how to seamlessly add a watermark to your Google Sheets with our easy-to-follow step-by-step guide. Perfect for ensuring your documents stand out! Continue Reading How to Add a Watermark in Google Sheets (4 Workarounds)

Categories Google Sheets

How to Center Across Selection in Google Sheets (2 Workarounds)

November 10, 2026May 13, 2024 by Kermit Matthews

Learn to easily center text across multiple cells in Google Sheets with this simple step-by-step guide. Perfect for organizing your data! Continue Reading How to Center Across Selection in Google Sheets (2 Workarounds)

Categories Google Sheets
Spreadsheet with an AVERAGE formula entered below a column of scores and the bottom-right summary showing the average of the selected cells highlighted

How to Average Cells in Google Sheets (AVERAGE, AVERAGEIF, and More)

November 10, 2026May 13, 2024 by Kermit Matthews

Average cells in Google Sheets with AVERAGE, see a quick average without a formula, use AVERAGEIF and AVERAGEIFS, skip zeros, and fix #DIV/0!. Continue Reading How to Average Cells in Google Sheets (AVERAGE, AVERAGEIF, and More)

Categories Google Sheets
Online spreadsheet with rows 3 to 6 selected by their row numbers and the right-click menu showing Hide rows 3 - 6 highlighted

How to Hide (and Unhide) Rows in Google Sheets on PC or Mac

November 10, 2026May 13, 2024 by Kermit Matthews

Hide multiple rows in Google Sheets with right-click > Hide rows or Ctrl + Alt + 9, unhide them with the row arrows, and group or filter rows instead. Continue Reading How to Hide (and Unhide) Rows in Google Sheets on PC or Mac

Categories Google Sheets

How to Remove Conditional Formatting in Google Sheets

November 14, 2026May 13, 2024 by Kermit Matthews

Struggling to remove conditional formatting in Google Sheets? Our step-by-step guide makes it easy to clean up your spreadsheet. Continue Reading How to Remove Conditional Formatting in Google Sheets

Categories Google Sheets
Online document editor Find and replace dialog with a regular expression for two or more spaces, a single space in Replace with, and Use regular expressions checked

How to Count Words in Google Sheets (Formulas That Work)

November 10, 2026May 13, 2024 by Kermit Matthews

Count words in Google Sheets with a SPLIT and COUNTA formula, total a column with SUMPRODUCT, and count specific words or characters. Continue Reading How to Count Words in Google Sheets (Formulas That Work)

Categories Google Sheets
Spreadsheet with all cells selected, the toolbar font size box highlighted, and the Themes customize panel font option highlighted

How to Change the Default Font Size in Google Sheets

November 10, 2026May 9, 2024 by Kermit Matthews

Change the font size for a whole Google Sheet, set the default font with a theme, and start new spreadsheets with your preferred size using a starter file. Continue Reading How to Change the Default Font Size in Google Sheets

Categories Google Sheets
Spreadsheet with a filter on the header row and the Region column filter menu open showing Filter by values with West checked

How to Filter Columns in Google Sheets (Filters, Views, and FILTER)

November 10, 2026May 8, 2024 by Kermit Matthews

Filter columns in Google Sheets by value, condition, or color, use filter views so others are not affected, add slicers, and use the FILTER function. Continue Reading How to Filter Columns in Google Sheets (Filters, Views, and FILTER)

Categories Google Sheets
Spreadsheet right-click menu with Insert cells open and Insert cells and shift down highlighted

How to Move Cells in Google Sheets Without Overwriting Data

November 15, 2026May 7, 2024 by Kermit Matthews

Move cells in Google Sheets without overwriting data by inserting cells and shifting down or right, then cutting and pasting, or by dragging whole rows. Continue Reading How to Move Cells in Google Sheets Without Overwriting Data

Categories Google Sheets

How to Show All Text in Google Sheets (Wrap, Resize, or Overflow)

November 10, 2026May 7, 2024 by Kermit Matthews

Learn how to display all text in your Google Sheets with our easy-to-follow guide. Say goodbye to hidden data and hello to full visibility! Continue Reading How to Show All Text in Google Sheets (Wrap, Resize, or Overflow)

Categories Google Sheets

How to Change Chart Colors in Google Sheets

November 10, 2026May 7, 2024 by Kermit Matthews

Customize your Google Sheets charts with ease! Follow our step-by-step guide to change chart colors and make your data stand out. Continue Reading How to Change Chart Colors in Google Sheets

Categories Google Sheets

How to Get the Equation of a Line in Google Sheets

November 10, 2026May 2, 2024 by Kermit Matthews

Learn how to easily find the equation of a line in Google Sheets with our simple step-by-step guide. Perfect for data analysis and graphing! Continue Reading How to Get the Equation of a Line in Google Sheets

Categories Google Sheets
Online spreadsheet with an ARRAYFORMULA in the formula bar and results filling column D, with the fill handle highlighted

How to Apply a Formula to an Entire Column in Google Sheets Quickly

November 15, 2026May 2, 2024 by Kermit Matthews

Apply a formula to an entire column in Google Sheets with the fill handle, ARRAYFORMULA, Ctrl+Enter, or Ctrl+D, and fix #REF! and fill problems. Continue Reading How to Apply a Formula to an Entire Column in Google Sheets Quickly

Categories Google Sheets

How to Copy Conditional Formatting in Google Sheets

November 10, 2026May 2, 2024 by Kermit Matthews

Learn how to duplicate conditional formatting in Google Sheets with our easy step-by-step guide. Save time and streamline your work! Continue Reading How to Copy Conditional Formatting in Google Sheets

Categories Google Sheets

How to Highlight in Google Sheets (Cells, Text, Rows and Duplicates)

November 10, 2026May 2, 2024 by Kermit Matthews

Learn how to make important data stand out in Google Sheets with our easy step-by-step guide on highlighting cells, rows, and columns. Continue Reading How to Highlight in Google Sheets (Cells, Text, Rows and Duplicates)

Categories Google Sheets
Spreadsheet using ROUNDUP to round values up to whole numbers and one decimal place

How to Round Up in Google Sheets

November 10, 2026May 2, 2024 by Kermit Matthews

Round up in Google Sheets with ROUNDUP(value, places), or CEILING for multiples. Examples for decimals, tens, negatives and quantities. Continue Reading How to Round Up in Google Sheets

Categories Google Sheets

How to Auto Populate Dates in Google Sheets (6 Methods)

November 10, 2026May 1, 2024 by Kermit Matthews

Learn how to auto populate dates in Google Sheets with this easy step-by-step guide. Save time and streamline your workflow today! Continue Reading How to Auto Populate Dates in Google Sheets (6 Methods)

Categories Google Sheets

How to Uncheck All Boxes in Google Sheets

November 10, 2026May 1, 2024 by Kermit Matthews

Learn how to quickly uncheck all boxes in Google Sheets with our easy step-by-step guide. Save time and streamline your workflow today! Continue Reading How to Uncheck All Boxes in Google Sheets

Categories Google Sheets
Spreadsheet with an index column added so the original order can be restored by sorting it A to Z

How to Unsort in Google Sheets

November 10, 2026May 1, 2024 by Kermit Matthews

Google Sheets has no unsort button. Undo with Ctrl + Z, restore from Version history, or add an index column before sorting to get the original order back. Continue Reading How to Unsort in Google Sheets

Categories Google Sheets

How to Convert a PDF to Google Sheets

November 10, 2026April 30, 2024 by Kermit Matthews

Learn how to easily convert PDFs to Google Sheets with this step-by-step guide. Say goodbye to manual data entry and hello to efficiency! Continue Reading How to Convert a PDF to Google Sheets

Categories Google Sheets
Spreadsheet with duplicate rows highlighted and the conditional format rules panel showing a COUNTIFS custom formula

How to Highlight Duplicates in Google Sheets (Multiple Columns)

November 10, 2026April 30, 2024 by Kermit Matthews

Highlight duplicates across multiple columns in Google Sheets with conditional formatting: formulas for repeated values, duplicate rows, and first copies. Continue Reading How to Highlight Duplicates in Google Sheets (Multiple Columns)

Categories Google Sheets
Spreadsheet with a date picker calendar open under a date cell

How to Insert a Calendar in Google Sheets

November 10, 2026April 26, 2024 by Kermit Matthews

Add a date picker to Google Sheets cells with Data validation, or insert a full calendar from the template gallery. Continue Reading How to Insert a Calendar in Google Sheets

Categories Google Sheets
Spreadsheet with column C selected and the Protected sheets and ranges panel open with Range C:C and the Set permissions button highlighted

How to Lock a Column in Google Sheets (Freeze or Protect)

November 10, 2026April 25, 2024 by Kermit Matthews

Lock a column in Google Sheets by freezing it so it stays visible, or protecting it so others cannot edit it, plus how to unfreeze and remove protection. Continue Reading How to Lock a Column in Google Sheets (Freeze or Protect)

Categories Google Sheets

How to Adjust Column Width in Google Sheets (5 Ways)

November 10, 2026April 24, 2024 by Kermit Matthews

Learn how to easily adjust column width in Google Sheets with our step-by-step guide. Say goodbye to cluttered data and hello to organized spreadsheets! Continue Reading How to Adjust Column Width in Google Sheets (5 Ways)

Categories Google Sheets

How to Use VLOOKUP in Google Sheets (With Examples and Error Fixes)

November 12, 2026April 24, 2024 by Kermit Matthews

Master VLOOKUP in Google Sheets with this step-by-step guide. Easily look up and retrieve data to save time and improve your spreadsheets. Continue Reading How to Use VLOOKUP in Google Sheets (With Examples and Error Fixes)

Categories Google Sheets
Spreadsheet formula bar showing a formula that links to a cell on another sheet

How to Link Cells in Google Sheets

November 12, 2026April 24, 2024 by Kermit Matthews

Link cells in Google Sheets with = references, link other tabs with SheetName!A1, other files with IMPORTRANGE, or add clickable cell links. Continue Reading How to Link Cells in Google Sheets

Categories Google Sheets
Sort range dialog with Data has header row checked and two sort columns

How to Custom Sort in Google Sheets

November 10, 2026April 23, 2024 by Kermit Matthews

Sort Google Sheets by multiple columns with Advanced range sorting options, and sort in a custom order like High, Medium, Low with SORT and MATCH. Continue Reading How to Custom Sort in Google Sheets

Categories Google Sheets
Spreadsheet toolbar fill color menu open with a light yellow color chosen for selected cells

How to Change Cell Color in Google Sheets

November 14, 2026April 23, 2024 by Kermit Matthews

Change cell background color in Google Sheets with Fill color or custom hex codes, and color cells automatically with conditional formatting. Continue Reading How to Change Cell Color in Google Sheets

Categories Google Sheets
Spreadsheet Insert menu open with the Chart command highlighted

How to Make a Graph in Google Sheets

November 10, 2026April 22, 2024 by Kermit Matthews

Make a graph in Google Sheets: select data, choose Insert, Chart, then pick a chart type and customize titles, colors and axes in the chart editor. Continue Reading How to Make a Graph in Google Sheets

Categories Google Sheets
Spreadsheet with a formula referencing another sheet tab in the formula bar and the sheet tabs at the bottom highlighted

How to Pull Data From Another Tab or File in Google Sheets

November 12, 2026April 18, 2024 by Kermit Matthews

Pull data from another sheet in Google Sheets with cell references, XLOOKUP, FILTER, and QUERY, or from another file with IMPORTRANGE. Continue Reading How to Pull Data From Another Tab or File in Google Sheets

Categories Google Sheets
Google Sheets sheet tab right-click menu with Copy to and New spreadsheet highlighted

How to Share Only One Sheet in Google Sheets

November 10, 2026April 17, 2024 by Kermit Matthews

Google Sheets can’t share a single tab, but you can copy it to a new spreadsheet, share a live copy with IMPORTRANGE, or publish one sheet to the web. Continue Reading How to Share Only One Sheet in Google Sheets

Categories Google Sheets
Google Sheets with the Protected sheets and ranges panel open and the Sheet tab and Set permissions button highlighted

How to Password Protect a Google Sheet (and What to Do Instead)

November 10, 2026April 16, 2024 by Kermit Matthews

Google Sheets has no password option. Learn how to make a sheet private, lock cells and tabs, or encrypt a copy with a password in Excel. Continue Reading How to Password Protect a Google Sheet (and What to Do Instead)

Categories Google Sheets

How to Prevent Auto-Corrections in Google Sheets

November 10, 2026April 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. Continue Reading How to Prevent Auto-Corrections in Google Sheets

Categories Google Sheets

How to Split a Cell Diagonally in Google Sheets

November 10, 2026April 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! Continue Reading How to Split a Cell Diagonally in Google Sheets

Categories Google Sheets
Spreadsheet cell holding three selected dropdown chips with Allow multiple selections turned on

Multiple Checkboxes in One Google Sheets Cell: What Works

November 10, 2026April 2, 2024 by Kermit Matthews

Google Sheets allows one checkbox per cell. Use a multi-select dropdown for several choices in one cell, or one checkbox per column. Continue Reading Multiple Checkboxes in One Google Sheets Cell: What Works

Categories Google Sheets

How to Hide Columns or Tabs From Specific Users in Google Sheets (What Works)

November 10, 2026April 1, 2024 by Kermit Matthews

Learn how to safeguard your sensitive data in Google Sheets by hiding columns from unauthorized users with these simple steps. Continue Reading How to Hide Columns or Tabs From Specific Users in Google Sheets (What Works)

Categories Google Sheets

How to Save Google Sheets on a PC or Mac (Download and Back Up)

November 10, 2026January 12, 2024 by Kermit Matthews

Google Sheets saves your work automatically to Google Drive, so you never need to press a Save button. To keep a copy on your PC… Continue Reading How to Save Google Sheets on a PC or Mac (Download and Back Up)

Categories Google Sheets
Phone spreadsheet app with a cell selected for editing, the formula bar active, and the Format button highlighted

How to Edit Google Sheets on Mobile (Android and iPhone)

November 10, 2026January 4, 2024 by Kermit Matthews

Edit Google Sheets on your phone: edit cells and formulas, format data, manage rows and columns, share, and work offline on Android or iPhone. Continue Reading How to Edit Google Sheets on Mobile (Android and iPhone)

Categories Google Sheets
Share dialog with General access set to Anyone with the link as Viewer

How to Make a Google Sheets File Public

November 10, 2026November 7, 2023 by Kermit Matthews

Make a Google Sheet public with Anyone with the link sharing or Publish to web, choose viewer or editor access, and protect your data. Continue Reading How to Make a Google Sheets File Public

Categories Google Sheets

How to Split Columns in Google Sheets

November 15, 2026November 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… Continue Reading How to Split Columns in Google Sheets

Categories Google Sheets

How to Convert XLSX to Google Sheets

November 10, 2026November 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… Continue Reading How to Convert XLSX to Google Sheets

Categories Google Sheets
Google Slides filmstrip with a slide right-clicked and Delete highlighted in the menu

How to Insert a Date in Google Sheets

November 12, 2026November 7, 2023 by Kermit Matthews

Insert a date in Google Sheets with Ctrl + ; for a fixed date, =TODAY() for an updating one, or a date picker via Data validation. Plus formatting tips. Continue Reading How to Insert a Date in Google Sheets

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

Live2Tech

Plain-English, step-by-step guides for the devices and apps you use every day.

Apple

  • iPhone
  • iPad
  • Mac
  • Apple Watch

Windows

  • Windows 11
  • Windows 10

Microsoft Office

  • Word
  • Excel
  • Powerpoint
  • Outlook

Google

  • Google Docs
  • Google Sheets
  • Google Slides
  • Gmail
  • Chrome
  • Google Drive
  • About Us
  • Contact
  • Disclaimer
  • Privacy Policy
© Live2Tech.com 2026
  • iPhone
  • Windows
    • Windows 11
    • Windows 10
  • Office
    • Word
    • Excel
    • Powerpoint
    • Outlook
  • Google
    • Google Docs
    • Google Sheets
    • Google Slides
    • Gmail
    • Chrome
    • Google Drive
  • Mac & Apple
    • Mac
    • iPad
    • Apple Watch
  • All Tutorials