Show All

Position data in a cell

1. Select the cells you want to reposition. To center or align data that spans several columns or rows, such as column and row labels, first merge a selected range of cells and then select the merged cell for repositioning.
2. Do one of the following:

   Center, left-align, or right-align data

   On the Formatting toolbar, click the appropriate button.

   • Click Align Left , to align text to the left.
   • Click Center , to center text.
   • Click Align Right , to align text to the right.

   Tip

   To restore the default alignment, select the cells, click Cells on the Format menu, and then click the Alignment tab. In the Horizontal box, click General.

   Increase or decrease indented text from the left edge of a cell

   On the Formatting toolbar, click Increase Indent or Decrease Indent .

   Indent text in a cell

   1. On the Format menu, click Cells, and then click the Alignment tab.

   2. Do one of the following:

      • To indent text from the left, right, or both sides of the cell, in the Horizontal box, click Left (Indent), Right (Indent), or Distributed (Indent). Then, in the Indent box, click the amount of indent you want.
      • To indent text from the top, bottom, or both top and bottom of the cell, in the Vertical box, click Top (Indent), Bottom (Indent), or Distributed. Then, in the Indent box, click the amount of indent you want.
      • To horizontally justify text that is distributed in a cell (indented from both sides), in the Horizontal box, click Justify.
      • To horizontally justify text that is not distributed in a cell, in the Horizontal box, click Distributed (Indent), and then click Justify distributed.
      • To vertically justify text in a cell, in the Vertical box, click Justify.

   Align data at the top, center, or bottom of a cell

   1. On the Format menu, click Cells, and then click the Alignment tab.
   2. In the Vertical box, click the option you want.

   Rotate text in a cell

   1. On the Format menu, click Cells, and then click the Alignment tab.
   2. In the Orientation box, click a degree point, or drag the indicator to the angle you want.

      To display text vertically from top to bottom, click the vertical Text box under Orientation.