Set slicer filters as default in Google Sheets
Use the existing Status slicer to show only Open rows, then leave that filter applied as the slicer's saved default. Do not change or delete any cell values.
Verified by JosephineAbout 60 secondsUse the existing Status slicer to show only Open rows, then leave that filter applied as the slicer's saved default. Do not change or delete any cell values.
Step-by-step
Select the targetUse the existing Status slicer to show only Open rows.
Apply the changeleave that filter applied as the slicer's saved default.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
The Status slicer hides Closed and keeps Open visible.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Undo the last change, reselect the intended range, and try again. The Status slicer hides Closed and keeps Open visible.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Region | Owner | Status | Revenue |
| West | Anna | Open | 1200 |
| East | Ben | Closed | 900 |
| West | Cara | Open | 1500 |
| North | Dev | Closed | 1100 |
| East | Eva | Open | 1300 |
Video transcript
- Open the prepared Regional revenue spreadsheet.
- Select the target. Use the existing Status slicer to show only Open rows.
- Apply the change. leave that filter applied as the slicer's saved default.
- The Status slicer hides Closed and keeps Open visible.