How to reduce table?

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!

--
Ilya Zeldes
Fort Myers, Florida

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" <ilyaz33@hotmail.com> 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!

Gord,
you must be The Genius... Thanks, it worked like a charm...
Ilya

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:e2tfd2lhkattj1fr96cfp7p8u3j7uldvh3@4ax.com...
> 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" <ilyaz33@hotmail.com> 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!
>

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" <ilyaz33@hotmail.com> wrote in message
news:%23RgnuTpuGHA.5076@TK2MSFTNGP04.phx.gbl...
> Gord,
> you must be The Genius... Thanks, it worked like a charm...
> Ilya
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:e2tfd2lhkattj1fr96cfp7p8u3j7uldvh3@4ax.com...
>> 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" <ilyaz33@hotmail.com> 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!
>>
>
>

Nice measurements - did you get a micrometer out for them ?

Puzzled, you only wanted to delete the blank rows
So why do you want to delete these *pictures* on celles with text ?

Steve

On Tue, 08 Aug 2006 04:46:23 +0100, ilyaz <ilyaz33@hotmail.com> 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" <ilyaz33@hotmail.com> wrote in message
> news:%23RgnuTpuGHA.5076@TK2MSFTNGP04.phx.gbl...
>> Gord,
>> you must be The Genius... Thanks, it worked like a charm...
>> Ilya
>>
>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> news:e2tfd2lhkattj1fr96cfp7p8u3j7uldvh3@4ax.com...
>>> 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" <ilyaz33@hotmail.com> 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)

If you want to delete pictures, go to edit--go to--special--select objects
and press delete.

"SteveW" wrote:

> Nice measurements - did you get a micrometer out for them ?
>
> Puzzled, you only wanted to delete the blank rows
> So why do you want to delete these *pictures* on celles with text ?
>
> Steve
>
> On Tue, 08 Aug 2006 04:46:23 +0100, ilyaz <ilyaz33@hotmail.com> 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" <ilyaz33@hotmail.com> wrote in message
> > news:%23RgnuTpuGHA.5076@TK2MSFTNGP04.phx.gbl...
> >> Gord,
> >> you must be The Genius... Thanks, it worked like a charm...
> >> Ilya
> >>
> >> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> >> news:e2tfd2lhkattj1fr96cfp7p8u3j7uldvh3@4ax.com...
> >>> 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" <ilyaz33@hotmail.com> 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)
>

Thanks, Dave! Worked fine.
Appreciate your help.
Ilya
"Dave F" <DaveF@discussions.microsoft.com> wrote in message
news:1C5C935C-D87D-47F1-90E8-26C5273A1993@microsoft.com...
> If you want to delete pictures, go to edit--go to--special--select objects
> and press delete.
>
> "SteveW" wrote:
>
>> Nice measurements - did you get a micrometer out for them ?
>>
>> Puzzled, you only wanted to delete the blank rows
>> So why do you want to delete these *pictures* on celles with text ?
>>
>> Steve
>>
>> On Tue, 08 Aug 2006 04:46:23 +0100, ilyaz <ilyaz33@hotmail.com> 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" <ilyaz33@hotmail.com> wrote in message
>> > news:%23RgnuTpuGHA.5076@TK2MSFTNGP04.phx.gbl...
>> >> Gord,
>> >> you must be The Genius... Thanks, it worked like a charm...
>> >> Ilya
>> >>
>> >> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> >> news:e2tfd2lhkattj1fr96cfp7p8u3j7uldvh3@4ax.com...
>> >>> 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" <ilyaz33@hotmail.com>
>> >>> 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)
>>

"SteveW" <sj_walton@nothotmail.com> wrote in message
newsp.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 <ilyaz33@hotmail.com> 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" <ilyaz33@hotmail.com> wrote in message
> news:%23RgnuTpuGHA.5076@TK2MSFTNGP04.phx.gbl...
>> Gord,
>> you must be The Genius... Thanks, it worked like a charm...
>> Ilya
>>
>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> news:e2tfd2lhkattj1fr96cfp7p8u3j7uldvh3@4ax.com...
>>> 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" <ilyaz33@hotmail.com> 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)

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 <ilyaz33@hotmail.com> wrote:

>
> "SteveW" <sj_walton@nothotmail.com> wrote in message
> newsp.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 <ilyaz33@hotmail.com> 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" <ilyaz33@hotmail.com> wrote in message
>> news:%23RgnuTpuGHA.5076@TK2MSFTNGP04.phx.gbl...
>>> Gord,
>>> you must be The Genius... Thanks, it worked like a charm...
>>> Ilya
>>>
>>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>>> news:e2tfd2lhkattj1fr96cfp7p8u3j7uldvh3@4ax.com...
>>>> 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" <ilyaz33@hotmail.com>
>>>> 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!

You are welcome, Steve.
Ilya

"SteveW" <sj_walton@nothotmail.com> wrote in message
newsp.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 <ilyaz33@hotmail.com> wrote:

>
> "SteveW" <sj_walton@nothotmail.com> wrote in message
> newsp.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 <ilyaz33@hotmail.com> 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" <ilyaz33@hotmail.com> wrote in message
>> news:%23RgnuTpuGHA.5076@TK2MSFTNGP04.phx.gbl...
>>> Gord,
>>> you must be The Genius... Thanks, it worked like a charm...
>>> Ilya
>>>
>>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>>> news:e2tfd2lhkattj1fr96cfp7p8u3j7uldvh3@4ax.com...
>>>> 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" <ilyaz33@hotmail.com>
>>>> 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!