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

  • Thread starter Thread starter Wakefootin
  • Start date Start date
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?
 
Not that I know of. Excel is not a word processor. Insert a number of
blank rows before you paste. HTH Otto
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to paste rows in 2007 without overwriting data? 4
copy outlined data in excel 1
Is Paste Special HTML broken in Excel/Office 2007? 1
Excel 2007 2
Copy-Paste Chart into Word from Excel 2007 3
Copy & paste 2
Copying Excel 2007 data to external programs 3
Question about copying long rows of data 2

Back
Top