Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?


.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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?


.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
moving duplicate data in rows to columns with same name Jennifer B. Excel Discussion (Misc queries) 2 June 25th 08 03:47 PM
Increase rows by 1 when moving data from col. to col. Gayle Excel Discussion (Misc queries) 3 May 30th 08 09:16 PM
Moving data from multiple rows to single rows Pete Excel Worksheet Functions 5 February 16th 08 01:51 PM
Moving data from multiple rows into a single row GfW Excel Discussion (Misc queries) 3 September 28th 07 06:13 AM
Moving data in rows to columnar lmcmillan Excel Discussion (Misc queries) 2 April 13th 07 08:54 PM


All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"