|
Microsoft Excel saves only the part of each worksheet that is in use, that is the section that contains data and/or formatting.
Sometimes the last cell of a worksheet (used range) may be well beyond the range of your actual used data (real range). This issue may increase substantially the file size of your Excel workbook. |
The most common cause of the last cell being set outside the real data range is excessive formatting. When you format whole rows and columns, some types of formatting can cause the last cell to be set to a cell far below or to the right of the actual data range that is being required.
Unused rows and columns can be deleted manually or automatically by using a free Microsoft add-in.
Please read: Article ID-244435 "How to reset the last cell in Excel" for detailed information and for a link to download the add-in.
Caution: An Excel workbook could increase in size substantially for various other reasons, including file corruption. Excel may eventually crash, if the file size keeps increasing past a critical limit.
Please contact us for an assessment, if the file size of an Excel workbook seems suddenly abnormal!
Unused rows and columns can be deleted manually or automatically by using a free Microsoft add-in.
Please read: Article ID-244435 "How to reset the last cell in Excel" for detailed information and for a link to download the add-in.
Caution: An Excel workbook could increase in size substantially for various other reasons, including file corruption. Excel may eventually crash, if the file size keeps increasing past a critical limit.
Please contact us for an assessment, if the file size of an Excel workbook seems suddenly abnormal!
