| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CANNOT DELETE AUTOPHAPES ARROWS FROM WORKSHEET
I use Excel 2003 at my workplace. There are old inserted autoshape arrows
that I wish to delete. When I select the arrow I want to delete and the circles appear at the ends of each arrow, I click delete, but they are still there and the circles go away. I have tried everything I know, but I can't get rid of them. I have done it in the past with no problem on other spreadsheets. Is it possible that there is some kind of security or lock on my spreadsheet that won't let me delete them? I do not share this spreadsheet. -- Thanks, PASORIDE |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CANNOT DELETE AUTOPHAPES ARROWS FROM WORKSHEET
Just a guess...
I bet you have more of those arrows than you think. In fact, I bet you have a bunch that are in the exact same position and you're deleting the top one and the next shows up. If there are other shapes that you want to keep, don't use this: Edit|Goto|Special|Objects And then hit the delete key. If you can't use that, then you could try this: Show the Drawing toolbar Click on the "Select Objects" icon (it looks like an arrow) Use that to lasso (like the cowboy's rope) those areas in a single area. Then hit the delete key. PASORIDE wrote: I use Excel 2003 at my workplace. There are old inserted autoshape arrows that I wish to delete. When I select the arrow I want to delete and the circles appear at the ends of each arrow, I click delete, but they are still there and the circles go away. I have tried everything I know, but I can't get rid of them. I have done it in the past with no problem on other spreadsheets. Is it possible that there is some kind of security or lock on my spreadsheet that won't let me delete them? I do not share this spreadsheet. -- Thanks, PASORIDE -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CANNOT DELETE AUTOPHAPES ARROWS FROM WORKSHEET
Typo...
Use that to lasso (like the cowboy's rope) those areas in a single area. should be: Use that to lasso (like the cowboy's rope) those ARROWS in a single area. Dave Peterson wrote: Just a guess... I bet you have more of those arrows than you think. In fact, I bet you have a bunch that are in the exact same position and you're deleting the top one and the next shows up. If there are other shapes that you want to keep, don't use this: Edit|Goto|Special|Objects And then hit the delete key. If you can't use that, then you could try this: Show the Drawing toolbar Click on the "Select Objects" icon (it looks like an arrow) Use that to lasso (like the cowboy's rope) those areas in a single area. Then hit the delete key. PASORIDE wrote: I use Excel 2003 at my workplace. There are old inserted autoshape arrows that I wish to delete. When I select the arrow I want to delete and the circles appear at the ends of each arrow, I click delete, but they are still there and the circles go away. I have tried everything I know, but I can't get rid of them. I have done it in the past with no problem on other spreadsheets. Is it possible that there is some kind of security or lock on my spreadsheet that won't let me delete them? I do not share this spreadsheet. -- Thanks, PASORIDE -- Dave Peterson -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CANNOT DELETE AUTOPHAPES ARROWS FROM WORKSHEET
Dave -
I used your first suggestion and it worked perfectly. Your a genius!! -- Thanks, PASORIDE "Dave Peterson" wrote: Just a guess... I bet you have more of those arrows than you think. In fact, I bet you have a bunch that are in the exact same position and you're deleting the top one and the next shows up. If there are other shapes that you want to keep, don't use this: Edit|Goto|Special|Objects And then hit the delete key. If you can't use that, then you could try this: Show the Drawing toolbar Click on the "Select Objects" icon (it looks like an arrow) Use that to lasso (like the cowboy's rope) those areas in a single area. Then hit the delete key. PASORIDE wrote: I use Excel 2003 at my workplace. There are old inserted autoshape arrows that I wish to delete. When I select the arrow I want to delete and the circles appear at the ends of each arrow, I click delete, but they are still there and the circles go away. I have tried everything I know, but I can't get rid of them. I have done it in the past with no problem on other spreadsheets. Is it possible that there is some kind of security or lock on my spreadsheet that won't let me delete them? I do not share this spreadsheet. -- Thanks, PASORIDE -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do my arrows and shapes not print where placed in a worksheet? | Excel Discussion (Misc queries) | |||
| How to show all precedent arrows on whole worksheet at same time? | Excel Worksheet Functions | |||
| How do I set up the way arrows are used on my worksheet | Setting up and Configuration of Excel | |||
| pull down arrows for list "disappeared" in 1 worksheet but not oth | Excel Discussion (Misc queries) | |||
| Arrows move worksheet rather than cell selection, how fix? | Excel Worksheet Functions | |||
Linear Mode
