I don’t think merged cells get much love, nor do I think they deserve any. I much prefer to use centre across selection, but for some reason way back when, MS decided to put that at the bottom of the alignment drop down to ensure people pick the gross spreadsheet breaking Merge mess instead of the simple centre across selection. Oh well..
Anyway I just had a wb with external links that shouldn’t have. Find didn’t find any, no names, charts or objects – all the usual suspects for hard to remove names.
In this case Cells X10:AI10 were merged showing the year once across all 12 cells.
If I unmerge those 12 cells I get the year in X10 and the other 11 cells are links to cells in an external wb.
If I try and remerge them it deletes the links and leaves only the year.
How can you have a merged cell range that has multiple values/formulas?
Anyone else seen that? Anyone know how to do it?
This was an old spredasheet, so its not a 2007 issues
I wondered if it might have been some broken array formula? Any other ideas?