Cell Alignment Probably the first question we need to answer is what do we mean by cell alignment? With MS-Excel, cell alignment is how your text or numbers are positioned in the cell. You can align vertically, meaning towards the top, the middle or the bottom. And you can also align horizontally, meaning to the left, the center or to the right. Excel actually has its own defaults for alignment. For example, text, such as titles and labels, automatically align horizontally to the left, and numbers, however, are automatically aligned to the right. All data is vertically aligned to the bottom. These default alignments are not always the best choice for displaying your data, so MS Excel has created short-cut icons to quickly and easily change the alignment. By aligning text or numbers, you improve the appearance of your spreadsheet and often make it easier to read and understand. This lesson will review the alignment short-cut icons, which are located under the Home menu in the ribbon. You will also learn how to modify the alignment of your text and numbers to create a consistent and more organized look. Vertical Alignment Vertical means straight up and down, so vertical alignment in a cell would refer to where the data is positioned going up and down. This could be the top of the cell, the middle of the cell or across the bottom of the cell. On occasion, this type of alignment is used down a column of text identifying each row. However, this feature is primarily used when aligning titles and labels across the top of your columns. How to position a data into the cell to center in horizontal and bottom in vertical aligns? Select the Cell => Select Home tab => Select Center (in horizontal) align and select Bottom (in vertical) align. For more understanding, look at the screenshot please: Orientation Orientation allows you to rotate text in a variety of ways. Let's look at what types of orientation are available. Orientation options are in a menu in the Alignment group on the home tab of the ribbon. There are two basic kinds of orientation. One type stacks letters on top of one another. This is called Vertical text in the orientation menu. Vertical text is either on or off. In the Format Cells dialog, Vertical text is the option on the left of the orientation group. Be aware that if you set the vertical text option from the format cells dialog, Excel will switch vertical alignment to bottom alignment with an indent. You can set the indent or switch vertical alignment back to center. The other type of Orientation is rotated. Excel allows you to rotate text up to 90 degrees both clockwise and counter-clockwise. There are four fixed settings in the orientation menu for common options. The last item in the menu brings you into the Format Cells dialog box, where you can make finer grained changes. For example, you can choose an angle other than 45 degrees. To remove text orientation, just select the cells, and select the orientation option again to "toggle" orientation off. You can also visit the Format Cells dialog box and set Degrees to zero How to rotate the text to vertical in the selected cells? Select Cells that you want to rotate the text => Select Home Menu => Click Orientation Tool => Click Vertical Text. For more understanding, look at the screenshot please:
0 Comments
|
Archives |