You can see here that the values in the cells C4 through C15 run very close to the values in B4 through B15. Another change you can make is to indent the contents of a cell. So I will click the middle align button, and I can see that the headers are separated from the text a little bit, more effectively and it's easier to read. For many headers, I stay with bottom, but in this case I want to see what it would look like if I were to align the text to the middle of the cell. So, we have bottom align, middle align, and top align. Also note that the text appears at the bottom of cells B3 through D3, and you can see those boxes here. I prefer to align my headings to the center, so with B3 through D3 selected, I will click the center text button, and it's been applied. In this case I've selected B3 through D3, and then on the Home tab of the ribbon, you can see the alignment tools here, and you have the left align, or line left, center text, and align right. First, you need to select the cells that contain the values you want to align. If you want to change the alignment of the values in your cell, then you can do that in a couple of ways. Also note that the contents of column B, starting with B4 and going down to B15, the numbers are right aligned. If there were something in G2, then all the text after the comma in cell F2 would be hidden.
In cell F2, you can see that the contents of cell F2 have continued on past the edge of that cell, but because there's nothing in cell G2, Excel renders that text. Left align text, as you can see here in column C, starting with C3 and going down through C15, starts at the left edge of the cell and continues as far to the right as necessary. You have three basic alignments for a cell, and those are left, right, and center. What I want to do is change the alignment of the contents of some of these sales, to make the data a little more attractive. This workbook summarizes monthly revenue data, and you can see that it is for battery sales. I'll demonstrate how to perform these tasks, my sample file for this movie is the alignment workbook, and you can find it in the Chapter six folder of the exercise files collection. If you want, you can reposition your data within the cell by changing it's alignment. Part of that format includes the cell's alignment, which means that the data can start at the left edge of the cell, start at the right edge, or be centered within the cell. (Narrator) When you enter a value into your worksheet, Excel determines what type of value it is, and assigns that cell a format.
0 kommentar(er)
