See all How-To Articles

How to Change Alignment in Excel & Google Sheets

In this article, you will learn how to change the alignment of numbers and text in Excel & Google Sheets.

 

alignment in excel

 

Horizontal and Vertical Alignment

In Excel, all cells are, by default, bottom aligned vertically . Horizontally, text cells are aligned left and number cells right. See this default alignment in the picture above.

If you want to center align cells horizontally, (1) select a range of cells (A1:B1). (2) In the Ribbon, go to Home > Alignment, and (3) click Center.

 

align center horizontally

 

Now cells A1:B1 are center aligned horizontally. You can also center align cells vertically. (1) Select a range of cells (A2:B2). Then (2) go to Home > Alignment and (3) click Middle Align.

 

align center vertically

 

As you can see above, cells A2:B2 are now centered vertically.

Text Orientation

Using alignment options, you can also change text orientation in a cell. You can display text vertically, rotate it up or down or display it at a certain angle. Let’s say that we want to rotate text in cell A2 counterclockwise. To do this, (1) select a cell (A2), (2) go to Home > Orientation, and (3) choose Angle Counterclockwise from the options offered.

 

align text orientation

 

As a result, the text in cell A2 is rotated counterclockwise. If you choose the last option, Format Cell Alignment, you can even define a specific degree of the angle.

Adjust Text Indent

Using the alignment options, you can also adjust the text indent in the cell. You can move the text from the cell border to the left or the right. For example, you can move the text in cell A2 a bit from the left border. To achieve this, first (1) select a cell (A2), (2) go to Home > Alignment, and (3) choose Increase Indent.

 

align text indent

 

Now, the text in cell A2 is moved a bit from the left border. If you want to get it back to the left, use the Decrease Indent icon.

Wrap Text

Another useful option in the Alignment tab is Wrap Text. This is commonly used when text content is wider than the cell. Let’s look at one example.

 

wrap text excel

 

In cell A2 the text is only partially displayed, as there is no enough space in the cell to fit the whole thing. Since there’s enough height in the cell, let’s wrap the text onto two lines. To do this, (1) select a cell with text (A2), then (2) go to Home > Alignment, and (3) click on Wrap Text.

 

excel wrap text

 

As you can see above, the text is split into two rows and fits the cell width.

Merge and Center

The last option in the Alignment tab is Merge & Center. Using this option, you can merge two or more cells into one. In this case, the content in the upper-left cell is kept and all other content lost. Let’s say we want to merge cells A2 and B2. To do this, (1) select your two cells, (2) go to Home > Alignment, and (3) click on Merge & Center.

 

merge and center

 

Now, cells A2 and B2 are merged and text from A2 is centered across both cells. As you can see above, text from cell B2 is removed.

Alignment in Google Sheets

All alignment options from Excel are also available in Google Sheets, including horizontal and vertical alignment, text wrapping and merging, and text orientation. Below, we’ll briefly describe how to achieve all of these in Google Sheets.

Horizontal and Vertical Alignment

Similarly, you can horizontally align text to the left, right, or center. To do this, (1) select a cell (A2), then (2) click on Horizontal Align and (3) click on Left.

 

google sheets alignment

 

You can also align text vertically, by (1) selecting a cell (A2), then (2) clicking on Vertical Align, and (3) clicking on Middle.

 

google sheets vertical alignment

 

Text Wrapping

In order to allow text to wrap onto a second line, (1) select a cell (A2), (2) click on Text Wrapping, and (3) choose Wrap.

 

google sheets text wrap

 

Text Orientation

If you want to change text orientation, (1) select a cell (A2), then (2) click on Text Rotation, and (3) choose Stack Vertically.

 

google sheets text orientation

 

Text Merging

In Google Sheets, you can also merge cells the same as in Excel. To achieve this, (1) select cells that you want to merge (A2:B2) and (2) click on Merge Cells.

 

google sheets merge cells

 

The rules in Google Sheets are the same as those from Excel, so when you merge multiple cells, it only retains content from the upper-left cell; all content from other merged cells is removed.