How to not delete filtered rows in excel

00:00welcome to Excel magic trick number 888

00:02hey this video right here is about the

00:06near infinity of Excel now many of us

00:11have been using Excel for years and

00:14years and all of us know this we come

00:16across something we'd never seen before

00:17but it's always been in Excel and the

00:20other day mr. Excel and one of the duels

00:22taught us all about filtering and

00:25deleting and so I just want to do that

00:28here real quick

00:29I have some supplier fun trains and we

00:31don't buy stuff from them anymore so I'm

00:33going to use control shift L turn on the

00:35filter and I'm going to filter this

00:37column and just show fun trains now I'm

00:41going to highlight and right click

00:43delete now just for a moment there you

00:47can see the visible cells are

00:50highlighted I'm going to click OK now it

00:52looks like all the records have been