ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Size (https://www.excelbanter.com/excel-discussion-misc-queries/198592-size.html)

We have an Excel price sheet that is over 2mb. If we copy and paste all the
information into a new Excel book, the file size is less that 1mb. What can I
change on the larger workbook in order to reduce the size?

If you do CTRL-End on one of the sheets, does the cursor go beyond
where you think (know!) the data stops?

Excel is not very good at claiming back memory from rows or columns
whose contents have been deleted. This link to Debra Dalgleish's site
explains how you can recover this manually:

http://www.contextures.com/xlfaqApp.html#Unused

Hope this helps.

Pete

On Aug 12, 10:32*pm, Conley wrote:
We have an Excel price sheet that is over 2mb. *If we copy and paste all the
information into a new Excel book, the file size is less that 1mb. What can I
change on the larger workbook in order to reduce the size?