How to reduce table?

[ilyaz]

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 Dibben]

Select a column that has empty cells.

F5>Special>Blanks>OK.

Edit>Delete>Entire Rows.


Gord Dibben MS Excel MVP

 

[ilyaz]

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

 

[ilyaz]

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

 

[SteveW]

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

 

[Dave F]

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

 

[ilyaz]

Thanks, Dave! Worked fine.
Appreciate your help.
Ilya

 

[ilyaz]

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

 

[SteveW]

Thanks for your feedback
I hardly ever put pics in excel and didn't know that feature

Steve

 

[ilyaz]

You are welcome, Steve.
Ilya

Thanks for your feedback
I hardly ever put pics in excel and didn't know that feature

Steve