How to Left Align in Excel (3 Handy Ways)

Get FREE Advanced Excel Exercises with Solutions!

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 align left in Excel with three handy methods.


How to Left Align in Excel: 3 Easy Ways

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 the left. In the following stages of this article, we will see three methods to do so.

Dataset

We have used the Microsoft Excel 365 version here, you can use any other version 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


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


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 apply the shortcut keys, and 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


Download Practice Workbook

You can download the practice workbook from the link below.


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 least, I hope you found what you were looking for in this article. If you have any queries, please drop a comment below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo