I have three price list spreadsheets that I want to combine into one
All of the layout column widths are the same as are the row heights
However when I try to copy and paste one price list onto the bottom o
another all of the row heights are lost and the product images that
inserted alongside each description are banked up one after the other
Paste special may be the answer but I cannot find the answer if ther
is one. There is a lot of work in resetting row heights nad movin
images so if there is a way of pasting exactly what I see on the scree
on one spreadsheet into another spreadsheet then someone please tell m
how. Oz

--
oz
-----------------------------------------------------------------------
oze's Profile: http://www.excelforum.com/member.php...fo&userid=3682
View this thread: http://www.excelforum.com/showthread.php?threadid=56534

oze wrote:
> I have three price list spreadsheets that I want to combine into one.
> All of the layout column widths are the same as are the row heights.
> However when I try to copy and paste one price list onto the bottom of
> another all of the row heights are lost and the product images that I
> inserted alongside each description are banked up one after the other.
> Paste special may be the answer but I cannot find the answer if there
> is one. There is a lot of work in resetting row heights nad moving
> images so if there is a way of pasting exactly what I see on the
> screen on one spreadsheet into another spreadsheet then someone
> please tell me how. Oze


Instead of copy & paste, try with Cut & Insert (past)...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy