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.

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.

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

How to freeze the first column in an Excel worksheet Follow the instructions above but, when you click on the Freeze Panes button, select Freeze First Column.

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 freeze columns in Excel with a few clicks, and then unfreeze them when you no longer need to view them statically.

You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen data leaving the screen.

Fortunately, Excel enables you to freeze or hold stationary worksheet rows at a designated point while the rest of worksheet scrolls to the left or right.