In Excel 2003, when you paste cells, they overay the cells at the destination. The Context
(right-click) menu has an option to insert the copied cells, but it isn't the default
operation for paste. If you cut instead of copy, then the paste defaults to inserting the
cells at the destination.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"GAMEnt User" <GAMEnt wrote in message
...
In 2003 version of Excel, one could highlight and copy rows from one
worksheet to another. When pasting the rows using the insert rows command,
the number of rows required to accommodate the data would be inserted and the
existing data would move down. This was very handy for a large number of
rows. It appears this capability has been eliminated from the "advanced" 2007
version. At least, I can't find it.