Delete rows data moving
in [General]
|
Prev: How do I align numbers in different cells when some are in bracke.
Next: Countifs anchoring formula when sorting
From: njoseph on 17 May 2010 09:21 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?
From: Don Guillett on 17 May 2010 09:36 Properties>move and size -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "njoseph" <njoseph(a)discussions.microsoft.com> wrote in message news:DF305D5C-47BF-480E-BC2A-DD7BC71B95AD(a)microsoft.com... > 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?
From: njoseph on 1 Jun 2010 16:51 thank you. I am not sure where to find properties? "Don Guillett" wrote: > Properties>move and size > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett(a)gmail.com > "njoseph" <njoseph(a)discussions.microsoft.com> wrote in message > news:DF305D5C-47BF-480E-BC2A-DD7BC71B95AD(a)microsoft.com... > > 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? > > . >
From: Gord Dibben on 1 Jun 2010 18:07
Right-click on one of your objects and Format object>Properties tab. Gord Dibben MS Excel MVP On Tue, 1 Jun 2010 13:51:02 -0700, njoseph <njoseph(a)discussions.microsoft.com> wrote: >thank you. I am not sure where to find properties? > >"Don Guillett" wrote: > >> Properties>move and size >> >> -- >> Don Guillett >> Microsoft MVP Excel >> SalesAid Software >> dguillett(a)gmail.com >> "njoseph" <njoseph(a)discussions.microsoft.com> wrote in message >> news:DF305D5C-47BF-480E-BC2A-DD7BC71B95AD(a)microsoft.com... >> > 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? >> >> . >> |