| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
"SteveW" <(E-Mail Removed)> wrote in message news  p.tdyj7yikevjsnp@enigma03...Nice measurements - did you get a micrometer out for them ? You don't need microscope either. In Excel, just highlight the picture, click Format>Picture and then Size Tab. It'll tell you the exact size of the pic. So much even I knew... Puzzled, you only wanted to delete the blank rows So why do you want to delete these *pictures* on celles with text ? My first concern was to reduce the size of the table. Now, I'd like to improve it appearance... Ilya On Tue, 08 Aug 2006 04:46:23 +0100, ilyaz <(E-Mail Removed)> wrote: > Well, but I'm not out of the woods, yet... > I one column, along with the text in the cells there are small pictures > in > the corner of each cell. Each picture consist of an orange triangle and > four > circles around it. The size of this group is 0.07" x 0.16". I don't need > this "picture". Neither Del or Clear option delete them. I removed > several > of them individually by moving them out of the cell and then Ctrl+Del > (just > Del would not delete). > Again, how to "mass delete" these pics, but keep the text? > Hope there is solution... > Ilya > > "ilyaz" <(E-Mail Removed)> wrote in message > news:%(E-Mail Removed)... >> Gord, >> you must be The Genius... Thanks, it worked like a charm... >> Ilya >> >> "Gord Dibben" <gorddibbATshawDOTca> wrote in message >> news:(E-Mail Removed)... >>> Select a column that has empty cells. >>> >>> F5>Special>Blanks>OK. >>> >>> Edit>Delete>Entire Rows. >>> >>> >>> Gord Dibben MS Excel MVP >>> >>> On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" <(E-Mail Removed)> wrote: >>> >>>> I have a table with over 5000 rows. However, only about 2500 rows >>>> contain >>>> info, the rest are empty rows (one row with info, next empty, etc). I >>>> deleted a few rows by clicking on them and holding Ctrl key. But is >>>> there >>>> a >>>> way to delete several hundreds of empty rows at once? If there is, may >>>> someone please tell me how to do it! >>> >> >> > > -- Steve (3) |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Thanks for your feedback
I hardly ever put pics in excel and didn't know that feature Steve On Tue, 08 Aug 2006 20:36:52 +0100, ilyaz <(E-Mail Removed)> wrote: > > "SteveW" <(E-Mail Removed)> wrote in message > news p.tdyj7yikevjsnp@enigma03...> Nice measurements - did you get a micrometer out for them ? > You don't need microscope either. In Excel, just highlight the > picture, > click Format>Picture and then Size Tab. It'll tell you the exact size of > the > pic. So much even I knew... > > Puzzled, you only wanted to delete the blank rows > So why do you want to delete these *pictures* on celles with text ? > My first concern was to reduce the size of the table. Now, I'd like > to > improve it appearance... > Ilya > > On Tue, 08 Aug 2006 04:46:23 +0100, ilyaz <(E-Mail Removed)> wrote: > >> Well, but I'm not out of the woods, yet... >> I one column, along with the text in the cells there are small pictures >> in >> the corner of each cell. Each picture consist of an orange triangle and >> four >> circles around it. The size of this group is 0.07" x 0.16". I don't need >> this "picture". Neither Del or Clear option delete them. I removed >> several >> of them individually by moving them out of the cell and then Ctrl+Del >> (just >> Del would not delete). >> Again, how to "mass delete" these pics, but keep the text? >> Hope there is solution... >> Ilya >> >> "ilyaz" <(E-Mail Removed)> wrote in message >> news:%(E-Mail Removed)... >>> Gord, >>> you must be The Genius... Thanks, it worked like a charm... >>> Ilya >>> >>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message >>> news:(E-Mail Removed)... >>>> Select a column that has empty cells. >>>> >>>> F5>Special>Blanks>OK. >>>> >>>> Edit>Delete>Entire Rows. >>>> >>>> >>>> Gord Dibben MS Excel MVP >>>> >>>> On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" <(E-Mail Removed)> >>>> wrote: >>>> >>>>> I have a table with over 5000 rows. However, only about 2500 rows >>>>> contain >>>>> info, the rest are empty rows (one row with info, next empty, etc).. I >>>>> deleted a few rows by clicking on them and holding Ctrl key. But is >>>>> there >>>>> a >>>>> way to delete several hundreds of empty rows at once? If there is, >>>>> may >>>>> someone please tell me how to do it! |
|
|
|
|
|||
|
Guest
Posts: n/a
|
You are welcome, Steve.
Ilya "SteveW" <(E-Mail Removed)> wrote in message news p.tdzeyscvevjsnp@enigma03...Thanks for your feedback I hardly ever put pics in excel and didn't know that feature Steve On Tue, 08 Aug 2006 20:36:52 +0100, ilyaz <(E-Mail Removed)> wrote: > > "SteveW" <(E-Mail Removed)> wrote in message > news p.tdyj7yikevjsnp@enigma03...> Nice measurements - did you get a micrometer out for them ? > You don't need microscope either. In Excel, just highlight the > picture, > click Format>Picture and then Size Tab. It'll tell you the exact size of > the > pic. So much even I knew... > > Puzzled, you only wanted to delete the blank rows > So why do you want to delete these *pictures* on celles with text ? > My first concern was to reduce the size of the table. Now, I'd like > to > improve it appearance... > Ilya > > On Tue, 08 Aug 2006 04:46:23 +0100, ilyaz <(E-Mail Removed)> wrote: > >> Well, but I'm not out of the woods, yet... >> I one column, along with the text in the cells there are small pictures >> in >> the corner of each cell. Each picture consist of an orange triangle and >> four >> circles around it. The size of this group is 0.07" x 0.16". I don't need >> this "picture". Neither Del or Clear option delete them. I removed >> several >> of them individually by moving them out of the cell and then Ctrl+Del >> (just >> Del would not delete). >> Again, how to "mass delete" these pics, but keep the text? >> Hope there is solution... >> Ilya >> >> "ilyaz" <(E-Mail Removed)> wrote in message >> news:%(E-Mail Removed)... >>> Gord, >>> you must be The Genius... Thanks, it worked like a charm... >>> Ilya >>> >>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message >>> news:(E-Mail Removed)... >>>> Select a column that has empty cells. >>>> >>>> F5>Special>Blanks>OK. >>>> >>>> Edit>Delete>Entire Rows. >>>> >>>> >>>> Gord Dibben MS Excel MVP >>>> >>>> On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" <(E-Mail Removed)> >>>> wrote: >>>> >>>>> I have a table with over 5000 rows. However, only about 2500 rows >>>>> contain >>>>> info, the rest are empty rows (one row with info, next empty, etc). I >>>>> deleted a few rows by clicking on them and holding Ctrl key. But is >>>>> there >>>>> a >>>>> way to delete several hundreds of empty rows at once? If there is, >>>>> may >>>>> someone please tell me how to do it! |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to reduce byte size of pivot table ? | Prem | Microsoft Excel Misc | 0 | 19th Mar 2008 07:58 AM |
| Splitting table to reduce size | RipperT | Microsoft Access Database Table Design | 5 | 13th Oct 2006 07:31 PM |
| reduce size of pivot table file | =?Utf-8?B?emFwYWRpYXM=?= | Microsoft Excel Misc | 0 | 19th May 2006 10:57 AM |
| Reduce the table size | Ray | Microsoft Access | 2 | 12th Jul 2005 06:40 PM |
| Access Table Delete does not reduce the *.mdb file size | HELP on Access | Microsoft Access | 3 | 11th Feb 2004 09:17 PM |
