Prev: Showing a cell reference in a popup
Next: Final attempt save as binary question
From: Eric on 30 May 2010 23:19
When I copy and paste the whole worksheet for editing, and delete some
useless content, but I find out the file size of worksheet is almost the
same, I am delete half of useless content already, so the file size should be
reduced, does anyone have any suggestions on how to clear up hidden useless
content to reduce the file size?
Thanks in advance for any suggestions
Eric
From: Max on 30 May 2010 23:39
One better? way is NOT to copy/paste the entire sheet but only the target
areas.
To clean-up, think you'd need to select all cols to the right of your target
area*, then DELETE these. Then do similar action for all rows below your
target area. Then save the file to complete the clean-up.

*select the entire col (the 1st "empty" col), then press CTRL+SHIFT+Right
arrow, right-click > Delete
For rows, do similar action:
select the entire row (the 1st "empty" row), then press CTRL+SHIFT+Down
arrow, right-click > Delete
--
Max
Singapore
---
"Eric" wrote:
> When I copy and paste the whole worksheet for editing, and delete some
> useless content, but I find out the file size of worksheet is almost the
> same, I am delete half of useless content already, so the file size should be
> reduced, does anyone have any suggestions on how to clear up hidden useless
> content to reduce the file size?
> Thanks in advance for any suggestions
> Eric
 | 
Pages: 1
Prev: Showing a cell reference in a popup
Next: Final attempt save as binary question