How to Filter on Google Sheets on PC or Mac

Open Google Sheets in an internet browser. Type sheets.google.com into the address bar, and hit ↵ Enter or ⏎ Return on your keyboard.

Click the spreadsheet you want to edit. Find the spreadsheet you want to filter on your list of saved sheets, and open it.

Select the range of cells you want to filter. Click the first cell in the data range, and drag your mouse to select its adjacent cells.

Click the Filter icon on the toolbar. This icon looks like a funnel cone next to the function icon at the top of your spreadsheet. It will bold the first cell in your selected data range.

Click the three horizontal lines icon in the first cell of your cell range. This will open a pop-up menu.

Select a filter to apply to the selected cells. You can find a list of available conditional filters in the Filter by condition section, or manually enter a numeric value in the Filter by values section. If you select Filter by condition, click the drop-down menu and select a filter to apply. If you select Filter by values, enter the values you want to filter into the text box.

Click the blue OK button. This will filter the selected data range, and hide the filtered cells from your spreadsheet.