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

How to Expand and Collapse in Excel 2007. An Excel 2007 spreadsheet may contain very large quantities of data. Individual sections may be unimportant. For example, a sheet that lists your company ...

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.

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.

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows.

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.

You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" tab.