Row

Updated: 04/02/2019 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.

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. 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.

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 and press and hold the Shift key and press the spacebar.

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