Row

Updated: 01/24/2018 by Computer Hope

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

Spreadsheet

How can I freeze or setup 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 and then incrementing 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