| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping objects with cells
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping objects with cells
Right-click the objectSize and properties, Properties tab. There it is
-- Kind regards, Niek Otten Microsoft MVP - Excel "martinson" wrote in message ... | 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping objects with cells
Is there a way to do the entire sheet?
-- martinson portland "Niek Otten" wrote: Right-click the objectSize and properties, Properties tab. There it is -- Kind regards, Niek Otten Microsoft MVP - Excel "martinson" wrote in message ... | 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping objects with cells
F5SpecialObjectsOK
Right-click on one of the selected objects and Format AutoshapePropertiesMove and size with cells. Gord Dibben MS Excel MVP On Thu, 15 May 2008 08:44:01 -0700, martinson wrote: Is there a way to do the entire sheet? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping objects with cells
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!! -- martinson portland "Gord Dibben" wrote: F5SpecialObjectsOK Right-click on one of the selected objects and Format AutoshapePropertiesMove and size with cells. Gord Dibben MS Excel MVP On Thu, 15 May 2008 08:44:01 -0700, martinson wrote: Is there a way to do the entire sheet? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping objects with cells
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 On Wed, 9 Jul 2008 13:30:00 -0700, martinson wrote: 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!! -- martinson portland "Gord Dibben" wrote: F5SpecialObjectsOK Right-click on one of the selected objects and Format AutoshapePropertiesMove and size with cells. Gord Dibben MS Excel MVP On Thu, 15 May 2008 08:44:01 -0700, martinson wrote: Is there a way to do the entire sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I copy all cells and all objects in a sheet together? | Excel Discussion (Misc queries) | |||
| Keeping Cells linked | Excel Discussion (Misc queries) | |||
| Keeping the format when referencing cells? | Excel Worksheet Functions | |||
| Keeping cells in place | Excel Worksheet Functions | |||
| How do I put drawing objects behind text/cells in a spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
