Merging two spreadsheets together.
 

Is there any way to merge two spreadsheets together while maintaining the
dissimilar column widths they each possess? In other words, I dont 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.

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.

Merging two spreadsheets together.
 

Thanks for the excellent response, Gord. Your advice worked perfectly! John.

"Gord Dibben" wrote:

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 dont 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.

Merging two spreadsheets together.
 

Good to hear.

Gord

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

Thanks for the excellent response, Gord. Your advice worked perfectly! John.

"Gord Dibben" wrote:

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.