Cannot delete object

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet in which several thick black/blue lines have somehow
appeared in one of the rows, and no matter what I do, I am unable to delete
them.

When I click on Hide All Objects in the Tools, Options menu, it hides that
problem row as well as my charts.

Can anyone help?

Thanks
 
Maybe they're objects (like charts/buttons/textboxes) that have been collapsed
because you deleted rows.

If you show the Drawing toolbar, you can click on the arrow icon and "lasso" one
of the objects. Then you can either resize it (to see what it was) or delete
it.

Remember to hit that arrow icon to toggle back to normal edit mode.
 
Sometimes when using Drawing Objects and deleting rows or columns, the rows
or columns go away, but the Drawing Object just reduces to a fine line,
similar to a cell border.......if you mouse-over it and the cursor changes
shape, then just at that point right-click > cut.......sometimes this may
take several tries to make it all go away.........

hth
Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
"cannot shift objects off sheet" error 8
Cannot shift objects off sheet? 2
'Cannot insert object' message when I try to put a button on a worksheet 7
Enabling option „Format rows“ to hide/unhide rows using VBA-code? 0
Run-time error 1004 while conditionally hiding rows as a result ofworksheet protection 2
hide, unhide column or row after protect worksheet 4
I cannot delete the extra rows or columns in Excel 2007 2

Back
Top