How to lock a header in Excel
By
SpreadCheaters
Page last updated:
16/11/2022 |
Next review date:
16/11/2024
You can watch a video tutorial here.
When scrolling through a table that has many rows, the column header also scrolls up and it is difficult to keep track of the name of the column. Locking a header makes it possible to keep the column header in place while you scroll through the rest of the data.
Step 1 – Navigate to the Freeze Panes option
– Select the View menu
– Select the Freeze Top Row option on the Window section
Step 2 – Check the result
– Row 1 is locked and you will be able to scroll down, keeping the headers in place
