Excel error filter, deletes hidden rows by accident

[Jenn1981]

Hi Everyone, I'm having a bug issue with my excel. I filter in excel for rows I want to delete but it also deletes the hidden rows. It happens sometimes. Not all the time. I dont know why.

 

[NARAYANK991]

Hi ,

If you can upload your workbook with the data in it , and explain for which data item the problem appears , it will be easier to detect the reason.

Narayan

 

[Syedali]

Hi,

Filter the data which you want.

Select all rows with selected data

Press ALT(+);

Press Ctrl(+)-

 

[Lymm]

You may need to select "visible cells only" ??