STC WDCB Winner

Categories

Our Sponsor


Enter discount code WRITER111 in the shopping
cart and save $50 at ...

Users Online

+ 9 Guests + 1 Bot

Unique Visitors

  • 618782Visitors TOTAL:
  • 116Visitors TODAY:
  • 1368Visitors Yesterday:
  • 8789Visitors Last Week:
  • February 15, 2013Since:

How to Merge MS Excel Cells but Justify the Text to the Right (or Left)


 Powered by Max Banner Ads 

© Ugur Akinci

Merging MS Excel cells and centering the contents is so easy: you just select the cells and click the Merge & Center button on the Home tab of the ribbon.

But what if you don;t want the content to center? What if you’d like to left- or right-justify the text within the merged cells?

Then you need a simple macro.

1) Press Alt + F11 to display the VBA Editor.

2) Select the Worksheet you’re working on from the VBA Project pane.

3) Right click and select New > Module to create a new module.

4) Click the new module to enable its code pane on the right:

MS Excel Merge and Left or Right Justify 1

5) In the code pane, enter this VBA code:

Sub MergeRight()
    With Selection
        .HorizontalAlignment = xlRight
        .Merge
    End With
End Sub

6) Save your workbook and switch back to your worksheet (Alt + F11).

7) Select the cell range you like.

MS Excel Merge and Left or Right Justify 2

8) On the ribbon, select Developer. Click Macros to display the list of macros recorded. Your MergeRight macro should be there:

MS Excel Merge and Left or Right Justify 3

9) Select the macro and click Run to right-merge all your content:

MS Excel Merge and Left or Right Justify 4

Similarly, to merge and left-justify your content, you can change the “xlRight” in the VBA formula to “xlLeft“.

But even simpler, just select the Merge Across option from the Merge & Center drop-down list:

MS Excel Merge and Left or Right Justify 5

 

Share

Leave a Reply

  

  

  


*

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>