Speed up deletion of rows when filter applied.
If when deleting rows with a filter applied included the following to the backround processing maybe it would help reduce wait time. This is based on the fact that deleting a single range of rows when no filter is applied is almost instantaneous:
Add 2 temporary columns, one to index (unique ID) each row to keep original sort, the second to give the filtered rows a reference of "2" and the unfiltered rows a reference of "1".
Sort the second column and delete down from rows containing "2".
Sort by Index column, delete both columns, cursor to A1.
I have to assume the brilliant minds behind the programming of excel have thought of everything but have to manually apply the above to save myself hours a day.
Working example as of 4 minutes ago: (Lenovo Thinkpad i7, latest Version of Excel as of 15/12/20)
Worksheet with Table, 72000 Rows, 84 Columns, 4 formulated Columns.
Deleted 32000 filtered rows where criteria for deletion was randomly distributed throughout spreadsheet: It took 36 minutes to delete.