From: Ben on 28 Mar 2010 04:41 I have a large file that somehow has pictures in it that are not visible (they seem to be sized down to 0) but are causeing the file to be too big. When I use the filter function I can select each picture or object and delete it individualy but I what to know if I can "select all" and delete? I know this is ppossible becasue I've done it once before but I have forgotten how to do it. Can some one help please. I'm using Excel 2003 Thanks
From: ozgrid.com on 28 Mar 2010 05:15 F5 > Special - Objects-OK More tips here; http://www.ozgrid.com/Excel/ExcelProblems.htm -- Regards Dave Hawley www.ozgrid.com "Ben" <Ben(a)discussions.microsoft.com> wrote in message news:D9884C52-6F71-4F63-890B-45B9DAD28601(a)microsoft.com... >I have a large file that somehow has pictures in it that are not visible > (they seem to be sized down to 0) but are causeing the file to be too big. > When I use the filter function I can select each picture or object and > delete > it individualy but I what to know if I can "select all" and delete? I know > this is ppossible becasue I've done it once before but I have forgotten > how > to do it. > > Can some one help please. I'm using Excel 2003 > > Thanks
From: Ben on 28 Mar 2010 05:45 Thank you ...too easy! "ozgrid.com" wrote: > F5 > Special - Objects-OK > > More tips here; > http://www.ozgrid.com/Excel/ExcelProblems.htm > -- > Regards > Dave Hawley > www.ozgrid.com > "Ben" <Ben(a)discussions.microsoft.com> wrote in message > news:D9884C52-6F71-4F63-890B-45B9DAD28601(a)microsoft.com... > >I have a large file that somehow has pictures in it that are not visible > > (they seem to be sized down to 0) but are causeing the file to be too big. > > When I use the filter function I can select each picture or object and > > delete > > it individualy but I what to know if I can "select all" and delete? I know > > this is ppossible becasue I've done it once before but I have forgotten > > how > > to do it. > > > > Can some one help please. I'm using Excel 2003 > > > > Thanks >
|
Pages: 1 Prev: Making Zeros look like no entry Next: Why do I get VLookup error 1004 |