If removing unnecessary worksheets doesn't help, here are a few keyboard shortcuts to help you move around your worksheet faster and see what the problem is: CTRL + HOME Useful keyboard shortcuts to find problem areas in Excel Then save your document again and once the Excel file has saved, check the size again in File > Info, as described above. Whether they are blank or you think they are blank, if you don't need them, remove them. The first thing I would do is check which worksheets I don't need and delete them. Workbook Statistics shows useful info about your Excel workbook This should show you what's going on in your current worksheet as well as how many cells with data are in your workbook, how many worksheets you have and other useful info: 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. 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 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.
0 Comments
Leave a Reply. |