Excel – Merging two cells in multiple rows

formattingmergemicrosoft excel

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.

Best Answer

  1. Merge the two cells in the first row by selecting Home > Alignment > Merge Cells command.
  2. Select the merged cell and select Home > Clipboard > Format Painter.
  3. Click and hold the first cell on the next row, and select all the range by dragging your mouse. (For example, if you merged cells A1 and B1 in the previous step, now select range A2:B99.)
  4. Excel applies the merge command individually to each row and you're done.
Related Question