How to Bottom Align in Excel (4 Easy Ways)

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.


Download Practice Workbook


4 Effective Methods to Bottom Align in Excel

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.

how to bottom align in excel

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.

Using Home Tab to bottom align in excel

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: Default Alignment of Numbers in Excel (Detailed Analysis)


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

Utilizing Format Cells Dialogue Box to bottom align in excel

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.

Read More: How to Change Alignment in Excel (5 Easy Methods)


Similar Readings


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.

Applying Keyboard Shortcut to bottom align in excel

  • 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.

Read More: How to Align Currency Symbol in Excel (3 Easy Ways)


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.

Using VBA Macro to Bottom Align in Excel

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 Sub

Code 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.

Writing code to bottom align in excel

  • 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

Final output of method 4 to bottom align in excel

Read More: How to Align Columns in Excel (4 Easy Methods)


Practice Section

In the Excel Workbook, we have provided a Practice Section on the right side of the worksheet. Please practice it by yourself.

Practice section to bottom align in excel


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. To learn more about Excel, you can visit our website, ExcelDemy. Happy learning!


Related Articles

Zahid

Zahid

Hello and welcome! Thank you for visiting my profile. I am currently employed as an Excel & VBA Content Creator at ExcelDemy. My most recent academic qualification is a BSc (Eng) from the Bangladesh University of Engineering and Technology. Industrial and Production Engineering was my major. I constantly attempt to think creatively and find a simple answer.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo