1
Open the Microsoft Excel App
Click Microsoft Excel from your start menu or Recent apps list to launch the application.
How to lock a row in Excel
In this tutorial, you will learn how to freeze panes in Microsoft Excel to keep your headers visible while scrolling through large datasets. You will walk through opening Excel, freezing the top row, and applying custom freeze settings based on your active cell selection. Follow these step-by-step actions to easily manage your spreadsheet views and improve data readability.
Operations
2
Click the View tab
Click the View tab in the top ribbon to access worksheet display options.
3
Click the Freeze Panes button
Click the Freeze Panes button in the Window group on the ribbon to open its dropdown menu.
4
Click the Freeze Top Row option
Select the "Freeze Top Row" option from the Freeze Panes dropdown menu to keep the first row visible while scrolling.
5
Verify the Top Row is Frozen
Scroll down your worksheet to confirm that the top row remains visible at the top of the screen.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.