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

How to Align Text in Excel (3 Quick Methods)

Sometimes we need to align text in the cells of Excel worksheets. Excel has some quick features and functions for this. In this article, we’ll see them with some simple examples and explanations.


Download Practice Workbook

Download the practice workbook from here.


3 Quick Methods to Align Text in Excel

Here, I’ve used an Excel workbook with multiple worksheets which contain the same dataset. The dataset contains the Names of the students and their Marks.

How to align text in Excel


1. Use of Ribbon to Align Text in Excel

We can align text easily in Excel by using Ribbon. Some examples of using Ribbon to align text in Excel are given below.

1.1 Vertical Alignment

Top Align

Suppose, we have a dataset (B4:B8) of some names of the students. We need to align them to the top.

Steps:

  • Firstly, select the dataset (B4:B8).
  • Next, go to the Home tab.
  • After that, Select Top Align from the Alignment options.

Use of Ribbon to Align Text in Excel

  • Now, we can see that top alignment is applied to columns (B4:B8).

Use of Ribbon to Align Text in Excel


Middle Align

Here, we have a dataset (B4:B8) of some students’ names. Now We need to align them in the middle.

Steps:

  • In the first place, select the dataset (B4:B8).
  • Then, go to the Home tab.
  • Finally, select Middle Align from the Alignment options.

Use of Ribbon to Align Text in Excel

  • Now, we can see that middle alignment is applied to columns (B4:B8).

Use of Ribbon to Align Text in Excel


Bottom Align

The method for bottom alignment is the same as the top and middle alignment. The steps are shown in the pictures below:

First, select B4:B8 > Home tab > Bottom Align

Use of Ribbon to Align Text in Excel

Finally, We can get the result below:

Use of Ribbon to Align Text in Excel


1.2 Horizontal Alignment

Align Left

Suppose, we have a dataset (B4:B8).  It contains some names of the students. We need to align the texts to the left.

Steps:

  • In the beginning, select the dataset (B4:B8).
  • Secondly, go to the Home tab.
  • Lastly, select Left Align from the Alignment options.

Use of Ribbon to Align Text in Excel

  • Finally, we will see the result below.

Use of Ribbon to Align Text in Excel

Read More: How to Left Align in Excel (3 Handy Ways)


Center

The steps for center alignment are shown in the pictures below:

Select B4:B8 > Home tab > Center

Use of Ribbon to Align Text in Excel

In the end, we can see the final result below.

Use of Ribbon to Align Text in Excel

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


Align Right

Here, the pictures below show the steps for the right alignment:

At first, select B4:B8 > Home tab > Align Right

Finally, we will see the below result.

Use of Ribbon to Align Text in Excel


1.3 Rotate Text

Sometimes we need to rotate text in Excel. We can easily rotate text by using Alignment Options that are available in Excel.

Suppose we need to rotate the text up of B4 and C4 cells.

Steps:

  • Firstly, select cells B4 and C4.
  • Secondly, go to the Home tab.
  • After that, click on the Orientation option in the Alignment section.

Use of Ribbon to Align Text in Excel

  • Next, click on Rotate Text Up.

Use of Ribbon to Align Text in Excel

  • Lastly, We can see that texts in cells B4 and C4 are rotated successfully.

Use of Ribbon to Align Text in Excel


1.4 Indent Text

Increase Indent

In Excel the Tab key of the keyboard does not indent text in a cell; it simply moves the pointer to the next cell. For example, we need to increase the indentation of the text in the dataset (B4:B8). By following the steps given below, we can increase the indentation of text in a cell easily.

Steps:

  • In the first place, select the dataset (B4:B8). 
  • Next, Go to the Home tab.
  • Now, click on the Increase Indent option in the Alignment section.

Use of Ribbon to Align Text in Excel

  • Lastly, the increased indentation is shown in the dataset (B4:B8).

Use of Ribbon to Align Text in Excel


Decrease Indent

The process of decreasing the indentation of the text in a cell is almost the same as increasing the indentation. The steps to decrease indent are shown in the pictures below:

First, select B4:B8 > Home > Decrease Indent

Use of Ribbon to Align Text in Excel

Finally, we get the final result same as the picture below.

Use of Ribbon to Align Text in Excel


1.5 Wrap Text

When the data input in a cell is too large to fit, one of two things happens:

  • A long text string extends over the cell border into the columns to the right if they are empty.
  • If the adjacent cell contains data, a text string is terminated at the cell border.

In our example, the second option is applicable. The Excel Wrap Text option helps to display longer text in a cell without overflowing other cells. The term “wrapping text” refers to displaying the contents of a cell on multiple lines rather than one long line.

Suppose, we need to wrap the text of the dataset (B4:B8). According to the steps given below, we can wrap the texts quickly:

Steps:

  • At first, select the dataset (B4:B8).

  • Next, go Home.
  • After that, click on the Wrap Text option in the Alignment.

  • Lastly, We can see the wrapped text of the dataset (B4:B8).


2. Align Text in Excel with Format Cells Dialog

Another way to align text in Excel is to use the Alignment option of the Format Cells dialog box. For example, we can see that the dataset (B4:B8) of the picture below overflows the cells. We can fit the texts in a single line within one cell by using the Shrink to fit option.

Steps:

  • In the beginning, select the dataset (B4:B8).

  • Next, go to the Home tab and click on the Alignment Settings option according to the picture below.

  • Now, a Format Cells dialog box will appear where the Alignment option will be selected by default.
  • After that, click on the box beside Shrink to fit.
  • Now, A tick mark symbol will appear.
  • Then, click on OK.

  • Finally, The dataset is shrunk to fit in a cell successfully.


3. Apply Shortcut Keys for Text Alignment in Excel

The following keyboard shortcuts can help us to change the alignment of text easily in Excel:

  • Top alignment: Alt + H, A + T
  • Middle alignment: Alt + H, A + M
  • Bottom alignment: Alt + H, A + B
  • Left alignment: Alt + H, A + L
  • Center alignment: Alt + H, A + C
  • Right alignment: Alt + H, A + R

Here, Alt + H activates the Home tab. In the next combination, the first letter is always A which denotes Alignment and the other one stands for direction. For instance, A + C denotes Center alignment.

Assuming we need to change the alignment of the dataset (B4:B8) to the top. We can change this alignment very easily by using the keyboard shortcut.

Steps:

  • First, select the dataset (B4:B8). We can see that the dataset is Middle aligned.

  • Next, press Alt + H on the keyboard.
  • After that, The Home tab will open and Excel will display all Alignment shortcuts.
  • Then, Press A + T for Top alignment.

  • Finally, The data set will be aligned to the top.

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


Conclusion

I hope, these three methods will be helpful for you to align text in Excel. Download the practice workbook and give it a try. Let us know your feedback in the comment section. Follow our website ExcelDemy to get more articles like this.


Related Articles

Sagufta Tarannum

Sagufta Tarannum

Hi, I am Sagufta. I have completed my graduation in Civil Engineering from Bangladesh University of Engineering and Technology. I am very much interested about research and innovation in the field of Civil Engineering.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo