A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [google-sheets-filter]

Use this tag for questions about using the filter feature of the user interface of Google Sheets.

Filter by
Sorted by
Tagged with
23
votes
7answers
33k views

How to export a filtered set of rows from a Google Spreadsheet?

Is it possible, when exporting a Google Spreadsheet into a CSV, to apply this operation only to filtered set of rows? I need to get in CSV exactly the rows which are visible on the sheet after a ...
5
votes
2answers
10k views

Filtering a protected column

I'm trying to filter a protected column in a spreadsheet that I shared with other users. But I it looks like I can protect it or filter it with the other user but not both. In Excel I can do it ...
1
vote
2answers
558 views

Restrict ImportRange to only visible rows [duplicate]

I need to restrict the ImportRange function below to show only visible rows as some of the rows are filtered and some of the rows are grouped. =importrange("WorkbookID","Sheet1!A2:K13285")