A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to clear up useless content within worksheet?



 
 
Thread Tools Display Modes
  #1  
Old May 31st, 2010, 04:19 AM posted to microsoft.public.excel.misc
Eric
external usenet poster
 
Posts: 1,956
Default 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  
Old May 31st, 2010, 04:39 AM posted to microsoft.public.excel.misc
Max
external usenet poster
 
Posts: 8,574
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.