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

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?
 
O

Otto Moehrbach

Not that I know of. Excel is not a word processor. Insert a number of
blank rows before you paste. HTH Otto
 
G

Gord Dibben

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

copy outlined data in excel 1
How to paste rows in 2007 without overwriting data? 4
Excel copy/paste questions 10
Copy-Paste Chart into Word from Excel 2007 3
Copy & paste 2
Stop Overwriting (Fill, Copy, etc) Data Validation 3
COPY EXCEL 2007 9
Is Paste Special HTML broken in Excel/Office 2007? 1

Top