Altering Row Height

Altering row height makes the best use of the worksheet space, just like adjusting column width does. You can set the row height manually or let Excel make the adjustments for you with its AutoFit feature.

By default, Excel makes a row a bit taller than the tallest text in the row. For instance, if the tallest text is 10 points tall, Excel makes the row 13.5 points tall. The default row height is set to 13.5 points, based on the default font size, 10 points.

In the upcoming To Do exercise, you alter row height with a mouse.

To Do: Alter Row Height

1.
Move the mouse pointer to the bottom row header borders, row 1. You should see a double-headed arrow. Use the bottom border of the row header to adjust row height.
2.
Hold down ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.