Microsoft Office Tutorials and References
In Depth Information
Four co-op orders entered
Changing the Size of a Column or Row
The default sizes of the columns and rows in an Excel worksheet may not always accommo-
date the information you need to enter. You can change the width of one column or multiple
columns or the height of one row or multiple rows. Excel provides several methods for chang-
ing the width of a column or the height of a row. You can click the dividing line of the col-
umn or row, or you can drag the dividing line to change the width of the column or the
height of the row. Heights and widths are expressed in terms of the number of characters that
can be displayed in the cell, as well as the number of screen pixels, which are small units of
measurement that appear as tiny dots on the screen.
Changing the Column Width or Row Height
Click the column or row heading whose width or height you want to change.
Click Format on the menu bar, point to Column or Row, and then click Width or Height
(or click AutoFit or AutoFit Selection to make the column or row as large as the longest
entry of the cells).
In the Column Width or Row Height dialog box, enter the new column width or row
height, and then click the OK button.
Drag the column or row heading dividing line to the right or up to increase the column
width or row height, or drag the dividing line to the left or down to decrease the column
width or row height.
Double-click the column or row heading dividing line to make the column or row as
large as the longest entry of the cells in the column or row.