Alignment Group

Text alignment

By default, any text entered into your worksheet will be aligned to the bottom-left of a cell. Any numbers will be aligned to the bottom-right of a cell. Changing the alignment of your cell content allows you to choose how the content is displayed in any cell, which can make your cell content easier to read.

 

To change horizontal text alignment:

1. Select the Cell(s) you wish to modify
2. Select one of the three horizontal alignment commands on the Home tab. In our example, we’ll choose Center Align.
3. The text will realign.

To change vertical text alignment:

1. Select the cell(s) you wish to modify.
2. Select one of the three vertical alignment commands on the Home tab. In our example, we’ll choose Middle Align.
3. The text will realign.

 

Align Text Diagonally

If you wish to align the document diagonally, you must follow the below given instructions to do so.
1. On the sheet, select the text of row(s)/column(s) that is to be aligned diagonally.
2. Upon selection, in the Alignment section of the ribbon, click the Orientation button.
3. From the drop-down that appears, you can select either Rotate Text UP or Rotate Text Down.

4. In order to specify a particular inclination angle manually, select Format Cell Alignment.
5. On the Format Cells window, under the Alignment tab, in the Orientation
section, enter 45 degrees in the Degrees input box.

6. Hit OK to save the changes.

Once you do so, the selected text will get aligned diagonally. Do not forget to MERGE & CENTER the rows because the diagonal text will surely require some additional space to accommodate itself.

 

Indenting cell data

Follow these steps to indent data in cells:
1. Select the cells containing text you want to indent.
2. On the Home tab, in the Alignment group, click the Increase Indent button.
3. Each time you click the Increase Indent button, Excel adds a small amount of space between the cell border and the data itself.

 

Removing cell indentation

If you want to remove the indentation applied to cell data, follow these steps:
1. Select the cells containing the indented text.
2. On the Home tab, in the Alignment group, click the Decrease Indent button.
3. Each time you click the Decrease Indent button, Excel removes a small amount of space between the cell border and the data itself.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment