You are currently viewing Types of Alignment in MS Excel

Types of Alignment in MS Excel

Excel offers you a variety of ways to align columns and rows. Learn about the different types of alignment in MS Excel.

What is Alignment in MS Excel

Text alignment refers to the position where your text aligns horizontally left, right, or center, and vertically top, middle, or bottom. This is a very useful feature in Excel because you can adjust the alignment of your text according to your needs. This is very helpful when working with large datasets.

How Many Types of Alignment in Microsoft Excel

There are 6 types of alignment available in MS Excel

HorizontallyUsers align text left, right and center side
LeftContent in cell align left side
RightContent in cell align right side
CenterContent in cell align center side

VerticallyUsers align text top, middle and bottom side
TopContent in cell align top side
MiddleContent in cell align middle side
BottomContent in cell align bottom side

Alignment Text Using Shortcut Keys

In Microsoft Excel you can create complex spreadsheets in a short amount of time, which is why shortcuts are important to do your job efficiently. You can save time and easily change the alignment by using shortcuts.

Shortcuts Keys are very helpful in Microsoft Excel because they help you to align text and make your work easier.

it’s very easy and simple to change text alignment in MS Excel using shortcuts keys.

Shortcut Keys

Top Alignment: Alt+H after A+T

Middle Alignment: Alt+H after A+M

Bottom Alignment: Alt+H after A+B

Left Alignment: Alt+H after A+L

Read Also  Is Excel Easy to Learn?

Center Alignment: Alt+H after A+C

Right Alignment: Alt+H after A+R

There are many users who find it difficult to remember these shortcut keys; don’t worry, I’ll explain them in a very simple way for you to remember.

First, you need to remember Alt+H then A, because these keys same in every alignment, and then remember the first alignment letter, which means T for top, M for middle, and the other remaining first letter of alignments.

Alt+H then A+T, A+M or A+B.

How to Align Text in Microsoft Excel

If you write text in alphabets then text starts from left bottom.

If you write numeric then text starts from right bottom in excel.

Text Align Left

  1. Open Microsoft Excel
  2. To align text left, select the cell you want to align
  3. As shown in the picture, click the left alignment icon to align your text to the left.


Text Align Right

  1. Open MS Excel.
  2. Select the cell where you want to align the text right
  3. You can align your text to the right by clicking the right alignment icon as shown in the image below


Align Text Top

  1. Open Excel
  2. Choose the cell
  3. Using the top alignment icon, you can align your text to the top as shown in the below image.


Bottom Align

  1. Open Excel
  2. Select the cell
  3. Click alignment icon as you see in picture and your text align to bottom.

Align Text Center

  1. Open your Microsoft Excel
  2. Select cell which you wish to align center
  3. Click center align icon as you see in the below image and your text will align to center.


Align Text Middle

  1. Open MS Excel
  2. Select the cell which you wish to align center
  3. Click Middle align icon as you see in image and your text align to middle side.


Is Excel to Learn?