Explain various options available to change the alignment of the text in the cells.

Options available to change the alignment of the text in cells are: (with explanation) 1. Text layout Vertical alignment – To specify the vertical position of the text in a shape, select an option from the list (or from the tool box). Text direction – To specify the orientation of the text in a shape, select an option from the list. 2. Autofit Resize shape to fit text – To increase the size of the shape vertically so that the text fits inside of it, click this button. 3. Internal margin The internal margin is the distance between the text and the border of a chart element. We can increase or decrease the amount of this space by using the following options. Left – To specify the distance between the left border of the selected chart element and the text, enter the margin number that we want in the Left box. Right – To specify the distance between the right border of the selected chart element and the text, enter the margin number that we want in the Right box. Top – To specify the distance between the top border of the selected chart element and the text, enter the margin number that we want in the Top box. Bottom – To specify the distance between the bottom border of the selected chart element and the text, enter the margin number that we want in the Bottom box. Columns – To specify the number of columns of text in a chart element and the spacing between the columns, click this button. $\displaystyle 21$ The commands for this • Select the range. • Click on Home tab for Alignment option which displays the dialog box and select the Alignment tab. • Select horizontal and vertical as alignment required. • There are other options to display text in angular orientation or text to be contained within cell or to spread within the cell. • Click OK.