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

's Computer Specifications

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?

's Computer Specifications

Not that I know of. Excel is not a word processor. Insert a number of
blank rows before you paste. HTH Otto
"Wakefootin" <(E-Mail Removed)> wrote in message
news:AC256F6B-CBA9-40DD-A989-(E-Mail Removed)...
> 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?

's Computer Specifications

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

On Wed, 7 Oct 2009 18:23:22 -0400, "Otto Moehrbach"
<(E-Mail Removed)> wrote:

>Not that I know of. Excel is not a word processor. Insert a number of
>blank rows before you paste. HTH Otto
>"Wakefootin" <(E-Mail Removed)> wrote in message
>news:AC256F6B-CBA9-40DD-A989-(E-Mail Removed)...
>> 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
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MSExcel 2007 Filters do not allow Copy and Paste of data	Avril V	Microsoft Excel Misc	2	10th Jun 2009 06:04 PM
Paste data into another workbook but not overwriting original data	Me	Microsoft Excel Programming	1	13th Dec 2007 05:51 PM
How to paste rows in 2007 without overwriting data?	=?Utf-8?B?R0FNRW50IFVzZXI=?=	Microsoft Excel Misc	4	29th Sep 2007 11:06 PM
Excel cut/Paste Problem: Year changes after data is copy and paste	=?Utf-8?B?QXNpZg==?=	Microsoft Excel Misc	3	9th Dec 2005 05:16 PM
Copy & Paste Data from Web into Excel	Kelvin Pakaree	Microsoft Excel Misc	1	6th Aug 2004 02:07 PM