I have 2 excel sheets - one is 20 columns wide the 2nd is 7 columns wide.
The 20 column sheet has a general information section at the top that I would
like to add to the 7 coulmn spreadsheet. However, when I copy and paste it
"spreads out" or goes way beyond the width due to the number of columns. I
have tried paste special object and entering the excel sheet that way and it
doesn't fit properly and too many cells are shown. Any other way to do this?

If you only want it up there for appearance purposes, you can try:

Copy the selection.
Click the cell where you want to paste it.
Hold down shift, the click EDIT and paste picture.
Then you can resize the picture.

Or.....
Perhaps you have a problem with merged cells in your copy area. Try unmerging


"djpatwork" wrote:

I have 2 excel sheets - one is 20 columns wide the 2nd is 7 columns wide.
The 20 column sheet has a general information section at the top that I would
like to add to the 7 coulmn spreadsheet. However, when I copy and paste it
"spreads out" or goes way beyond the width due to the number of columns. I
have tried paste special object and entering the excel sheet that way and it
doesn't fit properly and too many cells are shown. Any other way to do this?