Merging two spreadsheets together.

  • Thread starter Thread starter John
  • Start date Start date
J

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.
 
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
 
Back
Top