This process takes longer with larger data sets that contain more rows, columns, and formulas. If the data is not sorted then Excel has to go through each set of visible rows and delete the row sections one by one. Well, deleting rows on a filtered range can be a very labor intensive process for Excel. Or maybe you have to sit around and watch the wait cursor spin, not sure if Excel is going to come out of “Not Responding” mode, while the rows are deleted…Įven worse, sometimes Excel freezes or crashes when you attempt to delete rows. Has your computer ever started smoking after you attempted to delete rows from a large filtered range? □ Sort Before Deleting Rows.xlsx Deleting Filtered Rows Can Take A Long Time!
0 Comments
Leave a Reply. |