What is selected range in Google Sheets?
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.
When to use it
Use QUERY clauses when you want SQL-style filtering, grouping, or labels on a table in one formula.
When to skip it
Skip QUERY when FILTER, SORT, and UNIQUE already express the logic with less string syntax to maintain.
Better Sheets resources
Related Tutorials
Watch how selected range works
Create a Public Sheet and Private Sheet: Using ImportRange()
Deep Inside Dark Habits Google Script
Automate Google Sheets With Zero Experience
Add Tasks to Google Tasks From Google Sheets
Convert Google Sheets into a REST API
Automated Project Management in Google Sheets
Related blog posts
Guides that explain selected range in more depth.
How to reference a different Google Spreadsheet in Apps Script?
Transferring Data Between Cells in Different Spreadsheets
Read post →Extract URLs from Google Sheets
Extract url from hyperlink google sheets.Skip the Command K. This Google Sheet tutorial will make it easier for you to extract URLS from Google Sheets.
Read post →Google Sheets Error: Unknown Range Name and How to Fix it
A user asked me about an error, which is the "Unknown Range Name." By the time you’ve read this tutorial, you’ll know how to fix this error. What is the Unknown Range Name error? It’s an error that you get when the value that was entered does not have the correct format. Another cause of this error is when the value that was entered is outside the expected range. As you can see right here, there’s the "Unknown Range Name" error. Now, what that means is that there is supposed to be ranges ...
Read post →Related terms
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 →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 →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 →Done reading about selected range?
Membership unlocks 637+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.