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.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

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.

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

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.