View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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?