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

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?
 
O

Otto Moehrbach

Not that I know of. Excel is not a word processor. Insert a number of
blank rows before you paste. HTH Otto
 
G

Gord Dibben

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
 
Top