Updated: 05/21/2018 by Computer Hope

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.


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. all of the way 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.

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