Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Left Align in Excel (3 Handy Ways)

In many cases, you might need to align cells to the left in Excel. It is very easy to choose or change alignment in Microsoft Excel. Also, you can do this kind of task in bulk within seconds in Microsoft Excel. This article demonstrates how to left align in Excel with three handy methods.


Download Practice Workbook

You can download the practice workbook from the link below.


3 Ways to Left Align in Excel

Let’s assume you have a dataset where you have the list of a number of employees with their ID and Age. In this dataset, the cells for the columns ID, Employee Name, and Age contain an alignment of center. At this point, you want to change their alignment to left. In the following stages of this article, we will see three methods to do so.

Dataset

We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience.


1. Using Standard Toolbar to Left Align in Excel

In this method, we will use the Standard Toolbar in the Home tab to align the contents of the following dataset to the left in Excel. This is a very simple and fast procedure. Now, follow the below steps to do so.

Using Standard Toolbar to Left Align in Excel

Steps:

  • At the very beginning, select range B5:D14.

Here cells B5 and D14 are the first and last cells of the columns ID and Age respectively.

  • Next, go to the Home tab.
  • After that, from the Alignment options select Align Left.

Using Standard Toolbar to Left Align in Excel

  • Eventually, you will have an output like the screenshot below where all the cells now contain a left alignment.

Using Standard Toolbar to Left Align in Excel

Read More: How to Align Text in Excel (3 Quick Methods)


Similar Readings


2. Utilizing Format Cells Dialog Box

Now, in this method, we will use the Format Cells Dialog Box to left align. This method is very convenient when you want to apply a lot of change at once. At this point, follow the below steps to align the contents to the left utilizing the Format Cell Dialog Box.

Utilizing Format Cells Dialog Box to Left Align in Excel

Steps:

  • First, select the range B5:D14.
  • Next, go to Format from the Home tab.
  • After that, select Format Cells.

Utilizing Format Cells Dialog Box to Left Align in Excel

Afterward, the Format Cells dialog box will pop up.

  • Now, go to Alignment.
  • Then from the Text Alignment Horizontal options select Left (indent).
  • Consequently, click on OK.

Utilizing Format Cells Dialog Box to Left Align in Excel

  • Finally, you will have your cells left aligned as shown in the below screenshot.

Utilizing Format Cells Dialog Box to Left Align in Excel

Read More: How to Apply Center Horizontal Alignment in Excel (3 Quick Tricks)


3. Applying Shortcut Keys to Left Align

The fastest way to left align is to use the shortcut keys. Now, to left align in Excel applying the shortcut keys, follow the below steps.

Applying Shortcut Keys

Steps:

  • In the beginning, select range B5:D14.
  • Next, press ALT > H > A > L.

Applying Shortcut Keys

  • Eventually, you will have your output as shown in the below screenshot.

Applying Shortcut Keys

Read More: How to Center Text in a Cell in Excel (3 Easy Methods)


Conclusion

In this article, I have shown you three different methods to left align in Excel. You can use any of these three methods to left align. Also, you can use these methods to change to other alignments just by adopting some little changes to these methods.
Last but not the least, I hope you found what you were looking for from this article. If you have any queries, please drop a comment below. Also, if you want to read more articles like this, you can visit our website ExcelDemy.


Related Articles

Sowmik Chowdhury

Sowmik Chowdhury

Hello! Welcome to my Profile. I , Sowmik Chowdhury, graduated from the Bangladesh University of Engineering and Technology from the Department of Naval Architecture and Marine Engineering. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this..

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo