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.


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.


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


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


3.  The cells have now merged into one.


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


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


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


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.


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


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

  1. razorvla says:

    no way it’s faster than merging cells with the classic button, select the big cell and the row below, and drag the right bottom button to copy this down

  2. anon says:

    Step 7 is not good. Select the first block B2:D6 and select the cells B7:D7, then click the format painter, then hold on cell B8 and drag all the way down, and they’ll all get created. If you need 10,000 merges, your method still requires 10,000 clicks, while mine requires a drag for 10 seconds.

  3. Amisha says:

    Absolutely excellent answer no doubt

Leave a Reply

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