Merge Multiple Cells at Once (Vertically / Horizontally) with Format Painter (Excel 2013)

Merging multiple cells across rows and columns is a fairly straightforward task. Simply choose the number of cells that you wish to merge, then click the Merge Cells button. Easy peasy, no? What if, you want to merge a defined set of cells in a repeated manner vertically (i.e. across several rows) and / or horizontally (i.e. across several columns)?

Here’s the scenario. You have determined that you want to merge the cells from B2 to D6 (that’s 15 cells in total) and then repeat this same set of merging pattern vertically for 10 times.

merge_cells_vertically1
 

Instead of repeating the same steps of selecting a group of 15 cells (across the rows / columns) and click the Merge Cells button, you can achieve the same result with Format Painter in fewer steps! Here’s how:

1.  Select the cells from B2 to D6.

merge_cells_vertically2

2.  On the Home tab, in the Alignment group, click the Merge & Center button.

merge_cells_vertically3
 

Alternatively, you can open the submenu by clicking the mini arrow next to the Merge & Center button, and click the Merge Cells button.

merge_cells_vertically4
 

3.  The cells have now merged into one.

merge_cells_vertically5
 

4.  On the Home tab, in the Clipboard group, double-click the Format Painter button.

merge_cells_vertically6
 

5.  The pointer changes to a paintbrush icon and the merged cell will now have a dashed box around it.

merge_cells_vertically7
 

6.  Click cell B8 once. The cells from B8 to D12 are instantly merged as one.

merge_cells_vertically8
 

7.  Note that the pointer still appears as a paintbrush. Go on and click once vertically (on a new unmerged cell) for the remaining eight times.

merge_cells_vertically9
 

That’s it! Isn’t that a lot quicker with Format Painter? Happy trying!

 

2 Responses to Merge Multiple Cells at Once (Vertically / Horizontally) with Format Painter (Excel 2013)

  1. Amisha says:

    Absolutely excellent answer no doubt

Leave a Reply

Your email address will not be published. Required fields are marked *