Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Making a Worksheet Easier to Read and Understand
Changing the size of columns and rows
By default, columns are 8.43 characters wide. To make columns wider, you
have to widen them yourself. Rows are 12.75 points high, but Excel makes
them higher when you enter letters or numbers that are taller than 12.75
points (72 points equals one inch). Excel offers a bunch of different ways to
change the size of columns and rows. You can start on the Home tab and
choose options on the Format button drop-down list, as shown in Figure
4-3, or you can rely on your wits and change sizes manually by dragging or
double-clicking the boundaries between row numbers or column letters.
Before you change the size of columns or rows, select them (Chapter 2 of
this mini-book explains how). Click or drag across row numbers to select
rows; click or drag across column letters to select columns.
the size of
Adjusting the height of rows
Here are ways to change the height of rows:
✦ One at a time: Move the mouse pointer onto the boundary between row
numbers and, when the pointer changes to a cross, drag the boundary
between rows up or down. A pop-up box tells you how tall the row will
be after you release the mouse button.