Lessons › Excel & Google Sheets
Excel & Google Sheets lesson
Filter
Show only the rows you need
Try this lesson free →Key points
FilterShow only the rows that match, like one location.
Hidden, not deletedFiltered rows come back when you choose Show all.
One column, any valuesOpen a column's menu and tick what to keep.
Filter is in the Data menu of Excel and Google Sheets. Here, tap a column header to open its menu.
Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.
Try this lesson free →