Excel copy and paste

A

Aamir

I want to copy and paste a ten sheet worksheet arranged vertically (not
horizontally as is usually done) in continuation of an existing twelve sheet
worksheet, also arranged vertically. I am able to "select all" in the second
worksheet, but when I paste it underneath the existing work sheet, separated
by one or two row heights, the computer prompts that some area has to be
equal to some other area, or says try paste in just one cell. When I do the
latter, it again says exactly what it said before.
Do you know of an easy solution to this?
Thank you
Aamir
 
O

Otto Moehrbach

It sounds like you have some merged cells in your file. Merging cells
causes a lot of problems, as you have just experienced, and should be
avoided. The only choices you have are to remove all the cell merging in
your file, or go through the destination range and merge all the cells to
match the source range. HTH Otto
 

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

Copying Portions of Data 0
Visio shape text disappears upon copy paste 1
Copy/Paste problem in Excel 2007 1
MACRO - Copy several non contiguous cells. ~90% there... 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Macro to Copy/Paste Multiple images 3
Copy Columns based on Header name 1
How to do an IF statement that copy data based on a partial match 0

Top