If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|