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.
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.
- 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.
- Eventually, you will have an output like the screenshot below where all the cells now contain a left alignment.
Read More: How to Align Text in Excel (3 Quick Methods)
- How to Align Colon in Excel (4 Easy Methods)
- Align Shapes in Excel (5 Simple Methods)
- Change Alignment to the Right in Excel (5 Quick Methods)
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.
- First, select the range B5:D14.
- Next, go to Format from the Home tab.
- After that, select Format Cells.
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.
- Finally, you will have your cells left aligned as shown in the below screenshot.
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.
- In the beginning, select range B5:D14.
- Next, press ALT > H > A > L.
- Eventually, you will have your output as shown in the below screenshot.
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.