NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Spreadsheet basics›Add a slicer

Google Sheets · Verified tutorial

Add a slicer in Google Sheets

Select A1:D6 and add a slicer from the Data menu. Set its column to Status and leave all values visible. Do not change any cell values.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Select A1:D6 and add a slicer from the Data menu. Set its column to Status and leave all values visible. Do not change any cell values.

Step-by-step

1

Select the targetSelect A1:D6 and add a slicer from the Data menu.

2

Apply the changeSet its column to Status and leave all values visible.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

A Status slicer covers exactly A1:D6.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select A1:D6 and repeat the final action. A Status slicer covers exactly A1:D6.

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. Select A1:D6 and add a slicer from the Data menu.
Apply the change. Set its column to Status and leave all values visible.
A Status slicer covers exactly A1:D6.