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.

How to Delete a Row if Text Equals VBA in Excel. Microsoft Excel 2010 comes with the latest version of Visual Basic for Applications, or VBA, which is a programming language designed to interface ...

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

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.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

When you're working on an especially chunky spreadsheet in Microsoft Excel or Google Sheets, it can get annoying to have to scroll up, down, and around to keep track of where all the information ...

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.