How to anchor a row in Excel

Excel lends itself to handling large datasets. When scrolling through a table that has many rows, the top rows also scroll up and it is difficult to keep track of the name of the column and the information in the rows above. Anchoring a row makes it possible to keep a row in place while you scroll through the rest of the data. For example, you can anchor the top row to keep the column headers locked while you scroll down the sheet.