If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to clear up useless content within worksheet?
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 |
#2
|
|||
|
|||
How to clear up useless content within worksheet?
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 |
Thread Tools | |
Display Modes | |
|
|