Đang chuẩn bị liên kết để tải về tài liệu:
Beginning Microsoft Excel 2010 phần 4

bởi vì chúng tôi đã sao chép một số chi tiết và di chuyển để làm, một loại khác nhau và quan trọng nhất. Và trong kết nối này, chúng ta hãy đi tất cả các con đường trở lại cho rằng bảng mẫu cấp trung bình tôi đã phục vụ trong Chương | CHAPTER 4 KEEPING UP APPEARANCES FORMATTING THE WORKSHEET Figure 4-37. Centered data centered vertically that is click one of the buttons shown in Figure 4-36. What these do is position data along a vertical axis in the cell at the bottom of a cell the default when you think about it in the center as above or even at the cell s ceiling Figure 4-38 Figure 4-38. Hitting the heights. Cell data top-aligned Just bear in mind that if you apply these formats to cells of normal heights you won t see the above effects. That s because the default row height is too low to enable these to happen and so you ll need to elevate the heights of the rows you want. How do you do that The technique is in many ways the right- angled equivalent of the columnwidening methods we described in chapter 2. In order to raise a row height click on the row s lower boundary and drag down or up if you want to shrink the row s height . And if I select several row boundaries at the same time by dragging along the row numbers releasing the mouse and then dragging on any selected row boundary I ll see something like this Figure 4-39 106 CHAPTER 4 KEEPING UP APPEARANCES FORMATTING THE WORKSHEET I can then modulate the height of all the selected rows at the same and they ll all exhibit the same new height. So to achieve the row height you see in Figure 4-40 brought about in cell A10 I simply dragged down on the lower boundary by the 10 Figure 4-40 Figure 4-40. Cell A10 now heightened And once I ve engineered the desired height I then clicked the Top Align button and you get your top-of-the-cell number. Of course as always I can heighten the row first click Top Align and then enter the number. The sequence of clicks doesn t matter here. Now you ll recall my flippant aside about 48-degree text the one I threw out on the opening page of this chapter. Well if you need or want something like that look here Figure 4-41 Figure 4-41. The Orientation Button 107 CHAPTER 4 KEEPING UP APPEARANCES FORMATTING THE .