Microsoft Excel 2007 tutorial: format data with alignment group


Format data with Alignment group

III. Format data with Alignment group

By using the Alignment group, you can align text to left, right, or center. These options of alignment text can be used with other alignments including top, middle, and bottom. You can also rotate the selected text to diagonal angle or vertical orientation, and increase or decrease the indent of the text.

III.1. Align text to left, right, center, top, middle, or bottom

In Microsoft Office Excel 2007, to align text to left, right, center, top, middle, or bottom, do the following:

- On the worksheet, select the text that you want to format.

- On the Home tab, in the Alignment group, select the alignment option that you want.

Excel 2007 Alignment group

Note: To see the top, middle, or bottom text alignment clearly, you need to increase the row height. To increase the row height visit this page: www.worldbestlearningcenter.com/index_files/Excel-2007-worksheet-change-row-height.htm

III.2. Text Orientation

You can rotate text in the following options:

- Angle Counterclockwise: Rotate text from lower left to upper right.

Excel 2007 rotate text in angle counterclockwise

- Angle Clockwise: Rotate text from upper left to lower right.

Excel 2007 rotate text in Angle Clockwise

- Vertical Text: Rotate text in vertical direction.

Excel 2007 rotate text vertically

- Rotate Text Up: Rotate text from bottom to top.

Excel 2007 rotate text in up direction

- Rotate Text Down: Rotate text from top to bottom.

Excel 2007 roate text down

- Format Cell Alignment: Select this option to display the Alignment tab of the Format Cells dialog box that allows you use the Orientation to set the text orientation that you want.

To rotate text, do the following:

- Select the text that you want to rotate.

- On the Home tab, in the Alignment group, click arrow next to the Orientation, and then select the orientation that you want.

Excel 2007 text orientation

Note: To rotate the selected text to normal orientation after you apply any text orientation option, click the selected text again, and then click the text orientation that you recently used.

III.3. Text Indent

What is indent? Indent is the margin between border and text in the cell. You can increase or decrease indent of text in the selected cell by doing the following:

- Select the text that you want to apply indent.

- On the Home tab, in the Alignment group, select Decrease Indent or Increase Indent.

Excel 2007 Decrease or Increase Indents

Or you can use the keyboard shortcut: Ctrl+Alt+Shift+Tab to decrease indent and Ctrl+Alt+Tab to increase indent.

 


Comments





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.