Google Sheets Explained Every Sheety Word
Google Sheets can feel overwhelming, at times. Functions, Formulas, and Scripts OH MY. Sometimes feels like I have to learn another language to learn Google Sheets. Errors, Query, Regex, APIs... the list goes on and on.
Actually here's the list!
Every Google Sheets term explained, defined in plain English. That's not all. There's also videos and tools to help you. See how this menagerie comes together to make beautiful spreadsheets.
Jump to a section
Lookup and reference functions
INDEX, MATCH, XLOOKUP, VLOOKUP, INDIRECT, OFFSET, and friends.
INDEX
INDEX fetches a value from a range by row and column number. Combined with MATCH it powers flexible lookups. Alone it picks nth items from lists, dynamic headers, or matrix intersections without VLOOKUP column limits.
Read guide →MATCH
MATCH searches a range for a value and returns its relative position. Feeding INDEX or OFFSET with MATCH replaces brittle column index math. Sorted approximate match modes support tier tables and date brackets.
Read guide →INDEX MATCH
INDEX MATCH is a two-function lookup pattern: MATCH finds the row or column position of a key, and INDEX returns the value from that position in another column. It predates XLOOKUP but remains common in legacy models and tutorials.
Read guide →VLOOKUP
VLOOKUP searches the first column of a range for a key and returns a value from a specified column to the right. It is still everywhere in legacy templates even as XLOOKUP offers more flexible replacements.
Read guide →HLOOKUP
HLOOKUP is the horizontal cousin of VLOOKUP. It searches the first row of a range for a key and returns a value from a specified row below. Wide month grids and matrix headers occasionally still use it.
Read guide →XLOOKUP
XLOOKUP searches a lookup array for a key and returns a matching value from a return array. It handles left lookups, approximate match, and custom not-found text without INDEX/MATCH gymnastics.
Read guide →INDIRECT
INDIRECT evaluates a text string as a cell reference. Build addresses from dropdown selections, month tab names, or column letters generated by formulas. It powers dynamic dashboards but is volatile and easy to break with typos.
Read guide →OFFSET
OFFSET starts from a reference cell and returns a range moved by a row and column offset with optional height and width. Rolling averages, dynamic windows, and shifted blocks use OFFSET, though INDEX and FILTER are often clearer today.
Read guide →SUMIF
SUMIF totals values in a sum_range when a matching row in criteria_range meets your criterion. It is the classic single-condition sum: add column B where column A equals West. Wildcards and comparison operators work in the criterion string.
Read guide →COUNTIF
COUNTIF returns how many cells in a range meet a single criterion. It powers KPI tiles like open ticket count, rows flagged Yes, or cells above a quota. The criterion follows the same string, comparison, and wildcard rules as SUMIF.
Read guide →SUMIFS
SUMIFS adds values in sum_range only when every criteria_range passes its paired test. Argument order is sum_range first, then alternating criteria_range and criterion pairs. All conditions use AND logic: every test must be TRUE on the same row.
Read guide →COUNTIFS
COUNTIFS counts how many rows satisfy every criterion at once. You pass criteria_range1, criterion1, criteria_range2, criterion2, and so on. Unlike COUNTIF, there is no separate count range: each pair tests the same row index across the sheet.
Read guide →IF
IF evaluates a logical test and returns value_if_true when the test passes, otherwise value_if_false. It is the basic branching function for labels, safe division, and simple approvals before you reach for IFS or lookup tables.
Read guide →IFERROR
IFERROR wraps another formula and returns value_if_error when the inner expression hits any error, including #N/A, #REF!, #VALUE!, and #DIV/0!. Use it for polished dashboards. Fix the root cause when the error signals bad data you should clean.
Read guide →wildcard
Wildcard is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →wildcards
Wildcards is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →approximate match
Approximate Match is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →criteria range
Criteria Range is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →exact match
Exact Match is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →first match
First Match is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →horizontal lookup
Horizontal Lookup is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →index column
Index Column is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →last match
Last Match is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →lookup value
Lookup Value is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →match case
Match Case is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →match mode
Match Mode is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →nth match
Nth Match is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →partial match
Partial Match is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →return range
Return Range is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →search key
Search Key is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →sum range
Sum Range is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →vertical lookup
Vertical Lookup is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →wildcard match
Wildcard Match is lookup vocabulary: how MATCH, VLOOKUP, XLOOKUP, FILTER, and QUERY decide which row or value to return. Exact vs approximate match and wildcard rules change outcomes more than beginners expect.
Read guide →QUERY, arrays, and dynamic formulas
QUERY, ARRAYFORMULA, FILTER, UNIQUE, LAMBDA, and modern array helpers.
QUERY
QUERY runs a SQL-like statement against a range of cells and returns a new table of results. You pass a data range, a query string with SELECT, WHERE, ORDER BY, and optional headers. It is the fastest way to filter, sort, group, and pivot sheet data without helper columns.
Read guide →ARRAYFORMULA
ARRAYFORMULA tells Google Sheets to treat a formula as an array operation so one expression fills many cells at once. It is common with IF, VLOOKUP, and math on full columns before dynamic arrays made many patterns automatic. It still matters for legacy sheets and explicit control.
Read guide →FILTER
FILTER returns only the rows from a range that meet one or more conditions. Conditions are boolean arrays the same height as the data. FILTER spills results automatically, so it replaced many INDEX/SMALL helper-column patterns for live subsets.
Read guide →UNIQUE
UNIQUE extracts a deduplicated list from a column or table. Optional arguments control whether duplicates appear by row, by column, or with occurrence counts. It powers dropdown source lists, category tabs, and data cleanup without manual copy-paste.
Read guide →FLATTEN
FLATTEN converts a two-dimensional range into a single column, reading across rows then down. It is useful after SPLIT or when you need every value from a block in one list for UNIQUE, COUNTIF, or mail merge prep.
Read guide →SORTN
SORTN sorts a range and returns only the first N rows. You choose how many rows, which column drives the sort, and ascending or descending order. Leaderboards and best-seller reports use SORTN instead of manual sorting that goes stale.
Read guide →SEQUENCE
SEQUENCE returns a grid of sequential numbers. You set how many rows and columns, the starting value, and the step between values. It replaces manual 1, 2, 3 fill patterns and pairs well with MAP, LAMBDA, and date math for generated row labels.
Read guide →LAMBDA
LAMBDA defines an anonymous function inside a formula. You name parameters, write the calculation, then pass arguments when you call it. Combined with MAP, BYROW, or a named LAMBDA in the Name manager, it replaces fragile copy-paste logic across big tables.
Read guide →BYROW
BYROW takes an array and a LAMBDA that receives one row at a time. It returns a column of results, one per row. It is the clean way to sum across columns, test row-wide rules, or format composite keys without ARRAYFORMULA hacks.
Read guide →BYCOL
BYCOL mirrors BYROW but runs a LAMBDA on each column of a range. The result spills across one row with one value per column. Use it for column-wise stats, normalizing monthly blocks, or validating each survey question column.
Read guide →MAP
MAP walks aligned arrays element by element and applies a LAMBDA to each position. Pass one array for unary transforms or several arrays for element-wise combinations. It is the modern replacement for many ARRAYFORMULA column operations.
Read guide →REDUCE
REDUCE walks an array left to right, carrying an accumulator value updated by a LAMBDA on each step. It can implement custom aggregates, text joins with rules, or conditional running logic that SUM alone cannot express.
Read guide →SCAN
SCAN is like REDUCE but returns every intermediate accumulator in a spilled column. It powers running totals, cumulative text builds, and step-by-step counters without dragging cumulative formulas.
Read guide →MAKEARRAY
MAKEARRAY creates a grid of specified height and width, computing each cell with a LAMBDA that receives row and column indexes. It builds lookup tables, sensitivity matrices, and coordinate-driven templates without manual fill.
Read guide →TOCOL
TOCOL converts a range into a single column. You can choose whether it reads down each column first or across rows first. It replaces manual paste-special transpose chains when reshaping blocks for UNIQUE or FILTER.
Read guide →TOROW
TOROW flattens a range into a single row spill. Like TOCOL but horizontal, it helps build header arrays, SPARKLINE source rows, and inputs for functions that expect one horizontal vector.
Read guide →HSTACK
HSTACK appends arrays horizontally so columns sit side by side in one spilled table. It replaces fragile copy-paste when combining QUERY outputs, IMPORTRANGE blocks, or calculated columns with matching row heights.
Read guide →VSTACK
VSTACK stacks arrays on top of each other into one taller table. Combine regional exports, monthly snapshots, or FILTER results with the same columns without manual paste below last row.
Read guide →ARRAY_CONSTRAIN
ARRAY_CONSTRAIN wraps an array formula result and returns only the first num_rows and num_columns of that output. It prevents huge spills, fits charts to fixed ranges, and stabilizes ranges for IMPORTRANGE wrappers when you need predictable dimensions.
Read guide →LET
LET assigns names to calculated values inside one formula, then uses those names in the final expression. Repeated VLOOKUP keys, tax rates, or date bounds appear once, which shrinks formulas and can reduce recalc work on heavy sheets.
Read guide →SQL-style queries (QUERY)
The QUERY function runs a SQL-like statement against a range in your sheet. You SELECT columns, filter with WHERE, sort with ORDER BY, and aggregate with GROUP BY without building many helper columns. It is the closest native option to a small in-sheet database query.
Read guide →SORT
SORT reorders rows from an input range and spills the result elsewhere. Source data stays put, unlike Data > Sort range which edits the grid in place. Use SORT on dashboard tabs when lists should refresh automatically. For menu-driven one-time sorts, see the sorting glossary term.
Read guide →BigQuery
Bigquery is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →Col1
Col1 is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →delimiter
Delimiter is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →LABEL
Label is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →LIMIT
Limit is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →SELECT
Select is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →WHERE
Where is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →Col notation
Col Notation is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →CSS selector
Css Selector is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →current selection
Current Selection is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →data labels
Data Labels is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →ends with
Ends With is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →expand selection
Expand Selection is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →GROUP BY
Group By is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →is null
Is Null is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →LABEL clause
Label Clause is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →LIMIT clause
Limit Clause is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →OFFSET clause
Offset Clause is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →ORDER BY
Order By is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →PIVOT clause
Pivot Clause is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →print selection
Print Selection is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →query string
Query String is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →select all
Select All is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →SELECT clause
Select Clause is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →select where
Select Where is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →selected range
Selected Range is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →skipping headers
Skipping Headers is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →split delimiter
Split Delimiter is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →starts with
Starts With is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →WHERE clause
Where Clause is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →XPath query
Xpath Query is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →GROUP BY clause
Group By Clause is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →Group by month
Group By Month is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →Group by quarter
Group By Quarter is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →Group by year
Group By Year is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →ORDER BY clause
Order By Clause is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →repeat row labels
Repeat Row Labels is part of the SQL-like QUERY function language in Google Sheets. QUERY reads a range with SELECT, WHERE, GROUP BY, ORDER BY, and LABEL clauses instead of nested spreadsheet functions.
Read guide →Formula basics and data cleanup
Syntax, sorting, grouping, normalization, and defaults.
Google Sheets formulas
A formula is an instruction in a cell that calculates a result from other cells, ranges, or built-in functions. Every formula begins with =. When inputs change, the sheet recalculates so dashboards and models stay live without manual copy-paste. Formulas are the default automation layer inside the grid before Apps Script or add-ons.
Read guide →Google Sheets formula syntax
Every formula starts with = followed by a function name and arguments in parentheses. Ranges use A1 notation, text sits in quotes, and operators like + and & combine values. Sheets recalculates when inputs change, so syntax errors show as #NAME? or #ERROR! in the cell.
Read guide →Google Sheets formula generator
A formula generator is a guided tool that turns your plain-language inputs into a working Google Sheets formula you can paste into a cell. Instead of memorizing argument order for QUERY, REGEXMATCH, or conditional formatting rules, you pick options and copy the result. Better Sheets hosts generators for common high-friction patterns on the homepage and tool catalog.
Read guide →filters in Google Sheets
Filtering hides rows that do not match criteria without deleting data. The filter toolbar on a header row is the fastest UI path. FILTER and QUERY formulas build dynamic views that update when source data changes, which suits dashboards and reporting tabs.
Read guide →sorting data in Sheets
Sorting reorders rows by one or more columns. The Data > Sort range menu sorts selection in place. The SORT function returns a sorted copy that updates when inputs change. Always decide whether related columns must move together as a single row unit.
Read guide →grouping rows in Sheets
Row and column grouping adds outline controls on the left or top edge so readers expand or collapse sections. It is a presentation layer: formulas still see all cells whether collapsed or not. Grouping suits budgets, project plans, and any sheet with detail rows under subtotal headers.
Read guide →normalizing data in Sheets
Normalizing means making inconsistent inputs follow one reliable shape: same date format, trimmed text, unique keys, one fact per row, and separate columns for categories that were crammed into one field. Clean data makes VLOOKUP, QUERY, and dashboards dependable.
Read guide →default values in Sheets
Default values fill gaps when a cell is empty or pre-populate new rows with standard choices. Use IFBLANK in formulas, data validation lists with a suggested first option, template row copy, or ARRAYFORMULA that writes a fallback until someone overrides manually.
Read guide →TRUNC
TRUNC chops off digits after a chosen decimal place without rounding up or down. TRUNC(3.99) is 3, not 4. Use negative place values to truncate to tens, hundreds, or thousands. It is common in pricing tiers, ID bucketing, and reports where rounding would misstate totals.
Read guide →argument
Argument is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →arguments
Arguments is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →arrays
Array formulas compute across many cells at once. Google Sheets now spills results automatically; older CSE array habits still appear in legacy tutorials.
Read guide →condition
Condition is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →criteria
Criteria is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →expression
Expression is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →expressions
Expressions is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →iteration
Recalculation settings control when Sheets recomputes formulas after edits. Manual calc and iteration are advanced workbook behaviors; most sheets stay on automatic recalc.
Read guide →operand
Operand is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →operator
Operator is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →operators
Operators is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →recalc
Recalculation settings control when Sheets recomputes formulas after edits. Manual calc and iteration are advanced workbook behaviors; most sheets stay on automatic recalc.
Read guide →spilled
A spill range is the block of cells a dynamic-array formula fills automatically. If something is already in the spill path, Sheets shows a #SPILL! error. See the spill glossary page for fixes.
Read guide →spilling
A spill range is the block of cells a dynamic-array formula fills automatically. If something is already in the spill path, Sheets shows a #SPILL! error. See the spill glossary page for fixes.
Read guide →3D formula
3d Formula is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →argument separator
Argument Separator is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →arithmetic operator
Arithmetic Operator is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →array syntax
Array formulas compute across many cells at once. Google Sheets now spills results automatically; older CSE array habits still appear in legacy tutorials.
Read guide →auto spill
A spill range is the block of cells a dynamic-array formula fills automatically. If something is already in the spill path, Sheets shows a #SPILL! error. See the spill glossary page for fixes.
Read guide →average range
Average Range is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →binary operator
Binary Operator is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →block spill
A spill range is the block of cells a dynamic-array formula fills automatically. If something is already in the spill path, Sheets shows a #SPILL! error. See the spill glossary page for fixes.
Read guide →comparison operator
Comparison Operator is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →concatenation operator
Concatenation Operator is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →copy formula
Copy Formula is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →count range
Count Range is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →cross-sheet formula
Cross-sheet Formula is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →CSE array
Array formulas compute across many cells at once. Google Sheets now spills results automatically; older CSE array habits still appear in legacy tutorials.
Read guide →custom functions
Custom Functions is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →date literal
Date Literal is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →date series
Date Series is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →display value
Display Value is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →dynamic array
Dynamic arrays let one formula return many cells that spill into neighboring empty space. FILTER, UNIQUE, SORT, and SEQUENCE are common spillers in modern Google Sheets.
Read guide →dynamic arrays
Dynamic arrays let one formula return many cells that spill into neighboring empty space. FILTER, UNIQUE, SORT, and SEQUENCE are common spillers in modern Google Sheets.
Read guide →enable iterative
Recalculation settings control when Sheets recomputes formulas after edits. Manual calc and iteration are advanced workbook behaviors; most sheets stay on automatic recalc.
Read guide →equals sign
Equals Sign is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →evaluate formula
Evaluate Formula is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →exponent operator
Exponent Operator is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →formula auditing
Formula Auditing is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →formula autocomplete
This is part of how you write and inspect formulas in the Google Sheets UI, from the fx button to the formula bar and inline suggestions. Use these tools to debug syntax before errors spread through a model.
Read guide →formula nesting
A nested formula places one function inside another, like IF inside SUMIF. Deep nesting gets hard to read; helper columns or LET often simplify the same logic.
Read guide →formula suggestions
This is part of how you write and inspect formulas in the Google Sheets UI, from the fx button to the formula bar and inline suggestions. Use these tools to debug syntax before errors spread through a model.
Read guide →formula view
Formula View is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →formulas only
Formulas Only is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →fx button
This is part of how you write and inspect formulas in the Google Sheets UI, from the fx button to the formula bar and inline suggestions. Use these tools to debug syntax before errors spread through a model.
Read guide →Generate formula
Generate Formula is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →growth series
Growth Series is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →helper column
A helper column (or row/sheet) is extra space you add to break a hard problem into simple steps. Intermediate formulas live there so your final formula stays short and readable.
Read guide →helper row
A helper column (or row/sheet) is extra space you add to break a hard problem into simple steps. Intermediate formulas live there so your final formula stays short and readable.
Read guide →helper sheet
A helper column (or row/sheet) is extra space you add to break a hard problem into simple steps. Intermediate formulas live there so your final formula stays short and readable.
Read guide →implicit intersection
Implicit Intersection is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →intersection formula
Intersection Formula is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →intersection operator
Intersection Operator is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →iteration threshold
Recalculation settings control when Sheets recomputes formulas after edits. Manual calc and iteration are advanced workbook behaviors; most sheets stay on automatic recalc.
Read guide →LAMBDA helper
A helper column (or row/sheet) is extra space you add to break a hard problem into simple steps. Intermediate formulas live there so your final formula stays short and readable.
Read guide →leading apostrophe
Leading Apostrophe is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →leading equals
Leading Equals is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →leading zeros
Leading Zeros is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →legacy array
Array formulas compute across many cells at once. Google Sheets now spills results automatically; older CSE array habits still appear in legacy tutorials.
Read guide →linear series
Linear Series is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →logical operator
Logical Operator is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →manual calc
Recalculation settings control when Sheets recomputes formulas after edits. Manual calc and iteration are advanced workbook behaviors; most sheets stay on automatic recalc.
Read guide →manual calculation
Recalculation settings control when Sheets recomputes formulas after edits. Manual calc and iteration are advanced workbook behaviors; most sheets stay on automatic recalc.
Read guide →max iterations
Recalculation settings control when Sheets recomputes formulas after edits. Manual calc and iteration are advanced workbook behaviors; most sheets stay on automatic recalc.
Read guide →multi-cell array
Array formulas compute across many cells at once. Google Sheets now spills results automatically; older CSE array habits still appear in legacy tutorials.
Read guide →named formula
Named Formula is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →nested formula
A nested formula places one function inside another, like IF inside SUMIF. Deep nesting gets hard to read; helper columns or LET often simplify the same logic.
Read guide →null values
Null Values is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →number series
Number Series is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →operator precedence
Operator Precedence is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →range operator
Range Operator is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →recalc interval
Recalculation settings control when Sheets recomputes formulas after edits. Manual calc and iteration are advanced workbook behaviors; most sheets stay on automatic recalc.
Read guide →recalc workbook
Recalculation settings control when Sheets recomputes formulas after edits. Manual calc and iteration are advanced workbook behaviors; most sheets stay on automatic recalc.
Read guide →reusable formula
Reusable Formula is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →reusable lambda
Reusable Lambda is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →sheet operator
Sheet Operator is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →show formulas
This is part of how you write and inspect formulas in the Google Sheets UI, from the fx button to the formula bar and inline suggestions. Use these tools to debug syntax before errors spread through a model.
Read guide →single-cell array
Array formulas compute across many cells at once. Google Sheets now spills results automatically; older CSE array habits still appear in legacy tutorials.
Read guide →spill collision
A spill range is the block of cells a dynamic-array formula fills automatically. If something is already in the spill path, Sheets shows a #SPILL! error. See the spill glossary page for fixes.
Read guide →spill down
A spill range is the block of cells a dynamic-array formula fills automatically. If something is already in the spill path, Sheets shows a #SPILL! error. See the spill glossary page for fixes.
Read guide →spill operator
A spill range is the block of cells a dynamic-array formula fills automatically. If something is already in the spill path, Sheets shows a #SPILL! error. See the spill glossary page for fixes.
Read guide →spill range
A spill range is the block of cells a dynamic-array formula fills automatically. If something is already in the spill path, Sheets shows a #SPILL! error. See the spill glossary page for fixes.
Read guide →spilled array
A spill range is the block of cells a dynamic-array formula fills automatically. If something is already in the spill path, Sheets shows a #SPILL! error. See the spill glossary page for fixes.
Read guide →stored value
Stored Value is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →text equals
Text Equals is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →trailing blanks
Trailing Blanks is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →type coercion
Type Coercion is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →unary minus
Unary Minus is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →union formula
Union Formula is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →union operator
Union Operator is part of how Sheets parses formulas: what gets calculated first, and which symbols combine values. Parentheses still beat default precedence when in doubt.
Read guide →view formulas
This is part of how you write and inspect formulas in the Google Sheets UI, from the fx button to the formula bar and inline suggestions. Use these tools to debug syntax before errors spread through a model.
Read guide →custom formula is
Custom Formula Is is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →show formulas bar
This is part of how you write and inspect formulas in the Google Sheets UI, from the fx button to the formula bar and inline suggestions. Use these tools to debug syntax before errors spread through a model.
Read guide →argument placeholders
Argument Placeholders extends Google Sheets named functions: reusable custom formulas with placeholders and shared definitions. They let teams package logic without repeating long lambda blocks.
Read guide →formula definition
Formula Definition extends Google Sheets named functions: reusable custom formulas with placeholders and shared definitions. They let teams package logic without repeating long lambda blocks.
Read guide →import named functions
Import Named Functions extends Google Sheets named functions: reusable custom formulas with placeholders and shared definitions. They let teams package logic without repeating long lambda blocks.
Read guide →separator
Separator is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →blank cells
Blank Cells is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →clean data
Clean Data is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →data cleanup
Data Cleanup is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →decimal separator
Decimal Separator is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →duplicate values
Duplicate Values is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →empty cells
Empty Cells is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →list separator
List Separator is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →Randomize range
Randomize Range is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →remove duplicates
Remove Duplicates is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →separator detection
Separator Detection is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →separator type
Separator Type is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →split text
Split Text is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →trim whitespace
Trim Whitespace is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →unique values
Unique Values is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →numbers to text
Numbers To Text is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →text to columns
Text To Columns is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →text to numbers
Text To Numbers is a data cleanup or sheet operation in Google Sheets: trimming text, splitting columns, removing duplicates, or fixing separators. Cleanup steps usually happen before analysis formulas run.
Read guide →calculation
Calculation is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →calculations
Calculations is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →cells
Cells is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →data
Data is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →dataset
Dataset is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →field
Field is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →fields
Fields is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →function
Function is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →functions
Functions is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →grid
Grid is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →header
Header is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →headers
Headers is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →number
Number is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →parameter
Parameter is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →parameters
Parameters is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →range
Range is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →ranges
Ranges is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →record
Record is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →records
Records is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →spreadsheet
Spreadsheet is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →string
String is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →tab
Tab is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →table
Table is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →values
Values is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →worksheet
Worksheet is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →worksheets
Worksheets is a core spreadsheet object in Google Sheets: the building blocks of every workbook. Sheets, tabs, rows, columns, cells, ranges, and values are the vocabulary every other feature builds on.
Read guide →advanced options
Advanced Options is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →conditional drop-down
Conditional Drop-down is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →custom list
Custom List is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →edit links
Edit Links is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →File info
File Info is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →find next
Find Next is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →last edited
Last Edited is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →Maxpoint value
Maxpoint Value is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →Midpoint value
Midpoint Value is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →Minpoint value
Minpoint Value is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →Move to
Move To is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →number between
Number Between is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →offline editing
Offline Editing is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →offline mode
Offline Mode is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →OPTIONS clause
Options Clause is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →range parameter
Range Parameter is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →replace data
Replace Data is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →search mode
Search Mode is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →Send form
Send Form is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →sheet name
Sheet Name is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →show as
Show As is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →show sheet
Show Sheet is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →source data
Source Data is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →summarize by
Summarize By is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →text contains
Text Contains is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →update values
Update Values is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →1900 date system
1900 Date System is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →Add a sheet
Add A Sheet is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →Add to columns
Add To Columns is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →Add to rows
Add To Rows is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →Add to values
Add To Values is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →append to current
Append To Current is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →apply to range
Apply To Range is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →Ask a question
Ask A Question is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →create new sheet
Create New Sheet is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →except certain cells
Except Certain Cells is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →HTML table index
Html Table Index is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →insert cut cells
Insert Cut Cells is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →is not null
Is Not Null is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →list of items
List Of Items is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →load to sheet
Load To Sheet is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →repeat frozen rows
Repeat Frozen Rows is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →show a warning
Show A Warning is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →show help text
Show Help Text is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →template copy link
Template Copy Link is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →text is valid
Text Is Valid is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →Use row 1
Use Row 1 is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →value as text
Value As Text is endemic Google Sheets jargon you may see in dialogs, pivot editors, QUERY help, or sharing screens. It names a specific control or option rather than a whole product feature.
Read guide →Stuck mid-formula?
Search tutorials for the term you need, or unlock the full Better Sheets library.
Errors, spills, and references
Fix #REF!, #N/A, spills, volatile functions, and locale quirks.
#REF! error
#REF! means a formula references a cell or range that no longer exists. Common causes include deleted rows or columns, removed sheets, broken IMPORTRANGE, or cut-paste that orphaned an address. The error spreads to every dependent formula until you repair the link.
Read guide →#N/A error
#N/A means not available: the formula ran but could not find a match. Lookup functions return #N/A when a key is missing from the table. Sometimes that is correct. Often it signals typos, extra spaces, or numbers stored as text.
Read guide →#VALUE! error
#VALUE! means Google Sheets cannot interpret an argument as the type the function expects. Common causes include text in a math formula, invalid dates, wrong delimiter locale, or passing a range where a scalar is required.
Read guide →#DIV/0! error
#DIV/0! appears when a formula divides by zero or by an empty cell treated as zero. It is common in conversion rate, cost-per-unit, and percent-change columns when the denominator can be blank on new rows.
Read guide →#NAME? error
#NAME? means Google Sheets does not recognize a name in your formula. That can be a misspelled function, a named range that does not exist, text used without quotes, or a function name from the wrong language locale.
Read guide →Formula errors in Google Sheets
Formula errors are typed messages in cells when something prevents a valid result. Each code points to a different failure mode: bad reference, missing lookup, type mismatch, divide by zero, unknown name, or blocked array spill. Learning the vocabulary speeds debugging and keeps dashboards trustworthy for decision makers.
Read guide →#SPILL! error
#SPILL! means a dynamic array formula tried to fill multiple cells but something blocked the spill range. Another value, merged cells, or a table in the way stops the output. Clear the obstruction or move the formula to open space.
Read guide →Volatile functions
Volatile functions recalculate whenever Sheets recalculates the sheet, not only when their direct arguments change. NOW, TODAY, RAND, RANDBETWEEN, OFFSET, and INDIRECT are common examples. Heavy use in large ARRAYFORMULA columns can make shared files feel sluggish and make results change on every edit.
Read guide →Open range reference
An open range reference points at an entire row, column, or unbounded slice such as B:B or 2:2 instead of a fixed rectangle like B2:B500. Formulas with open ranges include every cell in that line, which is convenient for growing tables but expensive and risky when stray values live far below your data.
Read guide →Absolute reference ($)
Absolute references lock row, column, or both with dollar signs so a formula keeps pointing at the same cell when you copy it. $A$1 locks both axes. A$1 locks the row. $A1 locks the column. Mixed locks are how tax rates stay in one settings cell while a formula fills down a thousand rows.
Read guide →Array literal
An array literal is an inline constant array written with curly braces, for example {1,2,3} across columns or {1;2;3} down rows. Semicolons separate rows and commas separate columns in US locale. Array literals feed functions expecting ranges without placing values on the grid first.
Read guide →Locale separators
Locale controls whether function arguments separate with commas or semicolons and whether decimals use dot or comma. A sheet set to France may expect =SUM(A1;A10) while US expects =SUM(A1,A10). CSV imports and array literals also clash when decimal commas meet comma separators. File > Settings > Locale sets the default behavior for new formulas in that file.
Read guide →addresses
Addresses describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →cross-sheet
A sheet reference points a formula at another tab or workbook. Cross-sheet and 3D references let one formula read data spread across tabs. IMPORTRANGE and internal sheet names like 'Sales'!A:A are the usual Google Sheets patterns.
Read guide →notation
A1 notation names cells with letters for columns and numbers for rows, like C5. R1C1 notation names cells by row and column index instead. Google Sheets shows and accepts A1 style in the formula bar for almost all work.
Read guide →precedents
Precedents is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →R1C1
A1 notation names cells with letters for columns and numbers for rows, like C5. R1C1 notation names cells by row and column index instead. Google Sheets shows and accepts A1 style in the formula bar for almost all work.
Read guide →reference
Reference describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →references
References describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →selection
Selection is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →3D reference
A sheet reference points a formula at another tab or workbook. Cross-sheet and 3D references let one formula read data spread across tabs. IMPORTRANGE and internal sheet names like 'Sales'!A:A are the usual Google Sheets patterns.
Read guide →A1 notation
A1 notation names cells with letters for columns and numbers for rows, like C5. R1C1 notation names cells by row and column index instead. Google Sheets shows and accepts A1 style in the formula bar for almost all work.
Read guide →A1 style
A1 notation names cells with letters for columns and numbers for rows, like C5. R1C1 notation names cells by row and column index instead. Google Sheets shows and accepts A1 style in the formula bar for almost all work.
Read guide →absolute column
An absolute reference keeps a row, column, or both fixed when you copy a formula, usually with dollar signs in A1 notation. Use it when a formula should always point at one anchor cell, like a tax rate in $B$1. See also the absolute-reference glossary page.
Read guide →absolute references
An absolute reference keeps a row, column, or both fixed when you copy a formula, usually with dollar signs in A1 notation. Use it when a formula should always point at one anchor cell, like a tax rate in $B$1. See also the absolute-reference glossary page.
Read guide →absolute row
An absolute reference keeps a row, column, or both fixed when you copy a formula, usually with dollar signs in A1 notation. Use it when a formula should always point at one anchor cell, like a tax rate in $B$1. See also the absolute-reference glossary page.
Read guide →active cell
Active Cell is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →active range
Active Range is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →active sheet
A sheet reference points a formula at another tab or workbook. Cross-sheet and 3D references let one formula read data spread across tabs. IMPORTRANGE and internal sheet names like 'Sales'!A:A are the usual Google Sheets patterns.
Read guide →active spreadsheet
A sheet reference points a formula at another tab or workbook. Cross-sheet and 3D references let one formula read data spread across tabs. IMPORTRANGE and internal sheet names like 'Sales'!A:A are the usual Google Sheets patterns.
Read guide →broken reference
Broken Reference describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →cell reference
Cell Reference is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →circular references
Circular References describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →closed range
Closed Range is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →column index
Column Index describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →column letter
Column Letter is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →contiguous range
Contiguous Range is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →corner cell
Corner Cell is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →cross-sheet reference
A sheet reference points a formula at another tab or workbook. Cross-sheet and 3D references let one formula read data spread across tabs. IMPORTRANGE and internal sheet names like 'Sales'!A:A are the usual Google Sheets patterns.
Read guide →current sheet
A sheet reference points a formula at another tab or workbook. Cross-sheet and 3D references let one formula read data spread across tabs. IMPORTRANGE and internal sheet names like 'Sales'!A:A are the usual Google Sheets patterns.
Read guide →data range
Data Range is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →data region
Data Region describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →define name
A defined name is a readable label for a cell or range, like TaxRate instead of Sheet1!$B$1. Named ranges make formulas easier to audit and show up in the named ranges side panel.
Read guide →defined name
A defined name is a readable label for a cell or range, like TaxRate instead of Sheet1!$B$1. Named ranges make formulas easier to audit and show up in the named ranges side panel.
Read guide →destination range
Destination Range is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →dollar lock
An absolute reference keeps a row, column, or both fixed when you copy a formula, usually with dollar signs in A1 notation. Use it when a formula should always point at one anchor cell, like a tax rate in $B$1. See also the absolute-reference glossary page.
Read guide →dollar sign
An absolute reference keeps a row, column, or both fixed when you copy a formula, usually with dollar signs in A1 notation. Use it when a formula should always point at one anchor cell, like a tax rate in $B$1. See also the absolute-reference glossary page.
Read guide →entire column
Entire Column describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →entire row
Entire Row describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →external reference
A sheet reference points a formula at another tab or workbook. Cross-sheet and 3D references let one formula read data spread across tabs. IMPORTRANGE and internal sheet names like 'Sales'!A:A are the usual Google Sheets patterns.
Read guide →full column
Full Column describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →full row
Full Row describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →Full screen
Full Screen describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →index number
Index Number describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →infinite range
Infinite Range is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →lock column
An absolute reference keeps a row, column, or both fixed when you copy a formula, usually with dollar signs in A1 notation. Use it when a formula should always point at one anchor cell, like a tax rate in $B$1. See also the absolute-reference glossary page.
Read guide →lock reference
An absolute reference keeps a row, column, or both fixed when you copy a formula, usually with dollar signs in A1 notation. Use it when a formula should always point at one anchor cell, like a tax rate in $B$1. See also the absolute-reference glossary page.
Read guide →lock row
An absolute reference keeps a row, column, or both fixed when you copy a formula, usually with dollar signs in A1 notation. Use it when a formula should always point at one anchor cell, like a tax rate in $B$1. See also the absolute-reference glossary page.
Read guide →mixed reference
A mixed reference locks either the row or the column but not both, so one part of the address can change when you copy the formula. It is common in rate tables and lookups where only one direction should slide.
Read guide →open-ended range
Open-ended Range is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →precedent cells
Precedent Cells is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →R1C1 notation
A1 notation names cells with letters for columns and numbers for rows, like C5. R1C1 notation names cells by row and column index instead. Google Sheets shows and accepts A1 style in the formula bar for almost all work.
Read guide →R1C1 style
A1 notation names cells with letters for columns and numbers for rows, like C5. R1C1 notation names cells by row and column index instead. Google Sheets shows and accepts A1 style in the formula bar for almost all work.
Read guide →range reference
Range Reference is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →relative column
A relative reference moves when you copy a formula because row and column offsets stay the same, not the exact cell address. Google Sheets uses A1-style addresses like B2 by default. Relative refs are the normal choice for formulas you plan to fill down or across.
Read guide →relative reference
A relative reference moves when you copy a formula because row and column offsets stay the same, not the exact cell address. Google Sheets uses A1-style addresses like B2 by default. Relative refs are the normal choice for formulas you plan to fill down or across.
Read guide →relative references
A relative reference moves when you copy a formula because row and column offsets stay the same, not the exact cell address. Google Sheets uses A1-style addresses like B2 by default. Relative refs are the normal choice for formulas you plan to fill down or across.
Read guide →relative row
A relative reference moves when you copy a formula because row and column offsets stay the same, not the exact cell address. Google Sheets uses A1-style addresses like B2 by default. Relative refs are the normal choice for formulas you plan to fill down or across.
Read guide →result range
Result Range is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →row number
Row Number is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →sheet reference
A sheet reference points a formula at another tab or workbook. Cross-sheet and 3D references let one formula read data spread across tabs. IMPORTRANGE and internal sheet names like 'Sales'!A:A are the usual Google Sheets patterns.
Read guide →structured reference
Structured Reference describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →table reference
Table Reference describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →used range
Used Range is spreadsheet jargon for a references & addressing idea in Google Sheets. You will see it in menus, formula help, or tutorials when working with data in the grid. Knowing the term helps you search docs and match UI labels to what your sheet is doing.
Read guide →whole column
Whole Column describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →whole row
Whole Row describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →full column reference
Full Column Reference describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →full row reference
Full Row Reference describes how a formula or selection points at cells, columns, rows, or sheets in Google Sheets. References are the addresses inside formulas and the blue boxes you see when editing. Getting references right prevents #REF! errors and broken copies.
Read guide →named ranges panel
A defined name is a readable label for a cell or range, like TaxRate instead of Sheet1!$B$1. Named ranges make formulas easier to audit and show up in the named ranges side panel.
Read guide →quoted sheet name
A sheet reference points a formula at another tab or workbook. Cross-sheet and 3D references let one formula read data spread across tabs. IMPORTRANGE and internal sheet names like 'Sales'!A:A are the usual Google Sheets patterns.
Read guide →#CIRCULAR!
#CIRCULAR! means a formula chain loops back on itself. Sheets blocks the loop until you break the cycle or enable iterative calculation for intentional circular models.
Read guide →#ERROR
A generic #ERROR! means Sheets could not parse or evaluate the expression. Check parentheses, quotes, and locale separators first.
Read guide →#ERROR!
A generic #ERROR! means Sheets could not parse or evaluate the expression. Check parentheses, quotes, and locale separators first.
Read guide →#LOADING
#LOADING appears while an external or slow function is still fetching data. It usually clears when the import finishes.
Read guide →#NULL!
#NULL! means two ranges do not intersect where the formula expected an overlap, often from a mistyped space operator between references.
Read guide →#NUM!
#NUM! means the formula hit an invalid numeric result, like a root of a negative number or a number too large to represent.
Read guide →circular error
#CIRCULAR! means a formula chain loops back on itself. Sheets blocks the loop until you break the cycle or enable iterative calculation for intentional circular models.
Read guide →circular warning
#CIRCULAR! means a formula chain loops back on itself. Sheets blocks the loop until you break the cycle or enable iterative calculation for intentional circular models.
Read guide →error bars
Error Bars is part of how Google Sheets surfaces formula problems, warnings, or diagnostics. Catching the message early keeps bad values from flowing into dashboards and reports.
Read guide →error checking
Error Checking is part of how Google Sheets surfaces formula problems, warnings, or diagnostics. Catching the message early keeps bad values from flowing into dashboards and reports.
Read guide →loading error
#LOADING appears while an external or slow function is still fetching data. It usually clears when the import finishes.
Read guide →loading indicator
#LOADING appears while an external or slow function is still fetching data. It usually clears when the import finishes.
Read guide →null error
Null Error is part of how Google Sheets surfaces formula problems, warnings, or diagnostics. Catching the message early keeps bad values from flowing into dashboards and reports.
Read guide →num error
Num Error is part of how Google Sheets surfaces formula problems, warnings, or diagnostics. Catching the message early keeps bad values from flowing into dashboards and reports.
Read guide →parse error
Parse Error is part of how Google Sheets surfaces formula problems, warnings, or diagnostics. Catching the message early keeps bad values from flowing into dashboards and reports.
Read guide →syntax error
Syntax Error is part of how Google Sheets surfaces formula problems, warnings, or diagnostics. Catching the message early keeps bad values from flowing into dashboards and reports.
Read guide →error checking options
Error Checking Options is part of how Google Sheets surfaces formula problems, warnings, or diagnostics. Catching the message early keeps bad values from flowing into dashboards and reports.
Read guide →formula parse error
Formula Parse Error is part of how Google Sheets surfaces formula problems, warnings, or diagnostics. Catching the message early keeps bad values from flowing into dashboards and reports.
Read guide →Import and external data functions
Pull data from other sheets, URLs, feeds, and the web into your grid.
IMPORTRANGE
IMPORTRANGE loads values from a range in another Google spreadsheet into your current file. You pass the spreadsheet URL or key plus a range string with an optional sheet name. After you grant access once, the link stays live and updates when the source changes.
Read guide →IMPORTHTML
IMPORTHTML fetches a public web page and returns a table or list from its HTML. You provide the URL, the query type (table or list), and the index of which table or list on the page to import. It is a quick scraper for simple pages without writing Apps Script.
Read guide →IMPORTXML
IMPORTXML fetches a URL and returns data matching an XPath query. You can scrape page titles, meta tags, table cells, or RSS-style XML fields. It is more precise than IMPORTHTML when you need one value or a repeating node set from structured markup.
Read guide →IMPORTDATA
IMPORTDATA retrieves a text file from a web address and parses it into sheet cells. It works with comma- or tab-separated values published at a stable URL. Government open data, published exports, and simple report endpoints are common sources.
Read guide →IMPORTFEED
IMPORTFEED reads an RSS or Atom syndication URL and returns feed items in a table. You can request specific fields like titles, URLs, authors, or dates using query parameters. It is handy for lightweight media monitoring without a dedicated news tool.
Read guide →GOOGLEFINANCE
GOOGLEFINANCE connects your sheet to Google market data. Pass a ticker symbol, an attribute like price or volume, and optional date range arguments for historical quotes. Portfolio trackers and FX dashboards use it to avoid manual price copy-paste.
Read guide →GOOGLETRANSLATE
GOOGLETRANSLATE calls Google Translate from a formula. You pass source text and optional source and target language codes. It is useful for quick catalog localization, support ticket summaries, or multilingual label columns without leaving the spreadsheet.
Read guide →Connected Sheets
Connected Sheets lets you explore very large datasets from BigQuery (and related Google Cloud sources) through a Sheets interface with extracts, pivot-style analysis, and scheduled refresh. You work with a connected tab instead of pasting millions of rows into the grid. It targets analysts who outgrow IMPORTRANGE but still want a spreadsheet UX.
Read guide →PV
PV returns the present value of an investment or loan given a constant interest rate and periodic payments. You pass rate per period, number of periods, payment amount, optional future value, and end-or-beginning timing. Finance models use PV to compare deals, price annuities, and sanity-check loan offers in Sheets.
Read guide →connection settings
Connection Settings is Connected Sheets vocabulary for BigQuery-backed extracts, refresh schedules, and connector settings. Connected Sheets keeps large warehouse data queryable inside the familiar grid.
Read guide →data connectors
Data Connectors is Connected Sheets vocabulary for BigQuery-backed extracts, refresh schedules, and connector settings. Connected Sheets keeps large warehouse data queryable inside the familiar grid.
Read guide →data extract
Data Extract is Connected Sheets vocabulary for BigQuery-backed extracts, refresh schedules, and connector settings. Connected Sheets keeps large warehouse data queryable inside the familiar grid.
Read guide →data source
Data Source is Connected Sheets vocabulary for BigQuery-backed extracts, refresh schedules, and connector settings. Connected Sheets keeps large warehouse data queryable inside the familiar grid.
Read guide →extract editor
Extract Editor is Connected Sheets vocabulary for BigQuery-backed extracts, refresh schedules, and connector settings. Connected Sheets keeps large warehouse data queryable inside the familiar grid.
Read guide →refresh options
Refresh Options is Connected Sheets vocabulary for BigQuery-backed extracts, refresh schedules, and connector settings. Connected Sheets keeps large warehouse data queryable inside the familiar grid.
Read guide →scheduled refresh
Scheduled Refresh is Connected Sheets vocabulary for BigQuery-backed extracts, refresh schedules, and connector settings. Connected Sheets keeps large warehouse data queryable inside the familiar grid.
Read guide →Text and regex functions
SPLIT, TEXTJOIN, REGEXMATCH, REGEXEXTRACT, REGEXREPLACE, and regex concepts.
CHAR
CHAR takes a number and returns the matching character from the Unicode table. Pair it with REPT or SPARKLINE to build progress bars, dividers, and icon columns without pasting symbols by hand. Better Sheets character tools preview codes before you lock a formula into production tabs.
Read guide →SPLIT
SPLIT divides one text cell into multiple cells spilled across columns using a delimiter such as comma, space, or custom string. It is the formula version of Text to columns for live data like tags, full names, or combined codes.
Read guide →TEXTJOIN
TEXTJOIN merges many text values into one string with a delimiter between them. The ignore_empty argument skips blanks so you do not get double commas. It builds display labels, CSV-like rows, and summary lines from wide tables.
Read guide →REGEXMATCH
REGEXMATCH returns TRUE or FALSE when text matches a regular expression pattern. Use it in FILTER, IF, and COUNTIF to validate emails, extract structure flags, or flag messy imports before they break downstream reports.
Read guide →REGEXEXTRACT
REGEXEXTRACT returns the portion of text that matches a regular expression, often using capture groups to pull IDs, domains, or codes from longer strings. It replaces manual LEFT/RIGHT/MID chains when patterns repeat.
Read guide →REGEXREPLACE
REGEXREPLACE finds text matching a regex pattern and replaces it with new text. Strip non-digits from phones, normalize spaces, or remove tags from HTML snippets in bulk without one-off find-and-replace menus.
Read guide →regex in Google Sheets
Regular expressions (regex) describe text patterns. Google Sheets exposes them through REGEXMATCH (test), REGEXEXTRACT (pull a substring), and REGEXREPLACE (swap text). They shine when TRIM and SPLIT are not enough for inconsistent labels, URLs, or log lines.
Read guide →SWITCH
SWITCH evaluates an expression against a list of case values and returns the result for the first match. A default value catches everything else. It cleans up nested IF chains when you compare one cell to many constants like status codes.
Read guide →IFS
IFS runs several condition-result pairs in order and returns the result for the first condition that is TRUE. It replaces long nested IF trees for tiered scoring, bonus bands, and SLA buckets where each step tests a comparison.
Read guide →CONCAT
CONCAT joins two or more text values into one string. CONCATENATE is the older name for the same job in many workbooks. The ampersand operator (&) also joins values. For lists with delimiters and empty cells skipped, TEXTJOIN is often cleaner.
Read guide →Sparklines, images, and links
Mini charts, IMAGE, HYPERLINK, and visual formula patterns.
SPARKLINE
SPARKLINE draws a miniature chart inside one cell from a row or column of numbers. Choose line, column, bar, or winloss types and pass an options object for color, axis, and markers. Dashboard tables use sparklines to show trend without full charts.
Read guide →IMAGE
IMAGE fetches a picture from a public URL and renders it inside a cell. Modes control fit, stretch, and custom height. Product catalogs, team directories, and asset trackers use IMAGE to show thumbnails beside SKUs without manual insert image menus.
Read guide →HYPERLINK
HYPERLINK builds a clickable link in a cell. Pass a URL and optional friendly label text. Reports use it for open invoice, view doc, or mailto support links without ugly raw URLs filling the grid.
Read guide →progress bars in cells
In-cell progress bars show completion as a mini chart inside one cell using SPARKLINE bar charts, REPT block characters, or colored bars driven by percent complete. They turn a number like 0.72 into a visual stripe readers grasp faster than raw decimals on dashboards and habit trackers.
Read guide →visual formulas in Sheets
Visual formulas are spreadsheet layouts where the formula output is meant to be seen, not just calculated: sparkline strips, emoji status icons, color scales, and REPT bars that communicate trend and health at a glance. They sit between raw numbers and full chart objects for dense dashboards.
Read guide →character playground
The character playground is a Better Sheets tool for browsing symbols, previewing CHAR and REPT patterns, and copying formulas before they land in your spreadsheet. Homepage visitors use it to explore kawaii, geometric, and utility characters without guessing Unicode codes in an empty cell.
Read guide →Format, protect, and share
Conditional formatting, validation, protection, publishing, and clones.
conditional formatting
Conditional formatting changes how cells look when they meet rules you define, such as values above a target or dates in the past. It helps scanners spot problems fast without writing values into extra helper columns. Rules can be simple comparisons or custom formulas that reference other sheets.
Read guide →dropdowns / data validation
Data validation restricts what people can type in a cell. A dropdown is the friendly face of that feature: pick from a list instead of free text. It keeps statuses, categories, and owners consistent so filters, pivot tables, and scripts do not break on typos.
Read guide →protect sheets/ranges
Protection limits who can edit specific cells, ranges, or entire tabs while others keep view or comment access. It is how you let teammates update input columns without touching formula blocks, summary rows, or archived data. Protection is not encryption; owners and editors with rights can still adjust protections.
Read guide →Google Sheets URL
A Google Sheets URL is the web address for a spreadsheet file or a specific view of it. Share URLs control who can open the file. Export URLs download CSV or PDF snapshots. Hackable URL parameters can jump to a tab, pre-fill filters, or embed a chart if you know the pattern. Treat URLs like keys when edit or copy access is enabled.
Read guide →Google Sheets URL Hacks
URL hacks are extra parameters you add to a Google Sheets link to control what opens: a specific tab, a highlighted range, a prefilled form, or an export format. They save clicks when you embed links in docs, SOPs, or buttons. They do not bypass sharing: viewers still need access to the file.
Read guide →cell formatting
Cell formatting controls how values display without necessarily changing the stored value underneath. Currency, percent, date, and plain text formats keep reports readable and prevent Sheets from auto-converting IDs into dates. Good formatting is the difference between a sheet leadership trusts and one they argue with.
Read guide →spreadsheet styling
Styling is the visual layer on top of raw data: fonts, fills, borders, banding, and theme colors that guide the eye to headers, inputs, and totals. Unlike number formatting, styling does not change values. It makes shared sheets scannable in meetings and reduces "where do I type?" questions from new editors.
Read guide →revoke sheet access
Revoking access means removing a person or link from the share list so they can no longer open or edit the file. In Google Sheets you use the Share dialog to remove users, downgrade editors to viewers, or turn off anyone-with-the-link sharing. Revoke is essential when contractors finish, clients churn, or a link was posted publicly by mistake.
Read guide →publish Google Sheets
Publishing puts a read-only snapshot or live view of your sheet on the web at a public URL. File > Share > Publish to web lets you choose a tab and format (web page, CSV, TSV, PDF). Published links do not require Google login, which is powerful for embeds and data feeds but risky if you publish the wrong range.
Read guide →clone a spreadsheet
Cloning creates a new Google Sheets file from an existing one so you start from a proven layout without editing the master template. Use File > Make a copy inside the sheet or copy from Google Drive. The clone usually brings tabs, formatting, named ranges, and bound Apps Script, but sharing permissions reset.
Read guide →duplicate rows and tabs
Duplicating inside a workbook means copying a sheet tab or repeating row data for another entry. Right-click a tab and choose Duplicate to clone an entire sheet with formulas adjusted for the new tab name. For rows, copy-paste or drag-fill copies values and formats, which is fast but risky for unique IDs unless you regenerate keys in a helper column.
Read guide →Data validation
Data validation restricts what can be entered in a cell before bad data spreads through your model. Rules can enforce dropdown lists, number ranges, dates, text length, or custom formulas that return TRUE. Invalid entries can be rejected or warned with a note. Validation is the front door quality check for shared trackers and intake sheets.
Read guide →Data bars
Data bars are in-cell horizontal bars driven by conditional formatting. Longer bars mean larger values relative to the range. They give spreadsheet scanners a quick visual ranking without building a separate chart for every column on a KPI table.
Read guide →Alternating colors
Alternating colors apply banded row or column fills to a table so eyes track across wide grids. Format > Alternating colors opens a sidebar with presets and custom header and footer styles. It is faster than hand-painting every other row and updates when you add rows inside the formatted range.
Read guide →Wrap text
Wrap text displays cell content on multiple lines within the same cell instead of spilling into neighbors. Format > Text wrapping > Wrap increases row height automatically so paragraphs, addresses, and long headers remain readable without widening columns across the whole sheet.
Read guide →Merge cells
Merge cells combines a rectangular selection into one display cell. Only the top-left cell value survives; others are discarded. Merged blocks suit dashboard titles and form-like layouts but break many data operations. Use merge sparingly on tables that sort, filter, or feed formulas.
Read guide →Unmerge cells
Unmerge splits a merged block back into individual cells. Only the top-left cell keeps the displayed value; other cells become empty. Unmerge is the first fix when sort fails, filters break, or you need to paste data into what was one big title cell covering your table.
Read guide →Clip mode
Clip mode is a text wrapping option under Format > Text wrapping > Clip. Content that does not fit the column width is cut off at the cell edge instead of spilling into the next empty cells or wrapping to new lines. Clip keeps dense grids visually tidy when full text is not needed at a glance.
Read guide →Cell overflow
Cell overflow is the default behavior where long text visually extends into empty neighboring cells to the right without changing their values. The next non-empty cell clips the spill visually. Overflow keeps row height compact but can make dense tables look messy or hide which cell actually holds the data.
Read guide →Paint format
Paint format is the format painter tool that copies display styling from one cell to others without copying values or formulas. Click the paint roller icon, then click or drag across destination cells. It copies number format, font, fill, borders, alignment, and wrap settings. Essential for making imported CSVs match your template look in minutes.
Read guide →Autofill
Autofill copies a cell or selection downward or sideways using the small blue square fill handle. Sheets detects simple series like 1,2,3 or Mon,Tue,Wed and continues the pattern. Formulas copy with relative references adjusting per row unless you locked absolute refs. Autofill is the fastest way to propagate a working formula across hundreds of rows when ARRAYFORMULA is not needed.
Read guide →sharing Google Sheets
Sharing controls who can open a spreadsheet and what they can do inside it. The Share button invites people by email or link with roles like viewer, commenter, or editor. This is different from publishing a read-only web feed or locking cells with protection rules.
Read guide →make a copy link
A make a copy link is a URL pattern that prompts viewers to duplicate your spreadsheet into their Google Drive instead of editing your original. Template sellers use it so each buyer owns a separate file while the master stays protected.
Read guide →Anyone with the link
Anyone with the link is a sharing option in Google Drive that lets whoever has the URL open the spreadsheet without you adding their email. You still pick a role: viewer, commenter, or editor. It is fast for teams but risky for master templates if you choose editor by mistake.
Read guide →docsdotgoogle
docsdotgoogle is a memorable URL shortcut (docsdotgoogle.com) that redirects into Google Workspace apps like Sheets without typing the full docs.google.com path. Power users mention it on Better Sheets homepage URL tool clusters alongside export and copy link patterns.
Read guide →boolean
Boolean is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →locale
Locale is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →timezone
Timezone is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →cell limit
Cell Limit is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →character limit
Character Limit is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →chrome false
Chrome False is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →column limit
Column Limit is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →comma locale
Comma Locale is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →date format
Date Format is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →date serial
Date Serial is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →decimal format
Decimal Format is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →duration format
Duration Format is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →General locale
General Locale is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →logical value
Logical Value is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →numeric value
Numeric Value is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →row limit
Row Limit is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →semicolon locale
Semicolon Locale is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →serial number
Serial Number is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →spreadsheet locale
Spreadsheet Locale is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →text value
Text Value is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →time format
Time Format is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →time serial
Time Serial is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →time zone
Time Zone is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →stop if true
Stop If True is how Google Sheets stores or interprets values in cells: numbers, text, dates, booleans, and locale-specific separators. Format and locale settings change what you see without always changing the stored value.
Read guide →FORMAT
Format is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →strikethrough
Strikethrough is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →accounting format
Accounting Format is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →automatic format
Automatic Format is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →background color
Background Color is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →Banded columns
Banded Columns is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →Banded rows
Banded Rows is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →border color
Border Color is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →border style
Border Style is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →cell border
Cell Border is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →center across
Center Across is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →Change color
Change Color is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →Clear formatting
Clear Formatting is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →color scale
Color Scale is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →currency format
Currency Format is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →custom format
Custom Format is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →datetime format
Datetime Format is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →FORMAT clause
Format Clause is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →format only
Format Only is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →format pattern
Format Pattern is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →format rule
Format Rule is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →format rules
Format Rules is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →Formatting rules
Formatting Rules is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →gradient rule
Gradient Rule is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →heatmap formatting
Heatmap Formatting is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →horizontal align
Horizontal Align is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →icon set
Icon Set is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →merge all
Merge All is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →merge horizontally
Merge Horizontally is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →merge vertically
Merge Vertically is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →more formats
More Formats is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →number formats
Number Formats is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →overflow text
Overflow Text is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →percent format
Percent Format is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →percent operator
Percent Operator is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →plain text
Plain Text is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →Preview formatting
Preview Formatting is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →row banding
Row Banding is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →scientific notation
Scientific Notation is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →series color
Series Color is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →sheet color
Sheet Color is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →single color
Single Color is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →split merge
Split Merge is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →Tab overflow
Tab Overflow is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →text color
Text Color is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →text rotation
Text Rotation is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →theme colors
Theme Colors is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →vertical align
Vertical Align is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →Color scale max
Color Scale Max is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →Color scale mid
Color Scale Mid is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →Color scale min
Color Scale Min is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →color scale rule
Color Scale Rule is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →Conditional format rules
Conditional Format Rules is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →conditional formatting only
Conditional Formatting Only is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →custom number format
Custom Number Format is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →format cells if
Format Cells If is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →Show as percent
Show As Percent is a display choice in Google Sheets: colors, borders, alignment, number formats, or conditional rules that change how data looks. Formatting helps readers scan a sheet; it does not replace correct formulas.
Read guide →protection
Protection is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →collapse group
Collapse Group is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →column group
Column Group is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →custom sort
Custom Sort is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →expand group
Expand Group is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →filter chip
Filter Chip is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →filter off
Filter Off is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →filtered dropdown
Filtered Dropdown is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →filters field
Filters Field is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →IMPORTRANGE permission
Importrange Permission is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →is sorted
Is Sorted is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →permissions dialog
Permissions Dialog is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →remove filter
Remove Filter is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →row group
Row Group is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →set permissions
Set Permissions is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →sort by
Sort By is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →sort headers
Sort Headers is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →sort icon
Sort Icon is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →sort range
Sort Range is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →sort sheet
Sort Sheet is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →sort warning
Sort Warning is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →temporary filter
Temporary Filter is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →timeline slicer
Timeline Slicer is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →A to Z
A To Z is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →add a slicer
Add A Slicer is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →Add to filters
Add To Filters is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →create a filter
Create A Filter is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →create filter view
Create Filter View is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →delete filter view
Delete Filter View is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →filter by color
Filter By Color is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →filter by condition
Filter By Condition is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →filter by values
Filter By Values is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →filter view name
Filter View Name is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →save filter view
Save Filter View is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →sort by color
Sort By Color is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →View protected ranges
View Protected Ranges is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →Z to A
Z To A is part of filtering, sorting, grouping, or protecting data in Google Sheets. These tools change what people see or who can edit without necessarily changing stored values.
Read guide →commenter
Commenter describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →editor
Editor describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →iframe
Iframe describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →owner
Owner describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →restricted
Restricted describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →viewer
Viewer describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →access expiration
Access Expiration describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →access level
Access Level describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →allow access
Allow Access describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →comment access
Comment Access describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →comment only
Comment Only describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →commenter role
Commenter Role describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →edit access
Edit Access describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →edit only
Edit Only describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →editing mode
Editing Mode describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →editor role
Editor Role describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →general access
General Access describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →iframe embed
Iframe Embed describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →Prevent editors
Prevent Editors describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →published sheet
Published Sheet describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →request access
Request Access describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →restricted access
Restricted Access describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →Share dialog
Share Dialog describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →share link
Share Link describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →suggest edits
Suggest Edits describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →suggestion mode
Suggestion Mode describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →transfer ownership
Transfer Ownership describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →view access
View Access describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →view only
View Only describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →viewer role
Viewer Role describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →viewing mode
Viewing Mode describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →visitor sharing
Visitor Sharing describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →HTML to embed
Html To Embed describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →publish to web
Publish To Web describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →Who has access
Who Has Access describes sharing roles and access in Google Sheets: owner, editor, commenter, viewer, links, and restrictions. Permission choices control who can change formulas versus only view or comment.
Read guide →Sheets UI and exploration
Explore, chips, pivots, slicers, filter views, sidebars, and toasts.
Explore tab
The Explore tab is a sidebar panel that analyzes your selected data and suggests charts, pivot tables, formatting, and quick questions. Google Sheets opens it from the star icon or when you select a table range. It is a fast way to visualize patterns without writing formulas first.
Read guide →Checkbox
A checkbox is a cell control that stores TRUE when checked and FALSE when unchecked. Insert checkboxes from Insert > Checkbox or data validation. They power task lists, approval flags, and conditional formulas without typing yes or no by hand.
Read guide →Chip
Chips are visual tokens in a cell that represent a chosen value from a list or a person from your organization. Dropdown chips show colored pills for categories and statuses. People chips link to Google contacts for assignees and reviewers. They keep typed data consistent while looking clearer than plain text.
Read guide →Slicer
A slicer is an on-sheet control that filters connected pivot tables and charts. Click category buttons instead of digging through filter menus. Slicers make dashboards feel interactive for executives and account managers who will not touch formula tabs.
Read guide →Pivot table
A pivot table summarizes a large table without writing SUMIFS for every combination. Drag fields into rows, columns, values, and filters to count deals by rep, sum revenue by month, or average scores by classroom. The pivot updates when you refresh the source range or change the pivot cache.
Read guide →Freeze rows and columns
Freezing locks the top rows or left columns in place while the rest of the sheet scrolls. View > Freeze lets you pin one row, two rows, or up to the current selection. Frozen panes keep headers and row labels visible on long trackers and financial models.
Read guide →Named range
A named range gives a block of cells a readable label like Revenue or ValidStatuses instead of only B2:B500. Define names from Data > Named ranges. Formulas, charts, pivot tables, and validation rules can reference the name, which makes models easier to audit and safer when rows shift inside the named block.
Read guide →Filter view
A filter view is a saved set of column filters with its own name and optional owner color. Each collaborator can open a different view on the same tab without changing what others see. Share a filter view link so a manager opens only their region or only open tickets instantly.
Read guide →Sidebar
A sidebar is a vertical panel docked beside the spreadsheet grid. The Explore tab is a built-in sidebar. With Apps Script you can show a custom sidebar from HTML to build wizards, search tools, and forms without leaving the sheet. Add-ons from the Marketplace often register sidebar entries under Extensions.
Read guide →Toast notification
A toast is a small temporary message that slides up at the bottom of the Google Sheets window and fades away without blocking work. Sheets shows toasts for actions like filter applied, link copied, or script finished. In Apps Script you can call SpreadsheetApp.getActiveSpreadsheet().toast() for gentle user feedback instead of a modal alert.
Read guide →Smart fill
Smart Fill watches columns next to your edit and suggests completing a pattern when it recognizes one. Type a couple examples in a new column beside source data and Sheets may offer to fill the rest with names, emails split from full text, or formatted dates. It is Google's answer to flash fill for quick cleanup without formulas.
Read guide →Timeline chart
A timeline chart shows events or tasks along a date axis so viewers see sequence and overlap. In Google Sheets you often build timelines with bar charts on start and end dates, scatter charts for milestones, or dedicated timeline chart types when the chart editor offers them. Clean date columns and consistent time zones make timelines trustworthy.
Read guide →Recalculation
Recalculation is when Google Sheets recomputes formula results after something changes. Most functions update when their input cells change. Volatile functions like NOW, RAND, and OFFSET recalculate more often. Large workbooks may feel slow when thousands of formulas refresh at once.
Read guide →Iterative calculation
Iterative calculation lets formulas that reference their own cells converge through repeated passes instead of stopping at an error. You set a maximum number of iterations and a convergence threshold in File > Settings > Calculation. It is an advanced escape hatch for intentional feedback loops, not a fix for accidental typos.
Read guide →Circular reference
A circular reference happens when a formula chain loops back to the cell you are editing, directly or through other cells. Google Sheets normally blocks this with a warning and may show zero or an error until you break the loop or enable iterative calculation. Most circles in real files are mistakes, not intentional models.
Read guide →Version history
Version history is a timeline of saved snapshots for your spreadsheet. File > Version history > See version history shows edits grouped by time and editor. You can preview an older state, restore it, or name a version before a big import. It is your undo rope when someone pastes over production data.
Read guide →Named function
A named function is a custom formula you define once and call by a friendly name in any cell. Google Sheets uses LAMBDA under the hood via Data > Named functions. Instead of repeating a long expression, you write =DISCOUNT(price, rate) everywhere. Named functions make templates readable and reduce copy-paste errors across tabs.
Read guide →dependents
Dependents controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →tickbox
Tickbox controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →cascading dropdown
Cascading Dropdown controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →checkbox FALSE
Checkbox False controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →checkbox toggle
Checkbox Toggle controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →checkbox TRUE
Checkbox True controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →checkbox validation
Checkbox Validation controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →dependent cells
Dependent Cells controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →dependent dropdown
Dependent Dropdown controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →dependent workbook
Dependent Workbook controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →dropdown arrow
Dropdown Arrow controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →dynamic dropdown
Dynamic Dropdown controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →event chip
Event Chip controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →Extract chips
Extract Chips controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →file chip
File Chip controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →Finance chips
Finance Chips controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →insert chip
Insert Chip controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →people chip
People Chip controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →place chip
Place Chip controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →rating chips
Rating Chips controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →reject input
Reject Input controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →show warning
Show Warning controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →smart chip
Smart Chip controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →tick box
Tick Box controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →validation criteria
Validation Criteria controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →validation icon
Validation Icon controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →voting chips
Voting Chips controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →YouTube chip
Youtube Chip controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →custom formula validation
Custom Formula Validation controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →data validation only
Data Validation Only controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →dropdown from range
Dropdown From Range controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →list from range
List From Range controls what people can type in a cell: dropdowns, checkboxes, chips, warnings, or reject rules. Validation reduces bad data before it breaks formulas downstream.
Read guide →unfreeze
Unfreeze changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →unhide
Unhide changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →Add sheet
Add Sheet changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →auto resize
Auto Resize changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →clear all
Clear All changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →clear content
Clear Content changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →column header
Column Header changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →column width
Column Width changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →combine columns
Combine Columns changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →concatenate cells
Concatenate Cells changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →Copy cells
Copy Cells changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →copy sheet
Copy Sheet changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →Copy to
Copy To changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →delete cells
Delete Cells changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →delete column
Delete Column changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →delete row
Delete Row changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →delete sheet
Delete Sheet changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →floating image
Floating Image changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →footer row
Footer Row changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →freeze handle
Freeze Handle changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →freeze line
Freeze Line changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →header row
Header Row changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →header rows
Header Rows changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →hidden column
Hidden Column changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →hidden columns
Hidden Columns changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →hidden row
Hidden Row changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →hidden rows
Hidden Rows changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →hidden sheet
Hidden Sheet changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →hide column
Hide Column changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →hide columns
Hide Columns changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →hide gridlines
Hide Gridlines changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →hide row
Hide Row changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →hide rows
Hide Rows changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →hide sheet
Hide Sheet changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →insert cells
Insert Cells changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →insert column
Insert Column changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →insert columns
Insert Columns changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →insert image
Insert Image changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →insert row
Insert Row changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →insert rows
Insert Rows changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →move cells
Move Cells changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →move sheet
Move Sheet changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →rename sheet
Rename Sheet changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →reorder sheets
Reorder Sheets changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →Reorder tab
Reorder Tab changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →resize column
Resize Column changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →resize handle
Resize Handle changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →resize row
Resize Row changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →Resize table
Resize Table changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →row header
Row Header changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →row height
Row Height changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →selection stats
Selection Stats changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →Sheet menu
Sheet Menu changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →sheet tab
Sheet Tab changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →sheet tabs
Sheet Tabs changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →shift cells
Shift Cells changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →tab color
Tab Color changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →unfreeze columns
Unfreeze Columns changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →unfreeze rows
Unfreeze Rows changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →unhide column
Unhide Column changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →unhide row
Unhide Row changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →unhide sheet
Unhide Sheet changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →column widths only
Column Widths Only changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →fit to data
Fit To Data changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →freeze 1 column
Freeze 1 Column changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →freeze 1 row
Freeze 1 Row changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →freeze 2 rows
Freeze 2 Rows changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →Sheet tabs bar
Sheet Tabs Bar changes sheet structure or layout: frozen panes, hidden rows, column width, inserts, deletes, or tab order. Layout choices affect readability and what collaborators can accidentally break.
Read guide →cut paste
Cut Paste is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →double-click fill
Double-click Fill is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →drag cells
Drag Cells is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →drag fill
Drag Fill is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →fill color
Fill Color is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →fill down
Fill Down is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →Fill formatting
Fill Formatting is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →fill handle
Fill Handle is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →fill options
Fill Options is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →fill right
Fill Right is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →fill series
Fill Series is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →name box
Name Box is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →paste format
Paste Format is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →paste formulas
Paste Formulas is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →paste name
Paste Name is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →paste special
Paste Special is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →paste transposed
Paste Transposed is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →paste values
Paste Values is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →relative fill
Relative Fill is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →replace all
Replace All is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →series fill
Series Fill is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →transposed paste
Transposed Paste is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →drag to copy
Drag To Copy is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →drag to fill
Drag To Fill is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →find and replace
Find And Replace is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →Go to range
Go To Range is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →paste without formatting
Paste Without Formatting is part of copy, paste, fill, or find/replace workflows in Google Sheets. Paste special and the fill handle are the fastest ways to move formulas, values, or formats without retyping.
Read guide →@mention
@mention covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →comment
Comment covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →comments
Comments covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →follow-ups
Follow-ups covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →mentions
Mentions covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →note
Note covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →notes
Notes covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →action items
Action Items covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →assign comment
Assign Comment covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →browser notifications
Browser Notifications covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →cell history
Cell History covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →cell note
Cell Note covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →comment history
Comment History covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →comment indicator
Comment Indicator covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →comment thread
Comment Thread covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →conditional notifications
Conditional Notifications covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →daily digest
Daily Digest covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →edit history
Edit History covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →email alerts
Email Alerts covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →email notifications
Email Notifications covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →emoji reactions
Emoji Reactions covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →insert comment
Insert Comment covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →insert note
Insert Note covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →linked comment
Linked Comment covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →note indicator
Note Indicator covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →notes only
Notes Only covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →notification rules
Notification Rules covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →notification settings
Notification Settings covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →notify people
Notify People covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →resolve comment
Resolve Comment covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →trigger history
Trigger History covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →name current version
Name Current Version covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →restore this version
Restore This Version covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →see edit history
See Edit History covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →see version history
See Version History covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →Show edit history
Show Edit History covers comments, notes, mentions, notifications, and version history in Google Sheets. These tools document decisions without changing cell values.
Read guide →gridlines
Gridlines is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →redo
Redo is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →toolbar
Toolbar is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →undo
Undo is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →zoom
Zoom is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Board view
Board View is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Compact controls
Compact Controls is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →context menu
Context Menu is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Continue pattern
Continue Pattern is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Customize tab
Customize Tab is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Data menu
Data Menu is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Details panel
Details Panel is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →document status
Document Status is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Edit menu
Edit Menu is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Extensions menu
Extensions Menu is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →File menu
File Menu is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Format menu
Format Menu is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →formula bar
The formula bar is the wide input above the grid where you edit the active cell's formula or value. Expanding it helps with long nested formulas without squinting at in-cell overflow.
Read guide →functions language
Functions Language is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Insert menu
Insert Menu is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Map view
Map View is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →menu bar
Menu Bar is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →offline access
Offline Access is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →right-click menu
Right-click Menu is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →show gridlines
Show Gridlines is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →side panel
Side Panel is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →status bar
Status Bar is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Tools menu
Tools Menu is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →View gridlines
View Gridlines is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →View menu
View Menu is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →formula bar expand
The formula bar is the wide input above the grid where you edit the active cell's formula or value. Expanding it helps with long nested formulas without squinting at in-cell overflow.
Read guide →Side panel AI
Side Panel Ai is part of the Google Sheets interface: menus, toolbars, side panels, and view options around the grid. Knowing where a feature lives saves time more than memorizing every shortcut.
Read guide →Ctrl Enter
Ctrl Enter is a keyboard workflow in Google Sheets for faster editing, reference toggling, or confirming entries. Shortcuts reduce mouse travel on large models.
Read guide →F2 edit
F2 Edit is a keyboard workflow in Google Sheets for faster editing, reference toggling, or confirming entries. Shortcuts reduce mouse travel on large models.
Read guide →F4 toggle
F4 Toggle is a keyboard workflow in Google Sheets for faster editing, reference toggling, or confirming entries. Shortcuts reduce mouse travel on large models.
Read guide →keyboard shortcut
Keyboard Shortcut is a keyboard workflow in Google Sheets for faster editing, reference toggling, or confirming entries. Shortcuts reduce mouse travel on large models.
Read guide →shortcut keys
Shortcut Keys is a keyboard workflow in Google Sheets for faster editing, reference toggling, or confirming entries. Shortcuts reduce mouse travel on large models.
Read guide →Dashboards, trackers, and planners
Boards, KPIs, budgets, inventory, and planning layouts.
dashboards
A dashboard is a single view that answers "how are we doing?" without hunting across tabs. In Google Sheets, it is usually a summary tab with big numbers, charts, and conditional formatting fed by QUERY, pivot tables, or IMPORTRANGE from raw data you keep elsewhere.
Read guide →trackers
A tracker is a living list you update over time: tasks, leads, inventory, habits, or bugs. Good trackers use one row per item, clear statuses, and columns that sort and filter without cleanup scripts. They often feed a dashboard tab when the team outgrows scanning raw rows.
Read guide →planners
A planner layout helps you schedule work across days, weeks, or project phases inside a spreadsheet. Unlike a one-off todo list, planners emphasize dates, time blocks, and recurring rhythms you copy forward. They work well for personal systems and small teams who already live in Google Workspace.
Read guide →Kanban in Sheets
Kanban boards show work moving through stages like To do, Doing, and Done. In Google Sheets, you simulate the board with status columns, filter views per stage, or horizontal column layouts where each stage is a range. It is ideal for small teams already collaborating in a spreadsheet.
Read guide →inventory tracking in Sheets
An inventory sheet lists each SKU with quantity on hand, location, reorder threshold, and unit cost. Receipts and shipments post as signed adjustments on a Movements log so on-hand balance is calculated, not typed from memory.
Read guide →reports from Google Sheets
A report turns raw data into a readable snapshot: summary metrics, charts, and tables formatted for an audience. Separate source data tabs from a Report tab that uses QUERY, pivot tables, or SUMIF so you refresh inputs without rebuilding layout every week.
Read guide →budgets in Google Sheets
A budget sheet compares planned spending or revenue to actuals over time. Rows are categories, columns are months or quarters, and formulas SUM detail lines into subtotals. Variance columns show where you are over or under plan.
Read guide →win rate tracking
Win rate tracking measures how many opportunities close as wins versus losses or open deals. In Google Sheets you store one row per deal with Stage, Outcome, and Close date columns, then use COUNTIFS or pivot tables to calculate win percentage by rep, product, or quarter. A clear tracker turns pipeline rows into leadership-ready close rate metrics without exporting to a CRM report.
Read guide →checklists in Google Sheets
Checklists in Google Sheets use checkbox cells, done columns, or status dropdowns to track tasks row by row. Insert checkboxes from the Insert menu, pair them with COUNTIF percent complete formulas, and use conditional formatting to highlight overdue items still unchecked.
Read guide →charts in Google Sheets
Charts in Google Sheets turn selected ranges into line, bar, pie, and combo visuals that update when source data changes. You insert from the Insert menu or chart editor, tie ranges to pivot tables or QUERY outputs, then publish or embed charts in Slides, Sites, and dashboards.
Read guide →CRM in Google Sheets
Yes, for small teams a spreadsheet CRM tracks leads, deal stage, owner, next action, and notes in one shared file. Tabs separate Pipeline, Contacts, and Activity log. It works when volume is modest and everyone agrees the sheet is the system of record.
Read guide →pivoting
Pivoting is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →subtotals
Subtotals is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →calculated field
Calculated Field is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →columns field
Columns Field is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →date group
Date Group is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →drill down
Drill Down is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →grand total
Grand Total is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →pivot column
Pivot Column is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →pivot editor
Pivot Editor is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →pivot field
Pivot Field is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →pivot filter
Pivot Filter is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →pivot group
Pivot Group is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →pivot row
Pivot Row is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →pivot suggestion
Pivot Suggestion is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →pivot value
Pivot Value is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →Refresh pivot
Refresh Pivot is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →rows field
Rows Field is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →running total
Running Total is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →show totals
Show Totals is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →suggested pivot
Suggested Pivot is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →ungroup pivot
Ungroup Pivot is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →values field
Values Field is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →add pivot table
Add Pivot Table is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →create pivot group
Create Pivot Group is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →Insert pivot table
Insert Pivot Table is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →percent of column
Percent Of Column is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →percent of row
Percent Of Row is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →Pivot date group
Pivot Date Group is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →pivot table editor
Pivot Table Editor is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →show values as
Show Values As is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →Suggested pivot table
Suggested Pivot Table is pivot table vocabulary in Google Sheets: fields, groups, totals, and editor controls that summarize raw tables. Pivots trade formula complexity for drag-and-drop aggregation.
Read guide →Analysis
Analysis is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →Answers
Answers is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →drawing
Drawing is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →pubchart
Pubchart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →scorecard
Scorecard is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →trendline
Trendline is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →100% stacked
100% Stacked is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →Analysis panel
Analysis Panel is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →area chart
Area Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →axis title
Axis Title is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →bar chart
Bar Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →bubble chart
Bubble Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →candlestick chart
Candlestick Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →chart axis
Chart Axis is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →chart editor
Chart Editor is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →chart legend
Chart Legend is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →chart recommendations
Chart Recommendations is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →chart style
Chart Style is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →chart subtitle
Chart Subtitle is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →chart title
Chart Title is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →chart type
Chart Type is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →column chart
Column Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →combo chart
Combo Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →donut chart
Donut Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →embed chart
Embed Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →gauge chart
Gauge Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →geo chart
Geo Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →histogram chart
Histogram Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →horizontal axis
Horizontal Axis is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →in-cell chart
In-cell Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →insert chart
Insert Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →insert drawing
Insert Drawing is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →line chart
Line Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →log scale
Log Scale is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →mini chart
Mini Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →move chart
Move Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →org chart
Org Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →pie chart
Pie Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →publish chart
Publish Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →radar chart
Radar Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →scatter chart
Scatter Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →scorecard chart
Scorecard Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →secondary axis
Secondary Axis is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →series set
Series Set is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →sparkline bar
Sparkline Bar is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →sparkline line
Sparkline Line is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →sparkline winloss
Sparkline Winloss is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →stacked bar
Stacked Bar is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →stacked column
Stacked Column is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →table chart
Table Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →treemap chart
Treemap Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →vertical axis
Vertical Axis is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →waterfall chart
Waterfall Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →chart data range
Chart Data Range is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →image in cell
Image In Cell is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →stepped area chart
Stepped Area Chart is chart or visual vocabulary in Google Sheets: chart types, axes, legends, sparklines, and publish options. Good charts make trends obvious without hiding the source range.
Read guide →calculated column
Calculated Column refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →column menu
Column Menu refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →column type
Column Type refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →table column
Table Column refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →table footer
Table Footer refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →table formatting
Table Formatting refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →table header
Table Header refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →table menu
Table Menu refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →Table style
Table Style refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →table view
Table View refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →Total row
Total Row refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →group by view
Group By View refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →card detail
Card Detail is part of the Timeline view in Google Sheets, where tasks or events appear as cards on a date axis. Timeline vocabulary covers card fields, intervals, and how collapsed groups display.
Read guide →card group
Card Group is part of the Timeline view in Google Sheets, where tasks or events appear as cards on a date axis. Timeline vocabulary covers card fields, intervals, and how collapsed groups display.
Read guide →card title
Card Title is part of the Timeline view in Google Sheets, where tasks or events appear as cards on a date axis. Timeline vocabulary covers card fields, intervals, and how collapsed groups display.
Read guide →collapsed view
Collapsed View is part of the Timeline view in Google Sheets, where tasks or events appear as cards on a date axis. Timeline vocabulary covers card fields, intervals, and how collapsed groups display.
Read guide →end date
End Date is part of the Timeline view in Google Sheets, where tasks or events appear as cards on a date axis. Timeline vocabulary covers card fields, intervals, and how collapsed groups display.
Read guide →start date
Start Date is part of the Timeline view in Google Sheets, where tasks or events appear as cards on a date axis. Timeline vocabulary covers card fields, intervals, and how collapsed groups display.
Read guide →view interval
View Interval is part of the Timeline view in Google Sheets, where tasks or events appear as cards on a date axis. Timeline vocabulary covers card fields, intervals, and how collapsed groups display.
Read guide →view mode
View Mode is part of the Timeline view in Google Sheets, where tasks or events appear as cards on a date axis. Timeline vocabulary covers card fields, intervals, and how collapsed groups display.
Read guide →Measure, embed, and prompt AI
KPIs, embeds, naming, and AI formula prompts.
KPI tracking
KPI tracking means choosing a small set of numbers that show whether you are winning, then updating them on a rhythm everyone trusts. In Sheets, each KPI usually has a definition, data source, target, and actual cell on a dashboard fed by formulas, not hand-typed guesses.
Read guide →embed sheets
Embedding shows a spreadsheet, chart, or range inside a website, Notion page, or Google Site without sending visitors to the full Sheets UI. You usually publish to web or use an iframe with a link Google generates, combined with sharing permissions that match your audience.
Read guide →naming conventions
Naming conventions are agreed rules for files, tabs, columns, and named ranges so anyone can guess where data lives. Good names reduce VLOOKUP errors, make IMPORTRANGE links obvious, and stop duplicate Dashboard (2) tabs from spreading across your Drive.
Read guide →AI prompts for formulas
A good prompt describes your column layout, sample values, expected result, and Google Sheets functions you prefer. Vague asks like "make a formula" produce fragile ARRAYFORMULA guesses. Treat AI output as a draft you test in a copy tab before pasting into production.
Read guide →Gemini
Gemini is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →analysis steps
Analysis Steps is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →Ask Gemini
Ask Gemini is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →cleanup suggestions
Cleanup Suggestions is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →Column Stats
Column Stats is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →formatting suggestions
Formatting Suggestions is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →frequency tables
Frequency Tables is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →Help menu
Help Menu is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →insight cards
Insight Cards is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →live suggestions
Live Suggestions is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →Smart Cleanup
Smart Cleanup is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →summary statistics
Summary Statistics is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →Enhanced Smart Fill
Enhanced Smart Fill is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →Gemini in Sheets
Gemini In Sheets is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →Help me organize
Help Me Organize is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →Help me visualize
Help Me Visualize is part of Gemini and smart assistance in Google Sheets: cleanup suggestions, summaries, and in-product help. AI features speed exploration but still need human review on formulas and numbers.
Read guide →Files, import, and export
CSV, Excel, PDF, and moving data in and out of Sheets.
CSV and Google Sheets
CSV (comma-separated values) is a plain-text table format Sheets opens, imports, and exports easily. Use File > Import for controlled uploads or File > Download > CSV for handoffs to other tools. Watch encoding, delimiters, and date formats because CSV does not store types the way a native sheet does.
Read guide →PDF export from Google Sheets
Google Sheets turns any tab or workbook into PDF through File > Download > PDF or the Print dialog. Control layout with print ranges, margins, scale, and repeat headers so multi-page reports stay readable. PDF is best for snapshots you email, archive, or attach when recipients should not edit cells.
Read guide →Excel XLSX and Google Sheets
XLSX is the modern Excel workbook format. Google Sheets opens it through File > Import or by uploading to Drive and choosing Open with Google Sheets. Most values, tabs, and basic formatting convert cleanly, but some Excel-only features need a workaround or a stay-in-Excel decision.
Read guide →importing data into Sheets
Importing means pulling external data into a spreadsheet tab: from a file upload, another Google Sheet, a published CSV URL, or a function like IMPORTRANGE. The import dialog controls separator, locale, and whether new rows replace or append existing data.
Read guide →exporting data from Sheets
Exporting sends sheet data out of Google Sheets as a file or published feed. File > Download offers CSV, XLSX, PDF, and more for the active tab or workbook. You can also publish a range, share a view-only link, or script exports to Drive and email on a schedule.
Read guide →encoding
Encoding covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →margins
Margins covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →ODS
Ods covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →TSV
Tsv covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →connect sheets
Connect Sheets covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →CSV export
Csv Export covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →Disable download
Disable Download covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →download as
Download As covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →download CSV
Download Csv covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →download Excel
Download Excel covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →download PDF
Download Pdf covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →external data
External Data covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →File import
File Import covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →HTML export
Html Export covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →import CSV
Import Csv covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →import Excel
Import Excel covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →import location
Import Location covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →import settings
Import Settings covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →link breaking
Link Breaking covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →link sheets
Link Sheets covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →page breaks
Page Breaks covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →page numbers
Page Numbers covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →page orientation
Page Orientation covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →paper size
Paper Size covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →PDF export
Pdf Export covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →print area
Print Area covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →print gridlines
Print Gridlines covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →print preview
Print Preview covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →refresh all
Refresh All covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →refresh data
Refresh Data covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →repeat rows
Repeat Rows covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →text qualifier
Text Qualifier covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →TSV export
Tsv Export covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →upload file
Upload File covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →workbook print
Workbook Print covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →XLSX export
Xlsx Export covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →clear print area
Clear Print Area covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →fit to height
Fit To Height covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →fit to page
Fit To Page covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →fit to width
Fit To Width covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →set print area
Set Print Area covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →Coming from Excel
Moving from Excel? Start with VBA, Power Query, or Goal Seek. Each page names the Excel feature first, then shows the Sheets path.
VBA
Google Sheets automation runs through Google Apps Script (JavaScript) and recorded macros, not VBA. In Excel, VBA is the desktop language behind macros, UserForms, and many add-ins. Rebuild Excel VBA in Apps Script: triggers, custom menus, and batch range updates replace most workbook automation.
Read guide →Visual Basic
Visual Basic is the language family behind Excel VBA. Google Sheets does not run VB or VBA; the closest equivalent is Google Apps Script, which uses modern JavaScript syntax. Recorded macros in Sheets generate Apps Script you can extend, similar to how Excel's macro recorder outputs VBA.
Read guide →macro recorder
In Google Sheets, open Extensions > Macros > Record macro to capture clicks and edits as Apps Script. Excel's macro recorder writes VBA instead. Both are best for simple, repeatable UI steps you can replay or tweak in the script editor.
Read guide →ActiveX
ActiveX controls are Windows-only Excel form controls. Google Sheets uses checkboxes, chips, drawings, and Apps Script sidebars or dialogs instead. There is no ActiveX runtime in the browser, so migrate buttons and combo boxes to native inputs plus script handlers.
Read guide →UserForm
Excel UserForms are custom VBA dialog windows. In Google Sheets, build the same flows with HtmlService modals, sidebars, or Google Forms linked to a response sheet. Apps Script can read selections and write results back to ranges.
Read guide →COM add-in
COM add-ins are desktop Excel extensions that load through Windows. Google Sheets uses Workspace Marketplace add-ons and Apps Script libraries instead, all running in the cloud. Search the Marketplace or publish an internal add-on for team-wide installs.
Read guide →XLAM
An XLAM file is an Excel add-in workbook that stores macros and custom functions. Google Sheets has no XLAM format; distribute logic as an Apps Script project, library, or published add-on. Import the XLSX data separately, then rebuild automation in Apps Script.
Read guide →ThisWorkbook
In Excel VBA, ThisWorkbook refers to the file that hosts the code. In Apps Script bound to a spreadsheet, call SpreadsheetApp.getActiveSpreadsheet() for the same idea. Standalone scripts use openById or openByUrl with the spreadsheet ID from the URL.
Read guide →Worksheet_Change
Excel fires Worksheet_Change after cells change on a sheet. Google Sheets uses simple onEdit triggers for lightweight reactions or installable onEdit triggers when you need fewer restrictions. Both patterns run Apps Script instead of VBA.
Read guide →Worksheet_Open
Excel can run VBA when a workbook opens. Google Sheets provides an onOpen simple trigger, or an installable onOpen trigger for menus and refresh jobs. There is no exact per-worksheet open event; scope logic to the active sheet inside onOpen if needed.
Read guide →Application.ScreenUpdating
Excel VBA toggles ScreenUpdating to speed bulk updates. Google Sheets has no equivalent switch; batch writes with getRange().setValues() and SpreadsheetApp.flush() reduce round trips instead. Fewer separate setValue calls usually beat trying to hide UI updates.
Read guide →Option Explicit
Option Explicit forces variable declarations in VBA. Apps Script uses JavaScript const and let, and linters or TypeScript-style discipline replace the VBA guardrail. Name variables clearly and avoid implicit globals in triggers and menu handlers.
Read guide →Dim
Dim declares variables in VBA. In Apps Script, declare values with const for constants and let for values that change. Google Sheets macros and triggers are JavaScript, not Visual Basic, so syntax differs even when the spreadsheet ideas match.
Read guide →Range object
Excel's Range object represents cells you read or write in VBA. Apps Script uses Range too, returned by spreadsheet.getRange(), getActiveRange(), or getRangeByName(). Methods like getValue, setValues, and getValues map closely to common VBA Range calls.
Read guide →Cells object
Excel VBA often uses Cells(row, column) for numeric addressing. In Apps Script, call getRange(row, column) or getRange('A1') on a sheet instead. Named ranges and A1 notation stay the most readable options for collaborators.
Read guide →Workbooks.Open
Excel VBA opens files with Workbooks.Open. In Apps Script, open another Google spreadsheet with SpreadsheetApp.openById() or openByUrl(), using the ID from the share link. For Excel files on Drive, convert or import first; XLSX opens as a Sheets file after upload.
Read guide →Power Query
Power Query is Excel's click-and-refresh ETL engine. Google Sheets combines IMPORT functions, QUERY, Apps Script, Connected Sheets, and add-ons for the same jobs: pull web or file data, reshape tables, and refresh on a schedule. There is no Power Query UI inside Sheets.
Read guide →Get & Transform
Get & Transform is Microsoft's ribbon name for Power Query in Excel. In Google Sheets, think File > Import, IMPORTHTML, IMPORTXML, IMPORTDATA, IMPORTRANGE, and QUERY for shaping data. Connected Sheets covers large warehouse extracts Excel users handled with Power Query plus data model.
Read guide →Power Pivot
Power Pivot adds an in-workbook data model and DAX in Excel. Google Sheets has no identical model; use Connected Sheets with BigQuery, pivot tables on large IMPORT ranges, or QUERY for relationships. Heavy models usually belong in the warehouse, not the grid.
Read guide →Data Model
Excel's Data Model stores related tables for Power Pivot and pivot relationships. Google Sheets does not ship a full in-grid data model. Connected Sheets, BigQuery, or careful QUERY joins approximate the pattern for reporting.
Read guide →M language
M is the formula language behind Power Query steps in Excel. Google Sheets has no M runtime; express the same transforms with QUERY, array formulas, or Apps Script. Record intermediate columns when a Power Query script was long.
Read guide →DAX
DAX is Excel's Power Pivot formula language for measures and relationships. Google Sheets uses regular spreadsheet formulas, QUERY, and pivot calculated fields instead. Complex measures often move to BigQuery SQL with Connected Sheets.
Read guide →Query Editor
Excel's Query Editor is the Power Query step UI. Google Sheets has no matching visual step list; you write IMPORT and QUERY formulas or Apps Script, and use Connected Sheets for scheduled warehouse pulls. Helper columns document each transform.
Read guide →Unpivot
Unpivot turns wide columns into attribute-value rows, common in Power Query. In Google Sheets, use formulas such as SPLIT, QUERY, FLATTEN, or ARRAYFORMULA patterns, or an add-on for large tables. Apps Script works when the layout is fixed.
Read guide →Append queries
Power Query append stacks tables with the same columns. In Google Sheets, combine ranges with curly-brace array syntax like {Sheet1!A2:C;Sheet2!A2:C} or use QUERY UNION patterns. Apps Script appendRow suits small feeds.
Read guide →Merge queries
Power Query merge is a join between tables. Google Sheets offers XLOOKUP, VLOOKUP, INDEX MATCH, and QUERY with joins on keys. Choose the tool that matches your key columns and whether you need many columns back.
Read guide →From Web
Excel Power Query From Web pulls HTML tables and pages. Google Sheets uses IMPORTHTML, IMPORTXML, and IMPORTDATA depending on the page structure. Apps Script with UrlFetchApp handles APIs Excel accessed through web connectors.
Read guide →From Text
Excel From Text / Get Data from Text walks CSV and fixed-width imports. Google Sheets uses File > Import, drag-and-drop upload, or IMPORTDATA for published CSV URLs. Set separator and locale during import to match Excel's wizard.
Read guide →Connection only
In Power Query, connection only loads a query without landing a table. Google Sheets always materializes data in cells or Connected Sheets extracts. Keep source formulas on a hidden tab or use Named ranges to mimic staging without duplicate tables.
Read guide →Goal Seek
Goal Seek is Excel's what-if tool that adjusts one input until a formula hits a target. Google Sheets has no built-in Goal Seek. Use algebra in formulas, a small Apps Script solver, or a third-party add-on for the same search.
Read guide →Solver
Excel Solver optimizes formulas subject to constraints. Google Sheets has no native Solver add-in; use optimization add-ons, Apps Script, or export the model to a tool that supports linear programming. Simple cases may solve with algebra or manual scenarios.
Read guide →Scenario Manager
Excel Scenario Manager saves input sets and swaps them for comparison. Google Sheets uses separate scenario tabs, a dropdown plus CHOOSE or INDEX, or Apps Script to swap assumption blocks. Version history helps compare edits over time.
Read guide →Data Table
Excel Data Tables run one- or two-variable what-if grids automatically. Google Sheets has no Data Table command; build the grid with formulas that reference input cells, or generate the matrix with ARRAYFORMULA and SEQUENCE. Apps Script can loop inputs for large tables.
Read guide →Analysis ToolPak
The Analysis ToolPak adds statistical and engineering functions in Excel. Google Sheets includes many stats functions natively; gaps use add-ons or Connected Sheets to BigQuery. Check function names before assuming ToolPak is required.
Read guide →Watch Window
Excel's Watch Window pins formula results while you edit elsewhere. Google Sheets has no watch window; keep helper cells on a fixed audit tab, split the window, or log values with Apps Script during tests.
Read guide →Trace Precedents
Excel draws arrows to cells a formula references. Google Sheets does not draw precedent arrows; click the cell and read the formula bar, or use Explore for related edits. Manual auditing and helper labels replace the arrows.
Read guide →Trace Dependents
Excel Trace Dependents shows which formulas use the active cell. Google Sheets has no dependent arrows; search the sheet with Find for the address, or use a script to list dependents before deleting rows. Version history shows what broke after edits.
Read guide →Name Manager
Excel Name Manager lists defined names for cells, tables, and formulas. Google Sheets uses Data > Named ranges and named functions for reusable logic. Open the named ranges side panel to edit, delete, or jump to a name.
Read guide →Camera tool
Excel Camera pastes a live picture linked to a range. Google Sheets has no Camera command; use charts, IMPORTRANGE mirrors, embedded ranges in Slides, or publish a slice. Dashboard tabs with direct cell references often replace camera snapshots.
Read guide →XLS
XLS is the legacy Excel binary workbook format. Upload to Google Drive and open with Google Sheets, or convert to XLSX first for fewer import surprises. Very old macros and features do not transfer; rebuild automation in Apps Script.
Read guide →XLSM
XLSM is Excel's macro-enabled workbook. Google Sheets can import the data but does not run Excel VBA macros inside the file. Rebuild macros as Apps Script after import, and expect to fix formulas and names that differ between products.
Read guide →XLSB
XLSB is Excel's binary workbook format, often smaller on disk. Convert to XLSX in Excel or upload through Drive and let Sheets import the contents. Binary-only features and macros do not carry over verbatim.
Read guide →Calculate Now
Excel Calculate Now forces immediate recalculation in manual calculation mode. Google Sheets recalculates in the cloud as edits land; use File > Settings > Calculation to review recalc options. Heavy IMPORT sheets may still pause until external data returns.
Read guide →Precision as displayed
Excel can round stored values to match what you see on screen. Google Sheets keeps full precision in the cell unless you round with functions like ROUND or use formats only for display. Use explicit rounding in formulas for financial handoffs.
Read guide →1904 date system
Some Excel Mac workbooks used the 1904 date system, shifting serial dates by four years versus the 1900 system. Google Sheets follows standard serial dates with locale settings; watch for off-by-four-year bugs when importing old Excel files.
Read guide →Personal Macro Workbook
Excel stores global macros in Personal.xlsb. Google Sheets has no personal macro file; use a standalone Apps Script project, a shared script library, or an add-on distributed to the team. Bind scripts only when the macro should live in one file.
Read guide →Excel add-in
Excel add-ins extend desktop Excel, often as XLAM or COM packages. Google Sheets uses Workspace Marketplace add-ons and Apps Script instead, installed per user or domain. Cloud add-ons cannot access your local disk like some Excel add-ins.
Read guide →Ribbon
Excel's ribbon is the tabbed toolbar across the top of the desktop app. Google Sheets uses a menu bar and compact toolbar in the browser, with most actions under File, Edit, Data, and Format. Search the menus or Help when a ribbon label moved.
Read guide →Backstage
Excel Backstage is the File hub for info, export, and options. Google Sheets puts those actions in the File menu: Share, Download, Version history, and Settings. Account and storage live in Google Drive, not inside the sheet UI.
Read guide →Quick Access Toolbar
Excel's Quick Access Toolbar pins commands above the ribbon. Google Sheets has no identical QAT; pin habits to keyboard shortcuts, the toolbar, or custom Apps Script menus. Browser bookmarks cover files, not commands.
Read guide →Status bar aggregate
Excel's status bar shows sum, average, and count for the current selection. Google Sheets shows a smaller summary at the bottom edge when you select numeric cells; Explore may add quick stats. For a fixed label, use SUBTOTAL or SUM on a helper cell.
Read guide →Structured references
Excel table formulas can use column names like =[Amount] or Table1[Amount]. Google Sheets Tables support table-aware references too, with product-specific syntax. Prefer table column names over brittle letter columns when the dataset grows.
Read guide →Flash Fill
Excel Flash Fill guesses a pattern from examples you type. Google Sheets Smart Fill is the closest feature: accept suggestions when cleaning or splitting data. REGEX, SPLIT, and formulas still win when you need repeatable logic.
Read guide →Inquire
Excel Inquire audits workbooks for formulas, links, and inconsistencies. Google Sheets has no Inquire add-in; use version history, Find, protect ranges, and optional compare copies. Apps Script can inventory formulas on a tab if you need a checklist.
Read guide →Spreadsheet Compare
Spreadsheet Compare is Microsoft's diff tool for Excel files. Google Sheets uses version history and named versions to see who changed what; make a copy and use conditional formulas to flag differences between tabs for formal compares.
Read guide →Protect Workbook
Excel Protect Workbook locks structure: sheets, windows, and sometimes cells with passwords. Google Sheets protects sheets and ranges through Data > Protect sheets and ranges, plus Drive sharing roles. There is no workbook-level password separate from your Google account.
Read guide →Sheet password
Excel lets you password-protect sheets independent of Windows login. Google Sheets protection is tied to Google accounts and sharing permissions, not a sheet password prompt. Use restrict editors, protect ranges, and confidential sharing links instead.
Read guide →Shared Workbook
Excel Shared Workbook was a legacy multi-user mode with limitations. Google Sheets is built for simultaneous editing in the browser with live cursors and comments. Turn on appropriate share roles instead of enabling a special shared mode.
Read guide →Co-authoring
Co-authoring means multiple people edit the same file at once. Google Sheets does this natively in the browser; Excel Online supports similar live editing, while desktop Excel co-authoring depends on cloud save. Expect fewer lock conflicts than old Shared Workbook.
Read guide →Autosave
Excel Autosave requires OneDrive or SharePoint for continuous cloud saves. Google Sheets saves every edit to Drive automatically without a toggle. Use Version history to roll back mistakes instead of hunting for AutoRecover files.
Read guide →AutoRecover
Excel AutoRecover restores unsaved desktop crashes from a local cache. Google Sheets continuously saves to the cloud; open Version history or named versions to restore earlier states. Drive still benefits from stable network during long edits.
Read guide →Windows Regional Settings
Excel on Windows often follows OS regional settings for decimals and dates. Google Sheets uses File > Settings > Locale for separators and date parsing, independent of the operating system. Match locale when formulas use semicolon argument separators.
Read guide →Dynamic arrays (Excel)
Excel 365 dynamic arrays spill results into neighboring cells like modern Google Sheets. Both support FILTER, UNIQUE, SORT, and SEQUENCE-style helpers, but spill rules and @ syntax differ. Test imported workbooks for #SPILL! and locale separators.
Read guide →refresh all
Refresh All covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →evaluate formula
Evaluate Formula is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →error checking
Error Checking is part of how Google Sheets surfaces formula problems, warnings, or diagnostics. Catching the message early keeps bad values from flowing into dashboards and reports.
Read guide →manual calculation
Recalculation settings control when Sheets recomputes formulas after edits. Manual calc and iteration are advanced workbook behaviors; most sheets stay on automatic recalc.
Read guide →Format as Table
Excel Format as Table turns a range into a structured table with filters and banded rows. Google Sheets now has Tables too: select data and use Insert > Table for headers, column types, and table actions. Syntax for structured references differs from Excel.
Read guide →Table style
Table Style refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →Total row
Total Row refers to Google Sheets Tables: structured ranges with headers, column types, filters, and table formatting. Tables behave more like lightweight databases than plain rectangular ranges.
Read guide →CSE array
Array formulas compute across many cells at once. Google Sheets now spills results automatically; older CSE array habits still appear in legacy tutorials.
Read guide →implicit intersection
Implicit Intersection is part of how formulas behave, parse, or display in Google Sheets. It shows up when you build models, debug results, or teach spreadsheet mechanics beyond a single function name.
Read guide →ODS
Ods covers bringing data into Google Sheets or sending it out as CSV, Excel, PDF, or print layouts. Import and export choices affect encoding, page breaks, and whether links survive the trip.
Read guide →Templates, forms, and onboarding
Workbooks, Google Forms, timestamps, and Marketplace add-ons.
Google Sheets templates
A template is a master spreadsheet layout you copy before real work begins: tabs, formulas, dropdowns, and instructions pre-built so each new project starts consistent. Templates live in your Drive, Google's template gallery, or a shared team folder. The goal is clone once, customize names and settings, never edit the golden master in place.
Read guide →workbooks and multiple tabs
In Google Sheets a workbook is the whole spreadsheet file containing one or more tabs (sheets). Each tab has its own grid, but tabs share the file's permissions, Apps Script project, and named ranges. Smart workbook structure separates raw data, calculations, and presentation so editors know which tab to touch.
Read guide →onboarding users to a spreadsheet
Onboarding teaches new editors where to type, what not to touch, and how work flows through the file. A strong onboarding sheet combines a README tab, protected formula areas, sample rows, and a short checklist so first-time users succeed without breaking dashboards or overwriting settings.
Read guide →Google Workspace Marketplace for Sheets add-ons
The Google Workspace Marketplace is Google's directory where users discover and install Sheets add-ons and other Workspace extensions. Developers publish a listing with description, screenshots, privacy policy, and OAuth scopes; Google reviews the app before it appears in Install flows inside Sheets and admin consoles.
Read guide →Google Sheets add-ons
Add-ons are third-party extensions you install into Google Sheets from the Google Workspace Marketplace. They add menus, sidebars, and workflows for mail merge, CRM sync, charting, and more without writing your own Apps Script from scratch. Each add-on runs with permissions you approve at install time.
Read guide →Google Forms
Google Forms can send each submission as a new row in a linked spreadsheet. Create the form from Forms or insert a form from Sheets. Response columns match question titles. Sheets becomes the system of record for analysis, mail merges, and Apps Script automation while Forms handles data entry UX on phone and desktop.
Read guide →Timestamp
A timestamp records when something happened: form submitted, status changed, row edited. Use NOW or TODAY for live clock cells, keyboard shortcut Ctrl+Shift+; for static entry time, or onEdit Apps Script to stamp when a checkbox flips. Format cells as date time so serial numbers display human-readably.
Read guide →form submit
Form Submit connects Google Forms responses to a spreadsheet: submit events, response tabs, and timestamp columns. Forms are the friendly front door; the sheet is the system of record.
Read guide →form URL
Form Url connects Google Forms responses to a spreadsheet: submit events, response tabs, and timestamp columns. Forms are the friendly front door; the sheet is the system of record.
Read guide →response sheet
Response Sheet connects Google Forms responses to a spreadsheet: submit events, response tabs, and timestamp columns. Forms are the friendly front door; the sheet is the system of record.
Read guide →timestamp column
Timestamp Column connects Google Forms responses to a spreadsheet: submit events, response tabs, and timestamp columns. Forms are the friendly front door; the sheet is the system of record.
Read guide →View in Forms
View In Forms connects Google Forms responses to a spreadsheet: submit events, response tabs, and timestamp columns. Forms are the friendly front door; the sheet is the system of record.
Read guide →Extend and automate Sheets
APIs, automation patterns, and multi-step workflows.
Google Sheets API
The Google Sheets API lets other programs read and update spreadsheets over HTTP using JSON. It is how dashboards, backends, and mobile apps sync data without opening the Google Sheets UI. Apps Script inside a file is simpler for sheet owners; the API fits systems built in Python, Node, or other stacks.
Read guide →Google Sheets automation
Automation means work happens without repeating the same clicks every day: imports update, emails send, rows move, and dashboards refresh. In Sheets, automation usually stacks built-in features, Apps Script, and sometimes the Sheets API or add-ons. Start with the lightest tool that still solves the job.
Read guide →Google Sheets workflows
A workflow is the path work takes through your sheet: intake, review, approval, done. Good workflows use consistent columns, statuses everyone understands, and just enough automation to move tasks forward without hiding steps from the team.
Read guide →workflow handoffs
A handoff is the moment one person or team finishes their step and another picks up the same row in a shared sheet. Good handoffs use Owner, Status, and Handoff date columns plus rules so work does not sit invisible after someone marks Ready for finance or Needs legal review. Sheets handoffs scale from simple dropdowns to MailApp alerts when status changes.
Read guide →gid
Gid is an identifier or URL parameter for Google Sheets files, tabs, or linked forms. Developers and power users need these IDs for IMPORTRANGE, API calls, and prefilled form links.
Read guide →viewform
Viewform is an identifier or URL parameter for Google Sheets files, tabs, or linked forms. Developers and power users need these IDs for IMPORTRANGE, API calls, and prefilled form links.
Read guide →document ID
Document Id is an identifier or URL parameter for Google Sheets files, tabs, or linked forms. Developers and power users need these IDs for IMPORTRANGE, API calls, and prefilled form links.
Read guide →drive ID
Drive Id is an identifier or URL parameter for Google Sheets files, tabs, or linked forms. Developers and power users need these IDs for IMPORTRANGE, API calls, and prefilled form links.
Read guide →entry ID
Entry Id is an identifier or URL parameter for Google Sheets files, tabs, or linked forms. Developers and power users need these IDs for IMPORTRANGE, API calls, and prefilled form links.
Read guide →file ID
File Id is an identifier or URL parameter for Google Sheets files, tabs, or linked forms. Developers and power users need these IDs for IMPORTRANGE, API calls, and prefilled form links.
Read guide →gid parameter
Gid Parameter is an identifier or URL parameter for Google Sheets files, tabs, or linked forms. Developers and power users need these IDs for IMPORTRANGE, API calls, and prefilled form links.
Read guide →prefilled form
Prefilled Form is an identifier or URL parameter for Google Sheets files, tabs, or linked forms. Developers and power users need these IDs for IMPORTRANGE, API calls, and prefilled form links.
Read guide →sheet ID
Sheet Id is an identifier or URL parameter for Google Sheets files, tabs, or linked forms. Developers and power users need these IDs for IMPORTRANGE, API calls, and prefilled form links.
Read guide →spreadsheet ID
Spreadsheet Id is an identifier or URL parameter for Google Sheets files, tabs, or linked forms. Developers and power users need these IDs for IMPORTRANGE, API calls, and prefilled form links.
Read guide →spreadsheet key
Spreadsheet Key is an identifier or URL parameter for Google Sheets files, tabs, or linked forms. Developers and power users need these IDs for IMPORTRANGE, API calls, and prefilled form links.
Read guide →Sell and monetize spreadsheets
Paywalls, Stripe, storefronts, and template sales.
monetize Google Sheets templates
Monetizing a Google Sheets template means selling a licensed copy, not sharing your master file. You package a polished workbook, set a price, deliver via copy link or automated email after payment, and keep support boundaries clear so buyers know what updates they receive.
Read guide →paywall for spreadsheet products
A spreadsheet paywall limits who can use premium tabs, scripts, or copy links until someone pays or joins. In Google Sheets this usually means view-only masters, license keys checked by Apps Script, or delivery only after Stripe confirms payment. It is access control for templates and add-ons, not DRM perfection.
Read guide →Stripe with Google Sheets
Stripe handles card payments while Google Sheets tracks customers, fulfillment, and template delivery. You connect them with Payment Links or Checkout, optional webhooks into Apps Script, and a Fulfillment tab that logs paid emails, SKUs, and copy links sent after each successful charge.
Read guide →spreadsheet storefront
A spreadsheet storefront is the shop window for your Google Sheets products: landing pages, preview images, pricing, FAQs, and Stripe buy buttons that lead to copy links or add-on installs. The sheet is the product; the storefront is how strangers discover and trust it enough to pay.
Read guide →OnlySheets
OnlySheets is a Better Sheets product for selling spreadsheet templates without giving buyers edit access to your master file. It connects checkout tools like Gumroad and Stripe to controlled copy delivery, license ideas, and seller workflows so template businesses scale beyond manual email fulfillment.
Read guide →Gumroad
Gumroad is a checkout and delivery platform creators use to sell digital products, including Google Sheets templates. You list a product, set a price, and deliver a file or link on the thank-you page and purchase email. Pair Gumroad with copy-only sheet links or OnlySheets automation so buyers never touch your master workbook.
Read guide →Zapier
Zapier is a no-code automation service that connects Google Sheets to other apps through triggers and actions. A common pattern is New row in sheet sends Slack message or adds a CRM contact. It is the bridge when stakeholders want integrations without opening the Script Editor.
Read guide →Better Sheets membership
Membership is paid access to the Better Sheets library: video courses, tutorials, unlimited formula and regex generators, member templates, Apps Script Explainer passes, and one hosted sheet site on a bettersheets.co subdomain. Free visitors can browse tools with daily generation caps.
Read guide →AppSumo
AppSumo is a marketplace where Better Sheets sells a lifetime deal: one payment (about $275) for full catalog access without monthly billing. Buyers receive a license code to redeem on bettersheets.co, unlocking courses, generators, tools, and member benefits similar to subscription members with plan-specific Explainer caps.
Read guide →lifetime access
Lifetime access means you pay once through AppSumo and keep Better Sheets member benefits without a monthly or yearly subscription. It covers courses, tutorials, generators, templates, and tools in the catalog, with daily Explainer pass caps defined on the pricing FAQ rather than unlimited forever on every AI surface.
Read guide →Better Sheets tools and hosting
Explainer, Sites, Portal Builder, and hosted sheet sites.
Apps Script Explainer
The Apps Script Explainer is a Better Sheets AI tool that reads JavaScript code from Google Apps Script and returns a plain-language walkthrough of what it does. Paste a function or whole file, get step-by-step explanations, and spot risky patterns before you run unfamiliar code in a production spreadsheet.
Read guide →Better Sheets Sites
Sites is a Better Sheets feature that turns a Google Sheet into a hosted web page at yourname.bettersheets.co. Pick a layout template (catalog, directory, gallery, feed, dashboard, or simple), connect your sheet, and publish without building a separate website stack.
Read guide →hosted site
A hosted site is a web page Better Sheets serves for you, backed by rows in your Google Sheet, at a URL like yourslug.bettersheets.co. You edit data in Sheets; visitors see the styled template without needing sheet access.
Read guide →subdomain
A subdomain is the first part of your hosted site URL on bettersheets.co, such as acme.bettersheets.co for Acme's catalog site. It gives you a memorable link without buying a separate domain on day one.
Read guide →Portal Builder
Portal Builder is a Better Sheets product for building member or client portals powered by sheet data, separate from public Sites templates. Use it when viewers need login, sections, or private views instead of a fully public catalog page.
Read guide →Apps Script triggers and events
Simple and installable triggers that react to edits, opens, and form submissions.
onEdit trigger
The onEdit trigger runs a script automatically when someone changes a cell in your spreadsheet. It is one of the simplest ways to make Sheets react to user input without clicking a custom menu. You define the function in Apps Script and bind it to the onEdit event for that file.
Read guide →onOpen trigger
The onOpen trigger runs an Apps Script function automatically when someone opens the spreadsheet. It is the standard way to add custom menus, show instructions, or refresh lightweight cache without asking the user to run a macro first. Name the function onOpen or bind it as an installable open trigger.
Read guide →onFormSubmit trigger
The onFormSubmit trigger runs an Apps Script function when a linked Google Form adds a new row to your spreadsheet. It fires after the response lands in the sheet, so your script can route data, send notifications, or stamp IDs without waiting for someone to open the file.
Read guide →Apps Script triggers
Triggers tell Apps Script when to run a function: on edit, on open, on a schedule, or when a form is submitted. Simple triggers use reserved names like onEdit. Installable triggers are created in the Apps Script Triggers page and can do more, including running as a specific user or on a timer.
Read guide →simple trigger
A simple trigger is an Apps Script function with a reserved name such as onEdit, onOpen, or onInstall that Google Sheets runs automatically when that event happens. You do not create it in the Triggers UI; you just name the function correctly in Code.gs.
Read guide →installable trigger
An installable trigger is configured in Apps Script > Triggers and binds a function to an event such as on edit, on form submit, or time-driven clock. It can run with authorization the simple trigger cannot, and you can set failure notifications.
Read guide →time-driven trigger
A time-driven trigger (clock trigger) runs an Apps Script function on a schedule you choose, such as every hour or every Monday at 8 a.m. It works even when the spreadsheet is closed, subject to Apps Script quotas.
Read guide →Apps Script tools and services
Editor, MailApp, SpreadsheetApp, deployments, quotas, and clasp.
Script Editor
The Script Editor is the Apps Script workspace inside your spreadsheet where you write JavaScript that talks to Sheets, Gmail, and other Google services. You open it from Extensions > Apps Script. Every function you save can be run manually, bound to a trigger, or linked from a custom menu.
Read guide →MailApp
MailApp is an Apps Script service that sends email from your Google account without opening Gmail. You call MailApp.sendEmail with a recipient, subject, and body, often using cell values as the content. It is the fastest way to notify someone when a row is added or a deadline hits in a tracker.
Read guide →Apps Script loops
Loops in Apps Script let you repeat code over rows, columns, sheets, or API pages. You read ranges into arrays with getValues(), process each item in a for or forEach loop, then write results back in one setValues() call when possible. Batch reads and writes beat cell-by-cell updates for speed and quota limits.
Read guide →Google Sheets macros
A macro records your clicks and keystrokes in Google Sheets, then saves them as an Apps Script function you can run again from the Extensions menu or a keyboard shortcut. Macros are the fastest on-ramp to automation when your task is a fixed sequence of formatting or edits.
Read guide →SpreadsheetApp
SpreadsheetApp is the main Apps Script service for talking to Google Sheets. It lets your script open the active spreadsheet, grab sheets by name, read cells, write values, and change formatting. Almost every Sheets automation starts with SpreadsheetApp.getActiveSpreadsheet().
Read guide →UrlFetchApp
UrlFetchApp lets Apps Script send HTTP requests to external URLs and read the response. You use it to pull data from APIs, post webhooks, or sync sheet rows with tools like Slack, Stripe, or your own server. It is the bridge between your spreadsheet and the rest of the web.
Read guide →HtmlService
HtmlService lets Apps Script show custom HTML as a dialog, sidebar, or full web app page inside or beside your spreadsheet. You design the UI with HTML and CSS, then call server functions with google.script.run to read and write sheet data without building a separate website.
Read guide →PropertiesService
PropertiesService stores small key-value strings that persist between script runs. Use it for API tokens, last sync timestamps, feature flags, or webhook secrets instead of hiding values in cells. Script, user, and document property stores each serve different sharing and scope needs in a spreadsheet project.
Read guide →CacheService
CacheService stores short-lived strings in memory-like cache scoped to the script. Scripts use it to avoid rereading huge ranges or calling slow APIs on every web app hit. Entries expire automatically after a time-to-live you choose, up to six hours per key.
Read guide →LockService
LockService gives your script a mutex so only one execution holds a lock at a time. In busy spreadsheets, two triggers firing together can both read the same last row and write duplicates. LockService.waitLock and releaseLock serialize critical sections like appendRow, counter increments, or quota-sensitive API calls.
Read guide →clasp
clasp is Google's command line tool for developing Apps Script outside the browser. You clone a script project to local .gs and .html files, edit in VS Code or Cursor, and push changes back with clasp push. Teams use it for git version control, code review, and faster refactors on large sheet automations.
Read guide →Apps Script quotas
Quotas are daily and per-run limits Google places on Apps Script, such as how long a function may run, how many emails you can send, and how many URL fetches you can make. Consumer Gmail and Workspace accounts have different caps. Hitting a quota stops your automation until the reset window, often the next day.
Read guide →bound script
A bound script, also called a container-bound script, lives inside a specific spreadsheet file. You open it from Extensions > Apps Script and it travels with that workbook. getActiveSpreadsheet() works naturally because the script and sheet share one container. Most spreadsheet automations beginners build are bound scripts.
Read guide →Apps Script library
An Apps Script library is a shared script project you attach to other projects by script ID. Instead of copy-pasting the same utility functions into fifty workbooks, you publish one library and call LibraryName.doSomething() from each bound sheet. Libraries help teams standardize CRM helpers, API wrappers, and formatting tools.
Read guide →Apps Script scopes
Scopes are permission strings your script requests to access Google services: read spreadsheets, send email, fetch external URLs, or read Drive files. The first time a function needs a scope, Google shows an authorization dialog. Users and admins must approve before MailApp, UrlFetchApp, or advanced APIs work in triggers and web apps.
Read guide →Apps Script deployment
A deployment publishes a snapshot of your Apps Script project for others to use. Web app deployments expose a URL running doGet and doPost. Each deployment has a version, execution identity, and access setting. Editing code in the editor does not change a live deployment until you deploy a new version or update the deployment.
Read guide →Apps Script web apps
A web app turns your script into a URL that runs doGet or doPost when someone visits or posts data. The page can read and write your spreadsheet behind the scenes, which is useful for simple forms, internal tools, and lightweight APIs without standing up a separate server.
Read guide →Google Apps Script
Apps Script is Google's JavaScript platform for automating Sheets and other Workspace apps. From a spreadsheet you can open Extensions > Apps Script to write code that reads cells, sends email, builds menus, and runs on triggers. It goes beyond formulas when you need custom workflows tied to your file.
Read guide →Google Sheets add-ons
Add-ons are third-party extensions you install into Google Sheets from the Google Workspace Marketplace. They add menus, sidebars, and workflows for mail merge, CRM sync, charting, and more without writing your own Apps Script from scratch. Each add-on runs with permissions you approve at install time.
Read guide →Apps Script snippets
Snippets are short, copy-paste Apps Script code examples for focused tasks like exporting CSV, sending email, or reading a range. Better Sheets hosts a searchable snippets library on the Apps Script hub so you start from working code instead of a blank Script Editor.
Read guide →custom menu
A custom menu is a menu bar section your Apps Script adds with SpreadsheetApp.getUi().createMenu(), typically from an onOpen trigger. It gives teammates one-click buttons for exports, sorts, or wizards instead of remembering hidden functions.
Read guide →webhook
A webhook is an HTTP callback: when an external service event fires (payment, form, CRM update), it POSTs JSON to a URL you control. In Better Sheets stacks, webhooks often hit Apps Script doPost or OnlySheets endpoints to append fulfillment rows or grant sheet copy access.
Read guide →authorization
Authorization is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →authorization required
Authorization Required is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →bound project
Bound Project is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →calculation settings
Calculation Settings is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →clasp clone
Clasp Clone is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →clasp push
Clasp Push is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →clock trigger
Clock Trigger is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →created at
Created At is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →custom dialog
Custom Dialog is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →deploy as
Deploy As is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →deployment ID
Deployment Id is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →document properties
Document Properties is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →event object
Event Object is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →execute as
Execute As is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →File settings
File Settings is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →HTML sidebar
Html Sidebar is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →import macro
Import Macro is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →library project
Library Project is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →Manage macros
Manage Macros is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →modal dialog
Modal Dialog is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →modeless dialog
Modeless Dialog is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →page setup
Page Setup is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →pivot cache
Pivot Cache is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →project triggers
Project Triggers is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →script project
Script Project is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →Setup tab
Setup Tab is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →slicer settings
Slicer Settings is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →Spreadsheet settings
Spreadsheet Settings is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →standalone script
Standalone Script is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →timeline settings
Timeline Settings is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →user properties
User Properties is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →Extensions Apps Script
Extensions Apps Script is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →web app URL
Web App Url is Apps Script project vocabulary around deployments, triggers, authorization, and the script editor. These concepts sit above individual API methods documented on Better Sheets snippet pages.
Read guide →Apps Script range methods
getValue, setValues, getRange, appendRow, flush, and related APIs.
getValue
getValue reads the value from one cell in a Range object. It returns what you see in the grid as a string, number, date, or boolean. Scripts use getValue when they need one field at a time, such as a status flag, email address, or threshold from a Settings tab.
Read guide →getValues
getValues reads every cell in a range into a two-dimensional JavaScript array. The outer array is rows and the inner arrays are columns. It is the standard way to pull a table from a sheet, loop through it, filter rows, and write results elsewhere in one efficient pass.
Read guide →setValue
setValue writes a single value into one cell on a Range object. Pass a string, number, boolean, or Date and Apps Script stores it in the grid. It is the simplest write operation and appears constantly in triggers, menus, and small automations that update one field at a time.
Read guide →setValues
setValues writes a two-dimensional array into a rectangular range in one operation. Each inner array is a row. It is the fastest way to paste a block of results, copy transformed data, or fill a table from an API response without updating cells one by one.
Read guide →getRange
getRange returns a Range object pointing at one or more cells on a sheet. You call it on a Sheet to read with getValue or getValues and write with setValue or setValues. Correct range targeting is the foundation of almost every Sheets script.
Read guide →getLastRow
getLastRow returns the position of the last row on a sheet that contains any content in any column. Scripts use it to find where to append new data, size a getRange read, or loop only through populated rows instead of a million blank grid lines.
Read guide →appendRow
appendRow adds one new row to the bottom of the first used table on a sheet, filling values left to right across columns. It is the quickest way to log an event, store a form response field set, or push one record without calculating the next row number manually.
Read guide →SpreadsheetApp.flush
SpreadsheetApp.flush() forces pending spreadsheet changes from your script to apply immediately. Apps Script batches some writes for performance, so flush makes sure the grid, charts, or a following read sees updates right away. It is a small call that matters in timing-sensitive automations.
Read guide →doGet
doGet is a special function Apps Script calls when someone opens your web app URL with a browser GET request. It can return an HTML page from HtmlService, plain text, or JSON from ContentService. It is the front door for read-only views, lookup tools, and simple APIs backed by your sheet.
Read guide →doPost
doPost is the Apps Script handler for HTTP POST requests to your web app URL. External forms, Zapier, or custom clients send data in the request body, and doPost parses it and writes to your spreadsheet. Pair it with doGet when you need both a landing page and a submit endpoint.
Read guide →Common questions
- What is the Google Sheets glossary?
- The glossary is a set of plain-English guides to common Google Sheets terms and workflows. Each page explains what a concept means, when to use it, common mistakes, and links to Better Sheets tutorials.
- Who is this glossary for?
- Beginners and intermediate users who hear terms like onEdit, KPI tracker, or conditional formatting and want a clear starting point before diving into formulas, Apps Script, or dashboards.
- How do I go deeper after reading a term?
- Every glossary page includes related terms, Better Sheets resources, and tutorial search results matched to that topic so you can watch a walkthrough or try a generator tool on the same subject.
You Might Also Like These
Watch sheets built step by step.
Study Better With Google Sheets
Visicalc 2023 Technical Walkthrough
Use Index Match when you want Vlookup
Build The Dashboard - Design a Better Dashboard Part 3
How do I reference a different spreadsheet in Apps Script?
Find Column with Header to Bullet Proof your Vlookup
You might want to read this too
Read all about it.
The Hidden Joys of a Well-Crafted Spreadsheet
We delve into how a good design can make it easier to find, edit, and input data, and how it can be beneficial to your everyday work. It can help yourself and others.
Read post →When did you learn the secrets of Google Sheets? | Sheet Talking Episode 8 Esa
Esa is a beginner at Google Sheets. I discover the moment he discovered the deepest secrets of Google Sheets. And we wax poetic about AI in sheets, and data flow.
Read post →How to Use Google Sheets for Advanced Project Management
Master Google Sheets for project management with these advanced tips. Check our free tutorials, tools, and templates for data management, task flow, and much more.
Read post →Stuck on a Sheets term?
Membership unlocks 637+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.