Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Shape, will not move accordingly, when deleting columns
Example:
If I have text typed in and have a format Shape, say a circle, over the text in column "C". And I delete column "B" the text will move according to the deleted column but the Shape will not move with it. If I insert a column in front of column "C" that has the text and shape, both text & shape will move together. Why will the Shape not move with the text when deleting columns but inserting columns it will? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Shape, will not move accordingly, when deleting columns
Right click the shapepropertiesplay with it
-- Don Guillett Microsoft MVP Excel SalesAid Software "TJ" wrote in message ... Example: If I have text typed in and have a format Shape, say a circle, over the text in column "C". And I delete column "B" the text will move according to the deleted column but the Shape will not move with it. If I insert a column in front of column "C" that has the text and shape, both text & shape will move together. Why will the Shape not move with the text when deleting columns but inserting columns it will? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Shape, will not move accordingly, when deleting columns
Also Need to Mention: I'm running "2007" excell
Did not have this issue with "2003" "Don Guillett" wrote: Right click the shapepropertiesplay with it -- Don Guillett Microsoft MVP Excel SalesAid Software "TJ" wrote in message ... Example: If I have text typed in and have a format Shape, say a circle, over the text in column "C". And I delete column "B" the text will move according to the deleted column but the Shape will not move with it. If I insert a column in front of column "C" that has the text and shape, both text & shape will move together. Why will the Shape not move with the text when deleting columns but inserting columns it will? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move entire row to another sheet and deleting the old row only. | Excel Worksheet Functions | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
can I use conditional format on an auto shape | Excel Discussion (Misc queries) | |||
conditinal format that gives particular shape and color in cell | Excel Discussion (Misc queries) | |||
Can I format columns to move across a spreadsheet? | Excel Discussion (Misc queries) |