Row

Updated: 08/16/2021 by Computer Hope

Row may refer to any of the following:

1. With a keyboard, a row is a series of keys going horizontally from the left-side to the right-side of the keyboard. Most keyboards have six rows of keys with the fingers resting on the home row. Other keyboard rows include the function keys, number keys, top row, bottom row, and spacebar row.

2. In a database, a row in a table is called records.

3. A row is a series of data banks laid out horizontally in a table or spreadsheet. For example, in the picture below, the row headers (row numbers) are numbered 1, 2, 3, 4, 5, etc. Row 16 is highlighted in red and cell D8 (on row 8) is the selected cell.

Spreadsheet

How can I freeze or make a row header that does not move?

To keep the top row or a set of rows frozen, so they do not move as you scroll down, use the freeze pane option.

How are rows and columns labeled?

In all spreadsheet programs including Microsoft Excel, rows are labeled using numbers (e.g., 1 to 1,048,576). All columns are labeled with letters starting with the letter "A." They increment by a letter after the final letter "Z." For example, after the letter Z, the next column is AA, AB, AC, ..., AZ and then incrementing to BA, BB, BC, etc. to the last column XFD.

When working with a cell, you combine the column with the row. For example, the very first cell is in column A and on row 1, so the cell is labeled as A1.

How to highlight a row using the keyboard

To highlight a row in Microsoft Excel using your keyboard, move to a cell in the row you want to highlight. Then, press and hold the Shift, and press the spacebar (Shift+spacebar).

Cell, Column, Gridlines, Range, Spreadsheet, Spreadsheet terms, Table