LIMIT and OFFSET in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the LIMIT function do in Google Sheets QUERY?

LIMIT restricts the number of rows returned by a QUERY to a specified number. For example, LIMIT 5 returns only the first 5 rows of the result.

beginner

What is the purpose of OFFSET in a Google Sheets QUERY?

OFFSET skips a specified number of rows before starting to return rows in a QUERY. For example, OFFSET 3 skips the first 3 rows and starts returning from the 4th row.

intermediate

How do LIMIT and OFFSET work together in a QUERY?

LIMIT and OFFSET can be combined to return a specific 'page' of rows. OFFSET skips rows, then LIMIT returns the next set. For example, LIMIT 3 OFFSET 5 returns rows 6, 7, and 8.

intermediate

Write a QUERY formula to get 10 rows starting from the 6th row of data in range A1:C100.

The formula is =QUERY(A1:C100, "SELECT * LIMIT 10 OFFSET 5", 1). OFFSET 5 skips first 5 rows, LIMIT 10 returns next 10 rows.

intermediate

Why might you use OFFSET in a QUERY instead of just filtering data?

OFFSET helps to skip a fixed number of rows, useful for paging through data or ignoring headers. Filtering changes which rows show based on conditions, OFFSET just skips rows by position.

What does OFFSET 3 do in a QUERY?

A Limits output to 3 rows

B Returns the first 3 rows

C Skips the first 3 rows

D Sorts data by 3rd column

OFFSET 3 skips the first 3 rows before returning data.

How do you limit a QUERY to show only 5 rows?

A Use LIMIT 5

B Use SORT 5

C Use FILTER 5

D Use OFFSET 5

LIMIT 5 restricts the QUERY output to 5 rows.

Which QUERY clause would you use to skip rows?

A OFFSET

B WHERE

C LIMIT

D ORDER BY

OFFSET skips a number of rows before returning results.

What does this QUERY do? =QUERY(A1:B10, "SELECT * LIMIT 3 OFFSET 2")

A Returns rows 1 to 3

B Returns rows 3 to 5

C Returns rows 2 to 4

D Returns all rows

OFFSET 2 skips first 2 rows, LIMIT 3 returns next 3 rows (rows 3,4,5).

Can LIMIT be used without OFFSET in a QUERY?

A Only with SORT

B No, OFFSET is required

C Only with FILTER

D Yes, to limit rows from the start

LIMIT alone limits rows starting from the first row.

Explain how LIMIT and OFFSET work together in a Google Sheets QUERY to show a specific set of rows.

Think about skipping some rows, then taking a few rows after.

Describe a real-life scenario where you might use OFFSET in a spreadsheet QUERY.

Imagine you want to see data starting from row 10, not the first rows.