Microsoft Office Tutorials and References
In Depth Information
Changing the height of the second row
Select All button
pointer changes shape
over the row dividing line
You can continue modifying the height of the remaining rows using this technique, but, for
a worksheet containing a large amount of data, that would be extremely time-consuming.
Another approach is to select the entire worksheet and then double-click the dividing line
between any two row headings. When you do that, Excel changes the height of the rows
to accommodate the data in them and reduces the amount of empty space. You can use
this approach to resize columns, too.
You can select the entire worksheet by clicking the Select All button. You’ll use this
approach now to change the height of the remaining rows in the co-op order worksheet.
To change the height of the remaining rows:
1. Click the Select All button located at the junction of the row and column headings (see
Figure 1-18). The row and column headings are displayed in black or dark blue, and all of
the worksheet cells are displayed in light blue, indicating that the entire worksheet has
2. Move the mouse pointer to a dividing line between any two rows until the pointer changes
3 . Double-click the dividing line. Excel resizes the height of all the rows.
4 . Click cell A1 to make it the active cell and to remove the blue highlighting from the work-
sheet. Figure 1-19 shows the revised layout of the sheet.
Adjusting the height of the worksheet rows