Keeping objects with cells

M

martinson

In Excel 2003, it was a setting for all workseets that objects would move
with cells. I can't find that in Excel 2007.
 
N

Niek Otten

Right-click the object>Size and properties, Properties tab. There it is

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| In Excel 2003, it was a setting for all workseets that objects would move
| with cells. I can't find that in Excel 2007.
| --
| martinson portland
 
G

Gord Dibben

F5>Special>Objects>OK

Right-click on one of the selected objects and Format Autoshape>Properties>Move
and size with cells.


Gord Dibben MS Excel MVP
 
M

martinson

I've done that. Whe I delete rows above, the objects stay where they are,
they don't move with the cells. It's making me crazy!!
 
G

Gord Dibben

Cannot replicate your problem in 2003 version so not sure what to tell you now.

Maybe wait for someone else to read this and lend a hand.


Gord
 
Top