When dealing with large amounts of data in an Excel workbook, you often need to use the Freeze Panes item on the ribbon. This option allows you to keep a certain area visible as you scroll to other parts of your worksheet. You can freeze rows, columns or both rows and columns. Be sure to click on each video to view the tutorial!