The used range is continually updated as changes are made to a worksheet, and includes any cell that has ever been used. For example, if A1 contains a value, and that value is deleted, cell A1 is still considered used. Sometimes, a worksheet will have a used range that is much larger than expected. This can cause performance problems and other unexpected behavior. One way to “reset” a used range is to delete all unused columns and rows. Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.