How copy none excel data & paste in 2007 without overwriting data

  • Thread starter Thread starter Wakefootin
  • Start date Start date
W

Wakefootin

When I copy a table from a website and paste in Excel 2007 it does not move
the rows down and over writes the data. Is there a way to get it to add the
needed row, some setting I can change?
 
Not that I know of. Excel is not a word processor. Insert a number of
blank rows before you paste. HTH Otto
 
To OP

Roundabout but paste the table to an unused portion of the sheet.

Then copy that and select where to paste to and right-click>Insert Copied
Cells>Shift Cells Down.


Gord Dibben MS Excel MVP
 
Back
Top