insert and paste in one step
 

Is it possible to copy a row and then both insert a row and paste the copied
row in one step. The client wants to copy rows from various sites and place
them between rows that already exist. He does not want to move the row, he
wants to copy it. Currently he is inserting a blank row, copying the
existing row and then pasting it into the new blank row. I am wondering if
there is a faster way. Kathy in Cincinnati

Kathy

InsertCopied Cells.

Can be done from right-click menu or from Insert Menu.

Gord Dibben Excel MVP

On Wed, 1 Dec 2004 13:11:03 -0800, "KathyinCincinnati"
wrote:

Is it possible to copy a row and then both insert a row and paste the copied
row in one step. The client wants to copy rows from various sites and place
them between rows that already exist. He does not want to move the row, he
wants to copy it. Currently he is inserting a blank row, copying the
existing row and then pasting it into the new blank row. I am wondering if
there is a faster way. Kathy in Cincinnati