totn Excel

MS Excel: Rows

In Microsoft Excel, a row runs horizontally in the grid layout of a worksheet. Horizontal rows are numbered with numeric values such as 1, 2, 3. Vertical columns are numbered with alphabetic values such A, B, C.

Microsoft Excel

Each row in the worksheet has its own row number which is used as part of a cell reference such as A1, A2, or M16. You can select an entire row by clicking on the row heading (ie: the number running along the left side of the grid layout). In the example above, we have selected row 3.

There are many things that you can do with rows in Excel such as inserting, deleting, hiding, unhiding, and resizing rows as well as conditional formatting. Here is a list of topics that explain how to use rows in Excel.

Insert / Delete

Hide / Unhide

Sizing

Conditional Formatting