insert and paste in one step

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Insert>Copied Cells.

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

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Excel Unable to insert cut rows into Excel online anymore? 0
VBA - retrieve data on last create named range from previous inserted named range 0
Excel Match two columns/rows within multiple sheets then paste answer... 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Inserting a Copied Row inside a table 6
Keeping formulas on an insert 1

Back
Top