Channel: Excel Campus - Jon

Category: Education

Tags: excel keep crashingspeed up excelexcel stop workingexcel slow to delete columnsexcel is not respondinghow to fix excel not responding/ freezing or slow / hang issuesexcelexcel not responding excel hangsfreezinghang issuesexcel campushow to troubleshoot crashing issuesmicrosoft office not respondingexcel slow to delete rows

Description: 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. excelcampus.com/tips/sort-data-before-deleting-rows