View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
curlydave curlydave is offline
external usenet poster
 
Posts: 206
Default formatted whole page, file is now huge

On Mar 13, 6:30*pm, "macropod" wrote:
Hi Ian,

If you delete the unnecessarily formatted rows and columns, then save the workbook, that should reduce its size to about what you
had before (maybe even smaller).

--
Cheers
macropod
[MVP - Microsoft Word]

"Ian Elliott" wrote in ...
Thanks for any help. I formatted the whole page (down to row 65536, and the
rightmost row) for a bunch of pages, and now the file is 55MB, when it was
about originally 6MB. I tried going back to those pages and doing a format
general, but that didn't help. Any suggestions much appreciated!
Thanks


Select the rows not being used and goto Edit Clear All, then select
all the unused Columns and goto Edit Clear All, Then re-save the
workbook.