To further investigate the problem and see some data about your entire workbook, you can go to the Workbook statistics in the Review tab in Excel, and look at the workbook statistics.
![excel not enough memory to delete column excel not enough memory to delete column](http://home.ubalt.edu/abento/ntfaq/ipaddress.gif)
![excel not enough memory to delete column excel not enough memory to delete column](https://ginger-automation.github.io/assets/images/image707.png)
With your spreadsheet open, go to File > Info, and on the right-side you should see the size on disk of your workbook:Ĭheck your Excel file size easily, from Excel
#EXCEL NOT ENOUGH MEMORY TO DELETE COLUMN HOW TO#
How to check the file size of your Excel spreadsheet? Finally, with a few keystrokes, I show you how you can clear the problem, reduce your excel file size and delete unnecessary or blank rows and columns in your Excel workbook so that it is optimized. Let's have a look at how you can check the size of your Excel workbook, how to inspect the worksheets to figure out which worksheet is too large or is causing the size issue, then look at a few cool keyboard shortcuts to help you move around and diagnose the problem and make your excel spreadsheet smaller. All these are symptoms that the file has a size problem - in-memory or on disk. Sometimes you work on an Excel file with one or more Worksheets and when you save, you notice the saving is slower, takes longer to move around or open the right-click menus, etc. Reducing the file size of your Excel worksheets is easy, all you have to do is identify what is causing the problem. I've had a situation like this recently, with an Excel spreadsheet that didn't have a lot of data, but the file size on disk was more than 15 times larger than it should have been. Sometimes working in Excel, moving data around, creating worksheets and removing, copy pasting, all that work can lead to huge file sizes, without realizing.