deleting filtered cell contents in excel

Hi,

Uploading a sample workbook would be helpful.

All I do is filter what I want to delete, go to the left side where the numbers are left click till an arrow appears and the row is highlighted drag down to highlight everything filtered then right click and select delete.

Once you have filtered data, then try below:

Sub DeleteVisibleRows()
Dim Ws As Worksheet
Set Ws = ActiveSheet
Application.ScreenUpdating = False
With Ws.AutoFilter.Range
    .Offset(1).Resize(.Rows.Count - 1).EntireRow.Delete
End With
Application.ScreenUpdating = True
End Sub

Select allOpen in new window

check this article as well:

How to delete all hidden rows or columns in Excel?
https://www.extendoffice.com/documents/excel/857-excel-delete-hidden-rows-columns.html

I'm using  the Inspect Document function for most of the cases.

I don't want to delete the hidden rows. I want to delete the data contained inside the visible rows.
I have uploaded a worksheet.
I have hidden the even numbered rows.
I only want to delete the contents of the visible (odd numbers) row and leave the hidden contents --even numbers--  intact
delete-odd-contents.xlsx

Thanks!