how do i delete all non filtered rows in Excel

Fresh3 days ago

Mar 15, 202679560 views

Confidence Score0%

0%

Problem

if i have an excel sheet and i filter by a certain column, how do i then delete all non visible rows?

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: how do i delete all non filtered rows in Excel

Low Risk

When you have all your filters selected you can highlight what remains and then click: Excel 2007: Excel 2003: Copy and paste into a new sheet.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment