Excel Basics:
Format Rows

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web

The only unique formatting for rows is Row Height. Row Height is measured in points, like font size, from 0 to 409 points. 

A row height of zero hides the row. 

The default setting for Row Height is AutoFit. The row height adjusts to the largest font size in the row. 

AutoFit will leave a little white space, called the cell padding, between the text in the cell and the cell edges. When Arial 10 pt. is the Standard Font, the Row Height is 12.75 points (= 20 pixels, where a pixel is the smallest dot on the screen). You may find that this looks a bit crowded when the gridlines are shown. If you don't print the gridlines, your paper version will look OK.

When you have a whole row selected and you apply text formatting, like color, font size, or font, your choices are applied to all the cells in the row. You will work with these text formatting choices in the next project.

Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel IntroTo subtopics

Project 2: Excel Basics  
Getting StartedTo subtopics      
    Arrange arrow to open subtopics
      Icon - FootprintSort
      Icon - FootprintColumns Table
      Icon - FootprintRows Table
    AutoFillTo subtopics
    FinishTo subtopics
    ExercisesTo subtopics

Project 3: Format & ArrangeTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics


Icon Step-by-Step 

Step-by-Step: Format Rows

 Icon Step-by-Step

What you will learn:

to adjust row height with AutoFit
to adjust row height by setting font size
to adjust row height by dragging heading
to hide a row
to unhide a row

Start with: Class disk trips3.xls (saved in previous lesson)

Row Height: AutoFit

You will take advantage of the automatic resizing as you change the font size for the title.

  1. Row 1 selectedSelect Row 1. 

  2. Row 1 sized to 20With Row 1 selected, change the Font Size to 20 using the Formatting Bar. AutoFit automatically increases the row's height.

    You don't have to change the height of the whole row to get the same effect. Increasing the font size of a single character in a cell in the row will work, too. AutoFit will increase the Row Height to match.

  3. Double-click cell A1. You can now edit.
  4. One letter sized to 36 points makes the whole row that tallSelect a single letter and apply Font Size 36 to it and click on a different cell. The whole row height changes. 

    TipEven blank spaces have a font size. If you have a height error that you cannot find, look at spaces and blank cells in the row.

  5. Undo. Cell A1 is back to 20 points again.

Row Height: Drag

  1. Row 1 with row height tipPosition the pointer over the bottom edge of the Row 1 heading until it changes to Pointer: Row Resize the Resize Row shape. Click and hold to see the popup tip with the Row Height. Release mouse button.

    Notice that the Row Height is larger than the Font Size that you set to 20 points. This creates the white space above and below the text.

    If you drag by accident, you will resize the row height. Use Undo to reverse this, if necessary.

  2. Select Row 2.
  3. Row 2 with row height tipPosition the pointer over the bottom edge of the Row 2 heading until it changes to Pointer: Row Resize the Resize Row shape. 
  4. Drag downward until the popup tip show a Height of 21.00. Release the mouse button.

Row Height: Dialog

  1. Select Row 3, which is blank.
  2. Right click Menu:  Row HeightRight click on the selected row and from the popup menu select  Row Height... (This command is also on the menu  Format  |  Row... |  Height... )
    Dialog: Row Height, set to 20

    The Row Height dialog appears.

    Row 3 at height 20
  3. Type in a new height of 20 and click on OK. Row 3 is now 20 points in height.

Row Height: for Multiple Rows

  1. Selecting rows 5,6,7Select Rows 5, 6,and 7 by dragging across the row headings.
    Rows 5,6,7 with row height popup
  2. While the three rows are selected, move the pointer over the bottom edge of any one of the selected rows until it changes to Pointer: Row Resize the Resize Row shape.
  3. Drag downwards until the popup tip shows a height of 20.25

    Confusing effect: As you drag, the row headings resize but the rows do not until you release the mouse button.
  4. Rows 5,6, 7 resized by draggingRelease the mouse button. All selected rows now have the same new height.

Row Height: AutoFit Multiple Rows

The spacing you just created will make the sheet too big if applied to all rows. You should return the rows to the AutoFit height. (Yes, Undo would work here, but you are practicing with Row Heights!)

  1. Select Rows 5, 6, and 7 again if necessary.
  2. Rows 5,6,7 returned to AutoFit heightDouble-click the bottom edge of any one of the selected rows. The rows return to their AutoFit height.

Hide/Unhide rows

Sometimes you want to temporarily hide some rows to make the sheet easier to read. Or perhaps you have calculations in cells that you don't really need to see. They just need to be there. To hide rows without deleting them the row height needs to be 0.

These same procedures work with columns, too.

  1. Rows 18 to 23 selectedSelect rows 18 through 23. These are trips that were not in the special anniversary offer.

  2. Dragging to set row height to 0Drag upwards until the Row Height tip shows a height of 0. Release the mouse. 

    Rows 18 to 23 are hidden! Your rows have vanished! Notice how the numbers skip now in the row headings from 17 to 24. Sneaky!

    To make these rows appear again is a bit trickier when the height is 0. You cannot select just these rows. There is no menu command for selecting particular rows.

  3. Dragging across hidden rows to select themDrag from row 17 to row 24, selecting the whole rows. You have selected also the invisible rows inbetwee: 18 through 23.

  4. Hidden rows back to AutoFit heightDouble-click the bottom edge of the row headings in your selection. AutoFit returns all rows to the default height. Whew! 
  5. Class disk Save As  trips4.xls 
    full floppy diskHow to handle a full disk

    Trips4.xls after formatting rows

LessonsWorking with Numbers Previous Page Next Page

Teachers: Request permission to use this site with your class

Copyright © 1997-2012 Jan Smith   <jegs1@jegsworks.com>
All Rights Reserved

Icon: DonwloadIcon: CDWant a local copy with no ads? - Download/CD
Want to help?

~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~

Last updated: 02 May 2012