Merge Combines multiple cells into one cell Title across the top of a worksheet; Merge & Center centers contents in the merged cell TABLE 2–1 Positioning data within a cell Aligning Text You can align the contents of a cell horizontally and vertically within the cell. Horizontal alignments are left, centered, or right. Vertical alignments are top, middle, or bottom, as shown in Figure 2–3. Excel left-aligns all text and right-aligns all numbers. All data is bottom-aligned. You can select a different horizontal and vertical alignment for any cell. FIGURE 2–3 Horizontal and vertical alignments To change the alignment of a cell, select the cell and then click an alignment button in the Alignment group on the Home tab of the Ribbon. For other alignment options, click the Format Cells: Alignment Dialog Box Launcher to display the Alignment tab in the Format Cells dialog box. In the Text alignment section, click the alignment you want in the Horizontal or Vertical boxes, and then click OK. Merging and Centering Data You can also center cell contents across several columns. Select the cells, and then click the Merge & Center button in the Alignment group on the Home tab of the Ribbon. The selected cells merge , or combine into one cell, and the contents from the upper-left cell are centered in the newly merged cell.
Merge Combines multiple cells into one cell Title across the top of a worksheet; Merge & Center centers contents in the merged cell TABLE 2–1 Positioning data within a cell Aligning Text You can align the contents of a cell horizontally and vertically within the cell. Horizontal alignments are left, centered, or right. Vertical alignments are top, middle, or bottom, as shown in Figure 2–3. Excel left-aligns all text and right-aligns all numbers. All data is bottom-aligned. You can select a different horizontal and vertical alignment for any cell. FIGURE 2–3 Horizontal and vertical alignments To change the alignment of a cell, select the cell and then click an alignment button in the Alignment group on the Home tab of the Ribbon. For other alignment options, click the Format Cells: Alignment Dialog Box Launcher to display the Alignment tab in the Format Cells dialog box. In the Text alignment section, click the alignment you want in the Horizontal or Vertical boxes, and then click OK. Merging and Centering Data You can also center cell contents across several columns. Select the cells, and then click the Merge & Center button in the Alignment group on the Home tab of the Ribbon. The selected cells merge , or combine into one cell, and the contents from the upper-left cell are centered in the newly merged cell.
Excel%20Lesson%202.docx