Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video, I explain how sorting rows before deleting them can save you tons of time and frustration. We’ll take a task that takes 10+ seconds and turn it into less than a second.

Excel can freeze or go into Not Responding mode when you delete rows from a large filtered range or table. This happens when the data is not sorted. Excel has to delete each non-contiguous area individually. It’s a labor intensive process that can take seconds or minutes depending on the complexity of your workbook.

In the video I share several techniques for sorting your data, retaining or restoring the original sort order, what to do if you have multiple filter criteria in one or more columns, and more.

You’ll also learn how to use VBA to find the number of areas in a range, which helps determine what might be causing the slow down.

Here is the line of code I mentioned in the video.

?Selection.SpecialCells(xlCellTypeVisible).Areas.Count

Read the full article and download the sample file here.

https://www.excelcampus.com/tips/sort-data-before-deleting-rows/
00:00 Introduction
00:24 Demo
04:02 Trick