Google Sheets has two ways you can filter your data: using a Filter or a Filter View. Using a Filter View has many advantages over using a Filter. This new Denison Google Sheets Using Filter Views video showcases why and how to use Filter Views. If you are not sure if you are using Filter Views, please watch!

Using Filter Views rather than Filters is one of a number of tips covered in the Denison Google Sheets – Large Data Sets guide. If you work with large spreadsheets, please check out the tips in this guide.

If you have questions on this or other Google Sheets topics, please contact the ITS Service Desk at servicedesk@denison.edu or 740-587-6395 or schedule an ITS Client Success virtual appointment.