View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Merging two spreadsheets together.

In source worksheet select a range to copy.

SHIFT + EditCopy as Picture.

Paste that below the data on destination worksheet.

You will have to change the background pattern of the cells behind the
picture to "White" to get rid of gridlines.


Gord Dibben MS Excel MVP


On Wed, 23 Jul 2008 09:36:14 -0700, John
wrote:

Is there any way to merge two spreadsheets together while maintaining the
dissimilar column widths they each possess? In other words, I don’t want the
column with of one spreadsheet to change when I paste it under the other
spreadsheet. This new resulting spreadsheet will be to print only. Thank
you.