you have just change cell formatting again and again. clear all formatting.and then apply on only used cell.
Divaker On Wed, Sep 7, 2011 at 10:59 AM, bé trần văn <betnmtdongna...@gmail.com>wrote: > > > 2011/9/7 Amit Desai (MERU) <amit.de...@merucabs.com> > >> What could be the reason for increase in excel file? I have a file with >> size of 4.5 MB, but data contents are not that much.**** >> >> ** ** >> >> You can do the following: >> - First you file your virus scanner. >> - Then select all the rows and columns and delete it. >> - Finally, you copy the data of each sheet and paste Special, then select >> Value and click OK. >> >> ** ** >> >> ** ** >> >> ------------------------------ >> Disclaimer: This message and its attachments contain confidential >> information and may also contain legally privileged information. This >> message is intended solely for the named addressee. If you are not the >> addressee indicated in this message (or authorized to receive for >> addressee), you may not copy or deliver any part of this message or its >> attachments to anyone or use any part of this message or its attachments. >> Rather, you should permanently delete this message and its attachments (and >> all copies) from your system and kindly notify the sender by reply e-mail. >> Any content of this message and its attachments that does not relate to the >> official business of Meru Cab Company Pvt. Ltd. must be taken not to have >> been sent or endorsed by any of them. Email communications are not private >> and no warranty is made that e-mail communications are timely, secure or >> free from computer virus or other defect. >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
