Forum Discussion
Delete Excess columns and rows
ManeshbNo, you can't delete those columns, but there's no reason to. Think of them as just unused addresses. They do no harm and take up no space. The thing you do want to watch is the USED space. Go to End-Home and see where that takes you. Ideally, it's the last cell you have data in, or ofted a cell in the last used row and last used column. If it's beyond that, it will take up space (potentially an enormous amount). Then you will want to select and delete unused rows and columns, and save the file. If you are deleting a million rows, say, it could take a few minutes for the deletion to finish. The "used space" won't change until the file is saved. I've reduced file size by 90%+ using this when the used space is seen as very extensive, tho unneeded. Deleting the unused rows and columns really doesn't do anything visible, except compact the used space.