30 Advanced Excel Tips for 2026

Excel Champs / Excel Basics / Alignment in Excel (Change it + Other Options)
By Puneet Gogia (Microsoft MVP)

Alignment in Excel (Change it + Other Options)

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

Select the cells and use the buttons in Home → Alignment: Align Left, Center and Align Right for horizontal position, and Top Align, Middle Align and Bottom Align for vertical. From the keyboard, press Alt → H → A followed by L, C or R (horizontal) or T, M or B (vertical).

For more choices, press Ctrl + 1 and open the Alignment tab. Center Across Selection centres a heading over several columns without merging them, and Fill, Justify and Distributed spread text across the cell. The same tab handles indent, wrap text, shrink to fit and text angle.

By default, numbers sit on the right and text on the left. A number sitting on the left with default alignment is usually stored as text and won’t calculate, so check for that before you set an alignment that hides the clue.

Word’s alignment shortcuts do something else in Excel: Ctrl + E runs Flash Fill, Ctrl + L creates a table and Ctrl + R fills right.

In Excel, alignment helps you to align the text and values in the worksheet cells. By default, numbers align to the bottom right and text aligns to the bottom left of the cell. In this tutorial, we will learn to adjust the text alignment in two ways: horizontally and vertically.

Change Alignment using the Ribbon

Here’s how to change the alignment of the text in Excel from the ribbon:

  • First, select the range of cells that you want to realign.
  • Next, go to the Home tab and use the options in the Alignment group.
alignment-options

Vertical Alignment

You can use the following options to align the data vertically.

  1. Top Align- It allows you to align the text as well as the number to the top of the cell.
  2. Middle Align- Aligns the data to the middle of the cell (between the top and the bottom).
  3. Bottom Align- This is the default option, and it puts the contents at the bottom of the cell.
vertical-alignment-options

Horizontal Alignment

To align the data horizontally, use the below options:

  1. Left Alignment- Aligns the text to the left edge of the cell.
  2. Center- It puts the text and number in the middle.
  3. Right Alignment- Aligns the contents to the right side of the cell.
horizontal-alignment-options

Other Options

  1. Text Orientation (Rotate Text): It allows you to change the orientation of the text vertically or diagonally.
  2. Wrap Text: This option helps you to wrap long text into multiple lines in a cell.
  3. Indent: There are two indent buttons in the Alignment group. When you click on the Increase Indent icon, it moves your text further to the right. However, to get the text back to the left, click on the Decrease Indent icon.
  4. Merge & Center: It is used to combine the selected cells into a single cell. Only the value of the top-left cell is kept.
wrap-text-indent-text-orientation-and-merge-options

Change Text Alignment from Format Cells Options

Another way to change the text alignment is through the Format Cells dialog box. Below are the steps for this.

  • Again, you need to select the cell that you want to re-align.
  • Next, open the Format Cells dialog box from the arrow in the bottom-right corner of the Alignment group (or press Ctrl + 1).
click-on-the-bottom-right-arrow
  • After that, select the Alignment tab in the Format Cells dialog box. Here, you have the Horizontal and Vertical drop-downs for aligning the text.
format-cells-dialog-box-text-alignment
  • Now, select the horizontal and vertical text alignment from the drop-down options and click the OK button to apply it to the selected cells.

For example, we select “Distributed” in both horizontal and vertical text alignment. The below snapshot shows the text spread evenly across the height and width of the cell, with more space between the words to fill the cell.

text-alignment-distributed

Apart from Distributed, the Horizontal drop-down has a few more options that aren’t on the ribbon:

  • Fill: repeats the content of the cell until it fills the cell width.
  • Justify: wraps the text and spreads each line across the full width of the cell.
  • Center Across Selection: centers the text across the selected cells without merging them, so you can still sort and select those cells normally.
  • Shrink to fit (checkbox): makes the font smaller so the text fits in the column width.

Changing Text Direction

At the bottom of the Format Cells dialog box, there is an option to change the direction of the text. The default setting is Context, but you can change it to left-to-right or right-to-left.

  • The default direction of the text is from left to right.
  • And the right-to-left option is used in the case of some specific languages like Arabic.
changing-text-direction

Changing Text Orientation

The text orientation option is also available in the Format Cells dialog box.

text-orientation-option

It is used to change the orientation by rotating the text clockwise, counter-clockwise, up, and down. Enter a number from -90 to 90 degrees in the box, or use the orientation pointer to change the direction of the text, and click OK to apply it to the selected cells.

rotate-text-45-degrees

Keyboard Shortcuts for Alignment

You can also use the ribbon key tips to align the text without the mouse. Press the keys one after the other, not together:

  • Align Left: Alt ➜ H ➜ A ➜ L
  • Center: Alt ➜ H ➜ A ➜ C
  • Align Right: Alt ➜ H ➜ A ➜ R
  • Top Align: Alt ➜ H ➜ A ➜ T
  • Middle Align: Alt ➜ H ➜ A ➜ M
  • Bottom Align: Alt ➜ H ➜ A ➜ B
  • Format Cells dialog box: Ctrl + 1

Frequently Asked Questions

Why are my numbers aligned to the left?

When numbers are stored as text, Excel aligns them to the left by default. You usually see a small green triangle in the cell. Convert them to numbers (with the warning icon ➜ Convert to Number) and they move to the right.

How do I center text without merging cells?

Select the cells, press Ctrl + 1, and in the Alignment tab, choose Center Across Selection in the Horizontal drop-down. The text looks merged, but each cell stays separate.

How do I reset the alignment to the default?

Select the cells, open Format Cells (Ctrl + 1), and set Horizontal to General and Vertical to Bottom. Or use Home ➜ Clear ➜ Clear Formats, which removes all the formatting, not just the alignment.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel