13
3
I have an excel spreadsheet with two cells in each row that I'd like to merge. Highlighting all the cells of interest and just merging from the cell formatter seems to just merge all the cells together, when instead I just want one merged cell per row. Any ideas how to do this?
I should note that one of the columns contains values (all are either true/false) and the other column is just a null cell.
Unfortunately, not working, as it destroys the content of the second cell... Am I missing something? – Kobus Myburgh – 2015-06-22T16:05:09.777
I was going to suggest selecting the cells to be merged row by row and then doing the merge. When selecting that way, Excel will merge the cells row by row. Mehper's answer is much better, though. (Much less fiddling around and much less prone to mistakes when selecting.) – RobH – 2015-06-22T16:37:01.130
@Kubus Merging only keeps the value of the leftmost/topmost cell that is being merged. In fact, in Excel 2010 (and later, I presume), if you try to merge multiple cells that contain data, a warning will appear that will tell you just that. – RobH – 2015-06-22T16:40:32.640
This is certainally the better method of the two. +1 – Joe Taylor – 2010-11-10T14:35:03.820