Microsoft Excel 2007 tutorial: format cells alignment tab


Format cells alignment tab

II. Alignment

The options that are available in this tab as the following:

- Horizontal: You can select an option in the Horizontal combo box to change the the horizontal alignment of the cell contents. In the box, you choose the options such as:

    General: This option aligns cell contents depending on its data type. Microsoft Office Excel aligns text to the left, number to the right, and logical and error values are centered. It is the default option.

    Left (Indent): Align text to the left and you can specify the indent for the text from 0 to 250.

    Center: Align text to center.

    Right (Indent): Align text to the right and you can specify the indent for the text from 0 to 250.

    Fill: Fill text that you entered in a cell to fit the width of cell. For example, you enter the word "Hello" in a cell. The width of cell is longer than the word. When you select Fill option in the Horizontal combo box, in Alignment tab of the Format Cells dialog box, Excel fills "Hello" word to fit the cell width.

Excel 2007 Fill option

    Justify: Align text to both the left and right margins.

    Center Across Section: Align text to center across other cell borders if the length of the text is longer than the cell width.

    Distributed (Indent): Distribute the words in the selected cell, but it cannot distribute across the cell border if the text is longer than the cell width.

Excel 2007 horizontal distribute

- Vertical: Select an option in the Vertical combo box to change the the vertical alignment of the cell contents. In the box, you can choose the options such as:

    Top: Align text to the top of the cell.

    Center: Align text to the center of the cell height, so it is centered between the bottom and top of the cell.

    Bottom: Align text to the bottom of the cell.

    Justify: Align text to both the top and bottom margins.

    Distributed: Distribute the words vertically in the selected cell.

Excel 2007 vertical distribute

- Indent: You can indent the cell content from any edge of the cell depending on the the options that you selected in the Horizontal and Vertical combo box. You can specify indent from 0 to 250. Each increment in the Indent box is equal to the width of one character.

- Orientation: You can change the orientation of text in the selected cell by clicking the option under Orientation.

Excel 2007 Orientation

For example, you want to rotate the phrase "Microsoft Office Excel 2007" with 45 degrees. To do this task, follow the figure below:

Excel 2007 rotate text 45 degrees

- Degree: Display the mount of text orientation in the selected cell. If you specify the positive degree in the Degree box, Excel rotates the selected text from lower left to upper right; Excel rotates the selected text from upper left to lower right if you set the negative degree in the Degree box.

- Text Control: It consists of three options:

    Wrap text: Wrap text into multiple lines in a cell. The number of the wrap lines depend on the column width and the length of the cell contents.

Excel 2007 wrap text

    Shrink to fit: Make the apparent size of the font characters smaller so that all data in the selected cell fit with the column width. If you change the column width, the character font is adjusted automatically. But, the applied font size is not changed.

Excel 2007 Shrink to fit

    Merge cells: Allows you to joint two or more cells into a singe cell. The cell reference of the merge cell is upper-left cell  in the original selected range.

Excel 2007 merge cell

- Right-to-left

You can specify reading order and alignment of text in the selected cell by selecting an option in the Text direction combo box. The default text direction is Context, but you can change it to Left-to-Right or Right-to-Left.

 


Comments

Jagan  comment

 Jagan

How to merge repeated cell in 2007Excel


2017-02-04




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.