Deleting Rows - only deletes content
 

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

Deleting Rows - only deletes content
 

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.

"Phil" wrote:

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

Deleting Rows - only deletes content
 

Images do not lie within cells, only on top.

To delete images you must first select them.

F5SpecialObjectsOKDelete

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


Gord Dibben MS Excel MVP


On Thu, 11 Mar 2010 05:58:02 -0800, Phil
wrote:

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