Microsoft Office Tutorials and References
In Depth Information
Rotating Cell Contents
To merge and center the title across a cell range:
1. Select the range A4:F4 in the Yearly Sales worksheet.
2. In the Alignment group on the Home tab, click the Merge & Center button .
The range A4:F4 merges into one cell with a cell reference of A4 and the text is
centered within the cell.
3. Select the range A6:A15 , and then click the Merge & Center button . The
cells are merged vertically into a single cell, displaying the text “Units Sold”
aligned with the bottom cell border.
4. Select the range A17:A26 , and then click the Merge & Center button
. The
cells in the range are also merged vertically into a single cell.
5. Click cell . Figure 2-15 shows the merged cells in the Yearly Sales worksheet. A3
Figure 2-15
Merged ranges with centered text
Merge & Center
button
range A4:F4
merged into a
single cell with the
contents centered
range A6:A15
merged into a
single cell
Rotating Cell Contents
Text and numbers are displayed within cells horizontally. However, you can rotate cell
text to any angle to save space or to provide visual interest to a worksheet. The Units
Sold and Revenue titles were placed at the bottom of their respective merged cells,
which makes them diffi cult to read. The titles would look better and take up less room if
they were rotated vertically within their cells. You will rotate the titles.
To rotate the titles:
1. Click the merged cell to select it. A6
2. In the Alignment group on the Home tab, click the Orientation button , and
then click Rotate Text Up . The cell text rotates 90 degrees counterclockwise.
3. In the Alignment group, click the Middle Align button
. The rotated text
vertically aligns within the merged cell.
Search JabSto ::




Custom Search