How to Middle Align in Excel (2 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel aligns text to the bottom left and numerals to the bottom right of cells by default. You may easily change the default alignment by utilizing the ribbon, keyboard shortcuts, the Format Cells dialog, or by creating your own unique number format. This article will show you how to middle align in Excel.

Table of Contents hide

Download Practice Workbook

2 Handy Approaches to Middle Align in Excel

1. Utilizing Alignment Group to Middle Align

2. Applying VBA Code to Middle Align in Excel

Conclusion

Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.

Middle Align.xlsm

2 Handy Approaches to Middle Align in Excel

In this article, we will apply two methods that are very convenient to middle align in Excel. We will utilize the Alignment group and apply the VBA code to middle alignment in Excel. Let’s suppose we have a sample data set.

1. Utilizing Alignment Group to Middle Align

Alignment is the third group in the Home tab ribbon, following the Clipboard and the Font groups. There are more than ten buttons, including the drop-down menu buttons. Most importantly, Alignment group buttons can be used to position, rotate, and align the content within a cell. The alignment of the texts is set, in particular, via the Top Align, Middle Align, and Bottom Align buttons. Additionally, in addition to the buttons for Align Left, Center, and Align Right. Orientation, Increase Indent, and Decrease Indent are also options. Here, we will use the middle align icon which will center the contents between the top and bottom of the cell.

Step 1:

Here, select the data set, and then you will see that the data set does not show the middle alignment.
Therefore, we want to do the middle alignment.

Step 2:

Here, select the data set that you want to do the middle alignment.
Firstly, go to the Home tab.
Then, click on the Middle Align from the Alignment group.

Step 3:

Finally, you will observe that all texts and numbers in the cell are centered between the top and the bottom of the cell.

2. Applying VBA Code to Middle Align in Excel

VBA is a programming language that may be used for various tasks, and different types of users can use it for those tasks. You can launch the VBA editor using the Alt + F11 keyboard shortcut. In the last section, we will generate a VBA code that makes it easy to middle align in Excel.

Step 1:

Firstly, we will open the Developer tab.
Then, we will select the Visual Basic command.
Here, you will see all contents in the cell do not show the middle alignment.

Step 2:

Here, the Visual Basic window will open.
After that, from the Insert option, we will choose the new Module to write a VBA code.

Step 3:

Then, paste the following VBA code into the Module.
To run the program, click the “Run” button or press F5.

Sub Middle_Alignment()
'Specifying the range for middle alignment
Range("B4:C11").VerticalAlignment = xlCenter
End Sub

Step 4:

Lastly, the given image displays all the texts and numbers in the selected range showing the middle alignment.

Conclusion

In this article, I’ve covered 2 handy methods to middle align in Excel. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.