Delete rows data moving
 

When I delete a row in excel 2007 the data that is with with the rows below
does not move with it. the actual text and color formatting will move, but
the items drawn it such as text boxes and stars do not move with the row.
Worked fine in 2003, but will not in 2007. Any suggestions?

Delete rows data moving
 

Propertiesmove and size

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"njoseph" wrote in message
...
When I delete a row in excel 2007 the data that is with with the rows
below
does not move with it. the actual text and color formatting will move,
but
the items drawn it such as text boxes and stars do not move with the row.
Worked fine in 2003, but will not in 2007. Any suggestions?

Delete rows data moving
 

thank you. I am not sure where to find properties?

"Don Guillett" wrote:

Propertiesmove and size

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"njoseph" wrote in message
...
When I delete a row in excel 2007 the data that is with with the rows
below
does not move with it. the actual text and color formatting will move,
but
the items drawn it such as text boxes and stars do not move with the row.
Worked fine in 2003, but will not in 2007. Any suggestions?

.

Delete rows data moving
 

Right-click on one of your objects and Format objectProperties tab.


Gord Dibben MS Excel MVP

On Tue, 1 Jun 2010 13:51:02 -0700, njoseph
wrote:

thank you. I am not sure where to find properties?

"Don Guillett" wrote:

Propertiesmove and size

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"njoseph" wrote in message
...
When I delete a row in excel 2007 the data that is with with the rows
below
does not move with it. the actual text and color formatting will move,
but
the items drawn it such as text boxes and stars do not move with the row.
Worked fine in 2003, but will not in 2007. Any suggestions?

.