How-to guides and tutorials to help you perform specific tasks and use the Google Sheets spreadsheet application.
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
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
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
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
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)
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) Multiple Rows in Google Sheets
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)
Number rows in Google Sheets with the fill handle, SEQUENCE, ROW, or COUNTA, create custom IDs, and fix numbers that repeat or break. Continue Reading How to Add Sequential Numbers in Google Sheets
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
Remove alternating row colors in Google Sheets with Format, Alternating colors, Remove alternating colors. Also check for conditional formatting. Continue Reading How to Remove Alternating Colors in Google Sheets
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)
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
Select every row below a point in Google Sheets with Ctrl + Shift + Down Arrow or Shift-click, then delete, hide, or format them at once. Continue Reading How to Select All Rows Below a Certain Point in Google Sheets
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
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
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
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)
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
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)
AutoFit columns in Google Sheets by double-clicking the border or using Resize columns > Fit to data, fit row heights, and fix columns that will not fit. Continue Reading How to AutoFit Columns and Rows in Google Sheets
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
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
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
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
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 Sheet in Google Sheets
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
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)
Remove protection from sheets and ranges you can edit in Google Sheets, request edit access to view-only files, and unlock files locked in Drive. Continue Reading How to Unlock a Google Sheet
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 Preventing Auto-Corrections in Google Sheets: A Step-by-Step Guide
Protect sensitive data in Google Sheets by hiding tabs from certain users. Learn how to easily secure your spreadsheets with these tips. Continue Reading Securing Google Sheets: How to Hide Tabs from Specific Users
Learn how to split cells diagonally in Google Sheets for unique and creative data presentation. Perfect for organizing complex information! Continue Reading Creative Cell Formatting in Google Sheets: How to Split Cells Diagonally
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
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,… Continue Reading How to Highlight Every Other Row in Google Sheets: A Step-by-Step Guide
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… Continue Reading How to Hide Rows on Google Sheets on PC or Mac: A Step-by-Step Guide
Format cells in the Google Sheets Android app: bold and fonts, fill color, borders, wrap text, merge, number formats and conditional formatting. Continue Reading How to Format Cells in Google Sheets on Android (Text, Numbers, Colors)
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… Continue Reading How to Save Google Sheets on PC or Mac: A Guide to Backing Up Work
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)
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
Specify a header row in Google Sheets by freezing it, marking it in sort options, creating a filter or table, using it in charts, and repeating it in print. Continue Reading How to Specify a Header Row in Google Sheets
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
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
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
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… Continue Reading How to Save a Google Sheets File as a CSV
Google Sheets toolbar missing? Press Ctrl+Shift+F or click the arrow to show menus, exit full screen, show the formula bar, and fix zoom or extension issues. Continue Reading Why Is My Google Sheets Toolbar Missing? How to Get It Back
Lock a row in Google Sheets by freezing it with View > Freeze so it stays visible, or protect it with Data > Protect sheets and ranges. Continue Reading How to Lock a Row in Google Sheets
Make multiple columns the same width in Google Sheets with Resize columns, by dragging one selected border, or fit them to data. Rows too. Continue Reading How to Make Multiple Columns the Same Width in Google Sheets
Make a title in Google Sheets: add a title row, merge and center it, format it, freeze it, print it on every page, and name the file and sheet tabs. Continue Reading How to Make a Title in Google Sheets
Restore an earlier version of a Google Sheets file from version history, recover only certain data with Make a copy, and name versions for later. Continue Reading How to Restore a Version From Version History in Google Sheets
Insert an image into a cell in Google Sheets with Insert > Image > Image in cell or the IMAGE function, lock it in place, and fix images that won’t show. Continue Reading How to Insert an Image Into a Cell in Google Sheets (and Lock It in Place)
Print gridlines in Google Sheets by checking Show gridlines in print settings, or add borders for darker lines, print a selection, and fit it on one page. Continue Reading How to Print With Gridlines in Google Sheets