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

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?

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

Not that I know of. Excel is not a word processor. Insert a number of
blank rows before you paste. HTH Otto
"Wakefootin" wrote in message
...
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?

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

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-clickInsert Copied
CellsShift Cells Down.


Gord Dibben MS Excel MVP

On Wed, 7 Oct 2009 18:23:22 -0400, "Otto Moehrbach"
wrote:

Not that I know of. Excel is not a word processor. Insert a number of
blank rows before you paste. HTH Otto
"Wakefootin" wrote in message
...
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?