Used range

Aused rangein an Excel worksheet is a concept that defines which cells in a worksheet have been used.

In any given worksheet, the current used range can impact how many cells are involved in certain calculations.

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.