Delete filtered results from Table formatted sheet without removing the other rows

[LiifeStudent]

Hi every body,

I like formatting my spreadsheet as Tables as it makes it very easy to filter and sort data.

The only problem i have now is that when i filter data and i want to cut and paste the filtered data to another sheet, Excel cuts and pastes all the rows that are in between the filtered rows as well. is there any way i can filter data then cut and paste to another sheet without also cutting and pasting the rows in between the filtered rows?

thanks in advance for your help.

 

[udprocks]

@lifestudent

can u please upload a sample file?

 

[udprocks]

or you can use these steps...

1st select your filtered data and copy paste it another sheet.
2nd press Shift+space on filtered data and then Press CTRL+-

 

[LiifeStudent]

Hi udprocks,

Apologies for slow response. Was in a meeting.

Thanks for your help. works like a charm.

 

[udprocks]

No worries , mate.

happy to help.