All language subtitles for 4. Text Rotation and Other Formatting Techniques

In this video you will learn some more formatting techniques.

Let us add a column for entering notes select cell G3 and type notes

in alignment group.

Click the orientation tool orientation refers to rotation of text in this in you can use the standard

orientation tools to rotate the text diagonally or vertically.

You can also control the text orientation to a specific angle.

You use this option usually to create a row or column header to differentiate from other text let us

select angle counterclockwise from the list.

Excel aligns the text counterclockwise.

You can apply both.

All is on file and vertical alignment to the contents of us in the horizontal alignment decides how

the text is aligned horizontally while the vertical alignment decides whether the text is aligned to

the top middle or bottom of the cell.

Let us align the headings in the middle of the row select cells A3 to G3 in alignment grow click the

middle aligned to excel aligned the contents of the cells in the middle of the row forces in Dunwoody

type n make up the motion for men's clothing notice that the text does not fit into the cell.

In such case you either increase the sale of it to accommodate that text or use the wrap text tool in

the alignment group click the that text tool that text tool increases the cell height and wraps the

contents of a cell into multiple lines to display the entire content in this an Excel has several built

in styles you apply to your data.

The states are listed in the states group select the cell you want to apply this style.

Click the styles gallery point the cursor over a style to preview it before applying once you have found

a style you want to apply.

Click it and excel applies it to the selected set text indentation refers to the margin or distance

between the cell border and the text in your cell.

You can increase or decrease the indentation by using the increase indent or decrease indent to let

us fill a pattern in the cell B 17.

To highlight the total sales volume click the number for dialog box launcher select the field Bab click

the button style dropdown list select the light gray pattern Excel fills the pattern in thus in let

us increase the row height for sales data for all the months.

Select the rows and then back the boundary below.

One of the selected row headings Excel changes the Rawhide for all the selected rows

let us decrease the weight of all columns to do so.

First click the.

Select all button drag the boundary of one column to decrease the column it Excel decreases the column

of it for all the columns.