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.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
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.
Read More: How to Apply Center Horizontal Alignment in Excel (3 Quick Tricks)
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.
Read More: How to Align Columns in Excel (4 Easy Methods)
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.
Related Articles
- How to Align Numbers in Excel (7 Simple Methods)
- Align Decimal Points in Excel (3 Quick Ways)
- How to Bottom Align in Excel (4 Easy Ways)
- Align Currency Symbol in Excel (3 Easy Ways)
- How to Maintain Excel Header Alignment (with Easy Steps)
- Default Alignment of Numbers in Excel (Detailed Analysis)
- How to Center Text in a Cell in Excel (3 Easy Methods)