Microsoft Office Tutorials and References
In Depth Information
Inserting a Column or Row
To autofit the second row to match its contents:
1. Move the pointer over the bottom border of the row 2 heading until the pointer
changes to
2. Double-click the bottom border of row 2. The height of row 2 shrinks to match the
content of cell C2, which is the tallest entry in the row, with two lines of text.
You could continue to resize the remaining rows one at a time, but a quicker way is to
select the rows you want to resize and then autofi t all the selected rows simultaneously.
To autofit rows 3 through 5:
1. Drag the pointer across the row headings for rows 3, 4, and 5. The contents of
rows 3 through 5 are selected.
2. In the Cells group on the Home tab, click the Format button. A menu of
commands opens.
3. Click AutoFit Row Height . The height of each of the three rows autofits to its
contents, and all the empty space is removed.
4. Click cell to make it the active cell. The other cells in the worksheet are A1
lected. Figure 1-11 shows the worksheet with the revised row heights.
Figure 1-11
Row heights after autofi tting to contents
row heig hts match
their con tents
Inserting a Column or Row
You can insert a new column or row anywhere within a worksheet. When you insert a
new column, the existing columns are shifted to the right and the new column has the
same width as the column directly to its left. When you insert a new row, the existing
rows are shifted down and the new row has the same height as the row above it.
Search JabSto ::

Custom Search