Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MSExcel 2007 Filters do not allow Copy and Paste of data | Excel Discussion (Misc queries) | |||
Stop Overwriting (Fill, Copy, etc) Data Validation | Excel Discussion (Misc queries) | |||
How to paste rows in 2007 without overwriting data? | Excel Discussion (Misc queries) | |||
filted data, copy and paste a col. puts data in wrong row how fix | New Users to Excel | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) |