• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy pasting formatting issues

F

Flexorion

New Member
I need to copy paste information from a spreadsheet into a template. The problem is that, for content reasons, the template has merged cells, and when I go to copy paste the information into the template, rather than pasting each cell from the information into one of the merged cells, it keeps the formatting from the information spreadsheet and breaks up the merged cells. I've tried the special merges, but none of them work. Is there a way to paste it into the way the rows are currently formatted?
 
Yes, I tried all the preset pastes. When i try to paste values, say I'm trying to paste six rows of information into six rows of merges cells (12 actual rows), it keeps the merged cell format, but it pastes in the 1st, 3rd, and 5th rows twice instead of pasting in all six.
 
I just tried linking formulas between the two spreadsheets and then copy-pasting the formula into the other cells and letting excel automatically change the references, but it did the same thing again!
 
Flexori


Using merged cells is never a good idea, instead if you want a title or something similar spanning several cells then put your data into one cell, make a selection of ALL the cells you want the data the occupy then press ctrl + 1, when the format dialogue box opens choose the Alignment tab and in the Horizontal window choose “Center Across Selection”. Now you will not have the restrictions that you get with merge, if you do not have to many merged cells in the original worksheet unmerge them all and do as described. It takes longer to read this that actually do it.
 
It still has the formatting issue. The reason why the cells are merged is because in the second half of the spreadsheet is a checkmark section that has to be individually highlighted by participating stores and they need to be able to highlight each section of the box, and this is how they've done it in previous years, so it can't be changed from that.
 
I think I actually may have to make a custom template to paste the information into that can then use reference formulas to draw directly into the merged cells.
 
Flexorion


Merged cells really are a lot of trouble and to be honest I never use the merge function and if I inherit a file that has merged cells the first thing I do is as I posted earlier.

When this is done there is no difference to the original layout and users can not tell what has been done.
 
What you posted doesn't solve the problem because I need those two rows occupied by a single item, and even with merging them, it still does not pull them in the right order because there are two rows there. If I could show you the template you would understand, but our office computers don't let me use the file posters you guys use on this website.
 
Flexorion


Then select two rows and then do ctrl + 1...Center Across Selection....not merge
 
You must log in or register to reply here.
Back
Top