How to reduce table?

  • Thread starter Thread starter ilyaz
  • Start date Start date
I

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!
 
Select a column that has empty cells.

F5>Special>Blanks>OK.

Edit>Delete>Entire Rows.


Gord Dibben MS Excel MVP
 
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
 
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
 
If you want to delete pictures, go to edit--go to--special--select objects
and press delete.
 
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
 
Thanks for your feedback
I hardly ever put pics in excel and didn't know that feature

Steve
 
You are welcome, Steve.
Ilya

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

Steve
 
Back
Top