While working in Excel, we often need to bottom-align the cells. By aligning the cells at the bottom, we can give a distinctive look to a specific data type. For instance, we can use the bottom align option only for the numbers. So, we will be able to identify the data type just by looking at its alignment. In Excel, there are several simple and efficient ways to bottom-align cells. Here, we will learn 4 of them. Now, let’s begin with the article and explore these 4 methods.
How to Bottom Align in Excel: 4 Effective Methods
In this section of the article, we will learn 4 effective methods to bottom align in Excel. Let’s say we have the Monthly Sales of XYZ Company as our dataset. In the dataset, we have sales amounts for 7 sales persons. Our goal is to bottom-align the cells of the dataset.
Not to mention that we have used the Microsoft Excel 365 version for this article, you can use any other version according to your convenience.
1. Using Home Tab
Using the Home tab is one of the easiest ways to bottom align in Excel. Let’s follow the steps mentioned below to do this.
Steps:
- Firstly, select the cells you want to bottom align.
- After that, go to the Home tab from Ribbon.
- Then choose the Bottom Align option from the Alignment group.
That’s it! It is done. Now, you will see that the cells of your dataset are bottom aligned as shown in the following image.
Read More: How to Align Numbers in Excel
2. Utilizing Format Cells Dialogue Box
Utilizing the Format Cells dialogue box is another smart way to bottom align cells in Excel. To accomplish this, let’s follow the instructions outlined below.
Steps:
- Firstly, select your dataset.
- Then go to the Home tab from Ribbon.
- After that, click on the Alignment Settings option as marked in the image below
As a result, the Format Cells dialogue box will open on your worksheet.
- Now, from the Format Cells dialogue box, click on the drop-down icon in the Vertical field.
- Then, choose the Bottom option from the drop-down.
- Following that, click on OK.
Congratulations! You have successfully bottom-aligned cells in Excel. Now, your outputs should look like the following picture.
3. Applying Keyboard Shortcut
We can also use a keyboard shortcut to bottom align in Excel. To achieve this, let’s follow the steps outlined below.
Steps:
- Firstly, select your dataset and press the keyboard shortcut CTRL + SHIFT + F.
Consequently, the Format Cells dialogue box will be visible on your worksheet.
- After that, in the Format Cells dialogue box, go to the Alignment tab.
- Then, click on the drop-down button beside the Vertical field.
- Now, choose the Bottom option from the drop-down.
- Finally, click on OK.
Subsequently, your selected cells will be bottom aligned as shown in the image below.
4. Using VBA Macro to Bottom Align
Using the VBA Macro feature is another effective way to bottom align in Excel. Let’s perform the steps discussed in the following section to do this.
Steps:
- Firstly, go to the Developer tab from Ribbon.
- After that, click on the Visual Basic option from the Code group.
Subsequently, the Microsoft Visual Basic window will open on your worksheet.
- Now, go to the Insert tab in the Microsoft Visual Basic window.
- Then, choose the Module option from the drop-down.
As a result, a blank Module will be available to you as shown in the image below.
- After that, write the following code in the blank Module.
Sub bottom_alignment()
Range("b4:g11").VerticalAlignment = xlBottom
End SubCode Breakdown
- Firstly, we initiated a Sub Procedure named bottom_alignment.
- After that, we assigned the bottom alignment for the range B4:G11 of the worksheet.
- Finally, we ended the Sub Procedure.
- After writing the code, click on the Save option.
- After that, press the keyboard shortcut ALT + F11 and you will be redirected to the worksheet.
- Now, go to the Developer tab from Ribbon.
- Then, click on the Macros option from the Code group.
- Next, in the Macro dialogue box, choose the bottom_alignment option in the Macro name field.
- Subsequently, click on Run.
As a result, the cells of the range B4:G11 will be bottom-aligned as demonstrated in the following picture
Practice Section
In the Excel Workbook, we have provided a Practice Section on the right side of the worksheet. Please practice it by yourself.
Download Practice Workbook
Conclusion
That’s all about today’s session. I strongly believe that this article was able to guide you to bottom align in Excel. Please feel free to leave a comment if you have any queries or recommendations for improving the article’s quality. Thank you for reading this article!
