The Heights of Rows

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

The Heights of Rows

Introduction

To display the contents of boxes on its right, a row uses a certain height. The height is the distance from the top to the lower borders of the row. There are various techniques you can use to change the height of a row, using approximations or being precise.

Manually Heightening or Shrinking the Rows

To manually change the height of a row, position the mouse on the lower border that separates it from the next row (unless it is the last row). Here is an example:

Mouse Cursor

Click, then drag up or down until you get the desired height, then release the mouse.

You can also resize a group of rows. First, select the rows as we described above. Then position the mouse on the bottom border of one of the selected rows. Click and drag up or down in the direction of your choice until you get the desired height. Then release the mouse.

To undo this action:

  • On the Quick Access toolbar, click the Undo button Undo
  • Press Ctrl + Z

Practical Learning: Controlling the Heights of Rows

  1. Position the mouse between Row Headers 2 and 3 until the mouse turns into a short line with double vertical arrows
  2. Then double-click. That resizes Row 2
  3. Position the mouse on the separator of Row Headers 3 and 4, then click and drag up until the small box displays Width: 2.25
     
    Row Height
  4. To save the workbook, press Ctrl + S

Automatically Setting the Heights of Rows

If one of the boxes on the right side of a row header is too short or too tall, you can change the height of the row. To do this:

  • Double-click the bottom border of the row
  • Click the row header or a box on that row. On the Ribbon, click Home. In the Cells section, click Format and click AutoFit Row Height:

AutoFit Column Width

To undo any of these actions:

  • On the Quick Access toolbar, click the Undo button Undo
  • Press Ctrl + Z

Practical Learning: Automatically Resizing the Columns

  1. Click Row Header 5
  2. On the Ribbon, click Home if necessary.
    In the Cells section, click the Format button, and click AutoFit Row Height
  3. Press Ctrl + Home
     
    Resizing a Row
  4. Save the document

Setting the Height Values of Rows

You can use a dialog box to set exactly the desired height of a row or a group of rows. To specify the height of a row:

  • Right-click the row header and click Row Height...
  • Click a row header or any box on its right side. Then, on the Ribbon, click Home. In the Cells section, click Format and click Row Height...

To specify the same height for many rows:

  • Select a range of rows as we saw earlier. Right-click one of the rows (either one of the row headers or inside the selection) and click Row Height...
  • Randomly select a group of (non-adjacent) rows. Right-click one of the row headers and click Row Height...
  • Select the rows. On the Ribbon, click Home. In the Cells section, click Format and click Row Height...

This would call the Row Height dialog box where you can type the desired value and click OK or press Enter.

To undo any of these actions:

  • On the Quick Access toolbar, click the Undo button Undo
  • Press Ctrl + Z

Practical Learning: Setting the Width of Columns

  1. Right-click Row Header 6 and click Row Height...
  2. Type 1 and Click OK
  3. Press Ctrl + Home
     
    Row Height
  4. Save the file