| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit shape with snap to grid on only allows movement down and righ
To reproduce this problem:
Switch on Align-Snap to Grid. Draw a rectangle in the middle of the sheet. Edit Shape-Convert to freeform Edit Shape-Edit Points Try dragging the top left point around - you can move it to the right and below its original position but not above or to the left of it. Adding an additional point completely throws it. The additional point snaps to a mysterious grid all of its own! Anyone have a workaround / fix for this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Edit shape with snap to grid on only allows movement down and righ
Hi,
What program are you using? None of my versions of Excel have a command called Edit Shape. Also, my versions have a command Draw, Change AutoShape but they won't let me convert a rectangle to a freeform? -- Thanks, Shane Devenshire "reb197" wrote: To reproduce this problem: Switch on Align-Snap to Grid. Draw a rectangle in the middle of the sheet. Edit Shape-Convert to freeform Edit Shape-Edit Points Try dragging the top left point around - you can move it to the right and below its original position but not above or to the left of it. Adding an additional point completely throws it. The additional point snaps to a mysterious grid all of its own! Anyone have a workaround / fix for this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Edit shape with snap to grid on only allows movement down and
Hi,
I'm using Excel 2007. The shape functions are under the Insert menu. Thanks "ShaneDevenshire" wrote: Hi, What program are you using? None of my versions of Excel have a command called Edit Shape. Also, my versions have a command Draw, Change AutoShape but they won't let me convert a rectangle to a freeform? -- Thanks, Shane Devenshire "reb197" wrote: To reproduce this problem: Switch on Align-Snap to Grid. Draw a rectangle in the middle of the sheet. Edit Shape-Convert to freeform Edit Shape-Edit Points Try dragging the top left point around - you can move it to the right and below its original position but not above or to the left of it. Adding an additional point completely throws it. The additional point snaps to a mysterious grid all of its own! Anyone have a workaround / fix for this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Edit shape with snap to grid on only allows movement down andrigh
Hi,
Looks like this might be a bug. I thought a possible work around would be to turn of the Snap to grid and use the ALT key to align to cell border. Whilst this allows you to drag the point in any direction when you press ALT the point jumps straight back to it's starting position. Cheers Andy reb197 wrote: To reproduce this problem: Switch on Align-Snap to Grid. Draw a rectangle in the middle of the sheet. Edit Shape-Convert to freeform Edit Shape-Edit Points Try dragging the top left point around - you can move it to the right and below its original position but not above or to the left of it. Adding an additional point completely throws it. The additional point snaps to a mysterious grid all of its own! Anyone have a workaround / fix for this? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Edit shape with snap to grid on only allows movement down and
Hi,
Actually its under Drawing Tools, Format, Insert Shapes group, Edit Shape. Well you learn something new everyday! I haven't been doing much with shapes in 2007 so I missed this obscurity. This is apparently a bug. -- Thanks, Shane Devenshire "reb197" wrote: Hi, I'm using Excel 2007. The shape functions are under the Insert menu. Thanks "ShaneDevenshire" wrote: Hi, What program are you using? None of my versions of Excel have a command called Edit Shape. Also, my versions have a command Draw, Change AutoShape but they won't let me convert a rectangle to a freeform? -- Thanks, Shane Devenshire "reb197" wrote: To reproduce this problem: Switch on Align-Snap to Grid. Draw a rectangle in the middle of the sheet. Edit Shape-Convert to freeform Edit Shape-Edit Points Try dragging the top left point around - you can move it to the right and below its original position but not above or to the left of it. Adding an additional point completely throws it. The additional point snaps to a mysterious grid all of its own! Anyone have a workaround / fix for this? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Edit shape with snap to grid on only allows movement down and
Hi,
I didn't know about the alt key so thanks - that's a useful tip - but shame the bug persists to that too. Cheers Rob. "Andy Pope" wrote: Hi, Looks like this might be a bug. I thought a possible work around would be to turn of the Snap to grid and use the ALT key to align to cell border. Whilst this allows you to drag the point in any direction when you press ALT the point jumps straight back to it's starting position. Cheers Andy reb197 wrote: To reproduce this problem: Switch on Align-Snap to Grid. Draw a rectangle in the middle of the sheet. Edit Shape-Convert to freeform Edit Shape-Edit Points Try dragging the top left point around - you can move it to the right and below its original position but not above or to the left of it. Adding an additional point completely throws it. The additional point snaps to a mysterious grid all of its own! Anyone have a workaround / fix for this? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tab - motve one cell to righ | New Users to Excel | |||
| Excel 2007 - "Snap To Grid" doesn't work on same grid line | Excel Discussion (Misc queries) | |||
| Excel Snap to Grid Feature | Excel Discussion (Misc queries) | |||
| my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
| How do I create and/or edit a bell shape graph? | Charts and Charting in Excel | |||
Linear Mode
