• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Part 3. Using Excel > Task 20 How to Adjust the Cell Alignment

Task 20 How to Adjust the Cell Alignment

By default, Excel automatically aligns your entries based on their data type. Text entries always line up to the left of the cells. Number entries always align to the right. Both text and numbers align vertically at the bottom of the cells, but you can change the alignment of any entry, both horizontally and vertically. With Excel's alignment commands, you can angle the text, or you can rotate it to read from top to bottom instead of from left to right. You can also center text within several adjacent cells.

  1. Quick Cell Alignment

    For quick horizontal alignment changes, use the alignment buttons on the Formatting toolbar. Select the cell or range you want to align and click the appropriate button.

  2. Center a Title Over a Range

    If you want to center text in a single row over a range of cells, select the entire range of blank cells you want to center the text within, including the cell containing the text you want centered.

  3. Click the Merge and Center Button

    Click the Merge and Center button on the Formatting toolbar. Excel centers the title over the range, and maintains the center formatting, even if the cells are widened later on.

  4. Unmerge the Text if Needed

    If you want to remove the merge and center alignment, select the merged cell and click Merge and Center on the Formatting toolbar again.

  5. Change Orientation

    If you want to change the vertical alignment or flip or rotate your entry, use Excel's Format Cells dialog box. Choose Format, Cells to open the dialog box.

  6. Select an Alignment or Orientation

    On the Alignment tab, use the Vertical alignment drop-down list to align your entry between the top and bottom cell borders. Use the Horizontal list to align the entry between the left and right borders. To rotate text, click in the right Orientation pane to select a degree of rotation, or type one in the Degrees box. To rotate text to read from top to bottom, click the left Orientation pane. Click OK.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint