Deleting Rows - only deletes content

[Phil]

Hello, one of our users has an excel document and would like to delete rows
(there are images contained withing some of the cells in each row). When he
right clicks on the row header and select's Delete or select's Delete >
Delete Sheet Rows in the Cells toolbar, only the content is deleted, not the
entire row. we would like to delete the row AND it's contents.

Four other users (including myself) are able to perform both functions to
achieve desired result, however when this one user delete's, it only delete's
the content.

I have an appointment with the user to fix in 2.5 hours. Any help would be
appreciated.

Thanks,
~Phil

 

[Hakyab]

Phil, either you know better than me, or what is below may help you.

To my knowledge, cells may not contain images, so image is only located on a
cell.
If this is the case, check the properties of the image. If "Move and size
with cells" option is checked,then deleting the row also deletes the image.
Otherwise, for example, "move but don't size" is checked, deleting the row
will not delete the image, only shift it.

Hope I did not waste your time.

 

[Gord Dibben]

Images do not lie within cells, only on top.

To delete images you must first select them.

F5>Special>Objects>OK>Delete

Then delete the rows..........or not, depending upon what else needs to be
cleared.


Gord Dibben MS Excel MVP