The changes that you mentioned, i.e. deleting the empty columns (and rows), will only take effect when you save the workbook.

Hope this helps.

Pete