Locking graphics objects

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ragnar - 16 Jul 2007 10:03 GMT

When I insert lines or columns in a spreadsheet, any vector objects (graphs,
clipart, drawings) that overlap the inserted lines are enlarged. However
this does not happen with bitmap images.

Is there a way of locking my vector objects so that they remain the same
size when I insert/delete rows or columns?

TIA
R

Reply to this Message

Brian Withun - 16 Jul 2007 21:13 GMT

> When I insert lines or columns in a spreadsheet, any vector objects (graphs,
> clipart, drawings) that overlap the inserted lines are enlarged. However
[quoted text clipped - 5 lines]
> TIA
> R

Select your shape, press [CTRL]+1, or choose Format>AutoShape, or
right-click your shape and pick AutoShape...

In the dialog box, go to the Properties tab...

Choose "Don't move or size with cells"

click OK and Bob's your uncle.

Brian Herbert Withun

Reply to this Message

Ragnar - 16 Jul 2007 23:23 GMT

>> When I insert lines or columns in a spreadsheet, any vector objects
>> (graphs, clipart, drawings) that overlap the inserted lines are
[quoted text clipped - 16 lines]
>
> Brian Herbert Withun

Thanks Brian

R

Reply to this Message