Merging two spreadsheets together.

[John]

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.

 

[Gord Dibben]

In source worksheet select a range to copy.

SHIFT + Edit>Copy 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

 

[John]

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

 

[Gord Dibben]

Good to hear.

Gord

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