Microsoft Office Tutorials and References
In Depth Information
Setting Row Heights
Amanda also wants you to increase the widths of columns A and B to 15 characters
to accommodate longer names. Rather than resizing each column separately, you can
select both columns and adjust their widths at the same time.
To increase the widths of columns A and B:
1. Click the column A heading. The entire column is selected.
2. Hold down the Ctrl key, click the column B heading, and then release the Ctrl
key. Both columns A and B are selected.
To select multiple
columns, you can also click
and drag the pointer over
multiple column headings.
3. Move the pointer to the right border of the column B heading until the pointer
4. Drag to the right until the column width changes to characters, and then 15
release the mouse button. Both columns are wide enough to display longer names.
The text in cell F1, Price per DVD, overﬂ ows the cell borders. This column would look
better if you increased the width of column F to 12 characters. You can set the column
width using the Format command on the Home tab. The Format command gives you
precise control in setting column widths and row heights.
To set the width of column F to 12 characters:
1. Click the column F heading. The entire column is selected.
2. In the Cells group on the Home tab, click the Format button, and then click
Column Width . The Column Width dialog box opens.
3. Type in the Column width box, and then click the OK button. The width of
column F changes to 12 characters, placing the text in cell F1 entirely within the
borders of the cell.
Setting Row Heights
The height of an Excel row is measured in points or pixels. A point is approximately 1/72
of an inch. The default row height is 15 points or 20 pixels. Row heights are set in the
same way as column widths. You can drag the bottom border of the row to a new row
height or deﬁ ne a speciﬁ c row height using the Format command. Another option is to
autoﬁ t the row’s height (or the column’s width) to match its content. Autoﬁ tting
eliminates empty space by matching the row height or column width to its tallest or longest
cell entry. If the row or column is blank, Excel restores its default height or width.
The row heights didn’t change after you resized the columns, which leaves a lot of
blank space in the four rows of customer data. This extra blank space makes the data
difﬁ cult to read and extends the content out of view. Amanda wants you to autoﬁ t the
heights of these rows to remove that empty space.