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

Steps to freeze multiple rows in Excel Click on the cell in column A of the row immediately below the rows you want to lock. For example, if you wish to lock rows 1 and 2, you should click on Cell A3.

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.