| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Button, now too thin, cannot select to delete
I inserted a button on my worksheet, but didn't select the format
control/properties to not move or size it with the cells. Somehow it's become a very thin button, but I can't get it selected to delete it. It's not a big deal, but asthetically it's bothering me. How can I get it selected and/or delete it ? Thanks, Steve |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Button, now too thin, cannot select to delete
Steve wrote:
I inserted a button on my worksheet, but didn't select the format control/properties to not move or size it with the cells. Somehow it's become a very thin button, but I can't get it selected to delete it. It's not a big deal, but asthetically it's bothering me. How can I get it selected and/or delete it ? Thanks, Steve Did you try to zoom the view to 400%? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Button, now too thin, cannot select to delete
Still a line at 400%. Not that it matters, but it starts halfway in the O
column and goes through 3/4 of the S column. "Glenn" wrote: Steve wrote: I inserted a button on my worksheet, but didn't select the format control/properties to not move or size it with the cells. Somehow it's become a very thin button, but I can't get it selected to delete it. It's not a big deal, but asthetically it's bothering me. How can I get it selected and/or delete it ? Thanks, Steve Did you try to zoom the view to 400%? . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Button, now too thin, cannot select to delete
I'm surprised you can't select it. I can create a test case (put an object in
a cell, then delete that row) and I can still select it easily by hovering. Try this (Excel 2003, but look for an equivalent option if you are using 2007) open the drawing toolbar. click the "select objects" pointer icon hover over your line and see if it is selectable Alternatively, you could copy your data out to a new worksheet. HTH, Keith "Steve" wrote: Still a line at 400%. Not that it matters, but it starts halfway in the O column and goes through 3/4 of the S column. "Glenn" wrote: Steve wrote: I inserted a button on my worksheet, but didn't select the format control/properties to not move or size it with the cells. Somehow it's become a very thin button, but I can't get it selected to delete it. It's not a big deal, but asthetically it's bothering me. How can I get it selected and/or delete it ? Thanks, Steve Did you try to zoom the view to 400%? . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Button, now too thin, cannot select to delete
No, still couldn't get it selected, but I never would have thought of the new
worksheet. Thank for that. But was able to get it selected and deleted by John's suggestion below. Thanks again, Steve "ker_01" wrote: I'm surprised you can't select it. I can create a test case (put an object in a cell, then delete that row) and I can still select it easily by hovering. Try this (Excel 2003, but look for an equivalent option if you are using 2007) open the drawing toolbar. click the "select objects" pointer icon hover over your line and see if it is selectable Alternatively, you could copy your data out to a new worksheet. HTH, Keith "Steve" wrote: Still a line at 400%. Not that it matters, but it starts halfway in the O column and goes through 3/4 of the S column. "Glenn" wrote: Steve wrote: I inserted a button on my worksheet, but didn't select the format control/properties to not move or size it with the cells. Somehow it's become a very thin button, but I can't get it selected to delete it. It's not a big deal, but asthetically it's bothering me. How can I get it selected and/or delete it ? Thanks, Steve Did you try to zoom the view to 400%? . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Button, now too thin, cannot select to delete
Hi Steve
In XL2003 or older, goto EditGo to Press the "Special" button and select "Objects". This will highlight all objects on your worksheet. HTH John "Steve" wrote in message ... I inserted a button on my worksheet, but didn't select the format control/properties to not move or size it with the cells. Somehow it's become a very thin button, but I can't get it selected to delete it. It's not a big deal, but asthetically it's bothering me. How can I get it selected and/or delete it ? Thanks, Steve |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Button, now too thin, cannot select to delete
That did it.
Thank you very much. Steve "John" wrote: Hi Steve In XL2003 or older, goto EditGo to Press the "Special" button and select "Objects". This will highlight all objects on your worksheet. HTH John "Steve" wrote in message ... I inserted a button on my worksheet, but didn't select the format control/properties to not move or size it with the cells. Somehow it's become a very thin button, but I can't get it selected to delete it. It's not a big deal, but asthetically it's bothering me. How can I get it selected and/or delete it ? Thanks, Steve . |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Button, now too thin, cannot select to delete
You're welcome, anytime
John "Steve" wrote in message ... That did it. Thank you very much. Steve "John" wrote: Hi Steve In XL2003 or older, goto EditGo to Press the "Special" button and select "Objects". This will highlight all objects on your worksheet. HTH John "Steve" wrote in message ... I inserted a button on my worksheet, but didn't select the format control/properties to not move or size it with the cells. Somehow it's become a very thin button, but I can't get it selected to delete it. It's not a big deal, but asthetically it's bothering me. How can I get it selected and/or delete it ? Thanks, Steve . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find&select button,help please? | Charts and Charting in Excel | |||
| find&select button, help? | Excel Worksheet Functions | |||
| Select All button | Excel Discussion (Misc queries) | |||
| I wan to select a button | Excel Discussion (Misc queries) | |||
| How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
Hybrid Mode
