Articles on: Google Sheets

How can I see specific number of rows?

How can I see a specific number of rows?

Many times we only want to see part of the information, either because we only need a certain number of rows or because we want to reduce the loading time on large queries.

By default queries show the maximum number of rows (unless you are using the free plan which is limited to 1,000 rows).

You can change the number of rows** it in the option “# of rows” under the Metrics and Dims boxes, in the Data Table section.

Do you have any questions? Do not hesitate to write us through our website chat or through our email.

Updated on: 08/12/2022

Was this article helpful?

Share your feedback


Thank you!