Do you want to keep important labels and data in view as you scroll through your Excel worksheets? Here are the steps to freezing those columns and rows.

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

This how-to guide will let you know how to freeze cells in Excel, so you can see your headings no matter how big the file is.

Are you having difficulty freezing all the rows and columns in your Microsoft Excel spreadsheet? Here's a workaround that will help you with your problem.