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.

5] Then select ‘ Entire row’ from the delete options list and hit ‘ Ok’. Alternatively, you can also hit the ‘ Home ’ tab on the MS Excel worksheet and navigate to the ‘ Cells ’ group.

If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" feature. Here's how.

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