When clicking on a cell and looking at its Protection under format cells...
default setting is locked... but is only locked IF the sheet is protected.

When you delete the rows and columns as Purfleet has described the size won't reduce until Excel re-establishes the used range of the sheets which it does upon closing and saving the file.