Excel ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.

Determine the Last Row with Data: my_row = Cells (Rows.Count, 2).End (xlUp).Row finds the last row with data in column 2 (which corresponds to column ‘B’ in Excel) and stores this row number in the ...

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool.

The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.