Filter a list

A filter hides the rows that do not match. Nothing is deleted.

2 steps1 minutesPlans: Free, Personal, Pro, Enterprise

  1. 1

    Press Filter

    On the Data tab. Each column title gets an arrow.

    Press Filter
  2. 2

    Press the arrow on a column

    Tick the values to show, then press OK.

    Press the arrow on a column

    Clear, next to Filter, shows every row again.

Was this helpful?

We count yes and no per article. Nothing about you is stored.

Still stuck? Ask us.

People, not a bot. We answer within one working day.