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.

Hi NoSparks I was running another Excel workbook at the same time so I do not think that helped. Closing all Excell workbooks and restarting and then going through the delete unused rows and columns and saving and closing still doesn't reduce the workbook size. The file is being saved as i set up a test workbook and deleted one of the spreadsheets after anther and the file size started to reduce, particularly with the deletion of Tomato and Apples. The size of the spreadsheets are no more than 3K each and then a massive drop to 41MB.