
Are any of your workbooks consuming far more memory than they should? If so, the first thing you should consider is the possibility of unnecessarily formatted rows and columns. This can happen when you import foreign files because Excel converts all previously formatted cells, even if they're empty.
To reclaim that wasted memory, try this easy trick. Select all blank rows and columns beyond the last cell that contains data and press Delete. Then, save the workbook. The newly saved file should be much smaller than before.
To reclaim that wasted memory, try this easy trick. Select all blank rows and columns beyond the last cell that contains data and press Delete. Then, save the workbook. The newly saved file should be much smaller than before.


No comments:
Post a Comment