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.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

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.

To quickly erase these values, click the first unwanted "0," press "Control-Shift-Right Arrow" to select the rest of the row and push "Delete" to remove the values.

You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen data leaving the screen.

When working with a large data set, you would be more productive if you knew how to quickly find what you need. Luckily, Excel has a few functions that can help with this.

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.