Here's our Microsoft Office Tip for.. November 27, 2000
Click Here to see a complete list of all of our previously released Tips!
Slim Fast for your Worksheets
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.