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
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.
Instead of copy & paste, try with Cut & Insert (past)...
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
Re: Copy & Paste lost row heights
Methinks that this is not as big a mystery as it first seems.
In my experience, Excel assumes that unless you copy/paste the whole row, then the row height should not also be copied as that action may adversely affect other cells which are not being copied at the same time.
So, if you want the row heights to copy, you just need to select and copy the whole row/s and it happens without fuss.
Last edited by Charlie.001; 12-13-2011 at 11:57 PM. Reason: typos and understanding
Hello @Charlie.001 and welcome to the forum,
Since this thread is a little over 5 years old with no new posts, I think we can all agree that the OP is no longer waiting (at least I hope not) for a solution. Its usually best to concentrate on active threads since we can't even get feedback on whether or not the solution has resolved the reported problem.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks