Rows Fundamentals

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

Rows Fundamentals

Introduction to Rows

In the previous lesson, we saw that a spreadsheet organizes its information in categories called columns. To show the values in a spreadsheet, each column holds a particular value that corresponds to another value in the same horizontal range. While the values under a column should (in most cases must) be the same, the values in a horizontal range can be different. The group of values that correspond to the same horizontal arrangement is called a row.

Consider the following list we introduced in the previous lesson:

First Name Last Name English History Geography Math Chemistry Physics
Roland Becker 10.50 12.00 12.00 16.50 16.75 14.00
Chrissy Groans 12.00 14.50 14.00 12.75 12.00 10.50
Robert Farell 16.00 15.50 16.50 14.50 14.00 15.50
Alexa Schwitts 15.50 14.00 16.00 16.50 13.50 14.25

This contains many rows. The first row contains the values Roland, Becker, 10.50, 12.00, 12.00, 16.50, 16.75, and 14.00. The second row contains the values Chrissy, Groans, 12.00, 14.50, 14.00, 12.75, 12.00, and 10.50. As you can see, the list contains many rows and each row has its own values.

Although each row in the above list has a value for each column, it is not unusual to have empty areas under a certain column and sometimes a row would even have only one value even though there are many columns available.

As a spreadsheet application, when Microsoft Excel starts it creates the rows you will need. As a matter of fact, Microsoft Office Excel 2007 creates 1,048,576 rows.

Like the columns, each row is labeled. The rows are labeled from Row 1 to Row 1048576. These labels show on small boxes on the left side of the Microsoft Excel interface. Each box that shows the label of a row is called a row header:

Microsoft Excel

You can use just a few of the rows for your assignment but all of them are always available.

When using a row, you can click it or use the keyboard to get to it. You can also right-click a row. When you do this, a menu would appear:

Row Context-Sensitive Menu


Rows Selections

As done with columns, you can select one row or a group of rows. You can also select rows at random. You can perform selections using the mouse, the keyboard, or a combination of both.

You can use only the mouse to select rows:

  • To select a row using the mouse, position the mouse on a row header. The mouse cursor would change into a right-pointing arrow. Then click:


  • To select a range of rows using the mouse, click one row header and hold the mouse down. Then drag in the direction of the range:

You can also use only the keyboard

  • To select a row using the keyboard, make sure a box on its right side is selected (in the next lesson, we will learn that you can press the arrow keys to select one of those boxes). Press and hold Shift. While Shift is still down, press the Space bar and release Shift
  • To select many rows using only the keyboard, use the above technique to select the starting row. Press and hold Shift, then press either the up or the down arrow key. When the range of rows has been selected, release Shift

You can also use a combination of the mouse and the keyboard to select one or more rows:

  • To select a range of rows using a combination of the mouse and the keyboard, click one row at one end of the desired range. Press and hold Shift. Then click the row at the other end, and release the mouse.
  • To select rows at random using a combination of the mouse and the keyboard, click one row header, press and hold Ctrl. Then click each desired row header. When you have selected the desired rows, release the mouse. Each row selected would be highlighted:

Selecting Rows

Practical Learning: Selecting Rows

  1. Open the RTHS3.xlsx file
  2. To select a row, click the row header 5
  3. To select more than one row, click row 8 and hold the mouse down. While the mouse is still down, move it down until row 12 is selected
  4. Release the mouse
    Row Selection
  5. Click any box on the right side of Row Header 14
  6. To select a row, for example row 14, press Shift + Space
  7. To deselect, press Ctrl + Home