How to lock headings in Excel
By
SpreadCheaters
Page last updated:
13/01/2023 |
Next review date:
13/01/2025
You can watch a video tutorial here.
When scrolling through a table that has many rows, the column headings also scroll up and it is difficult to keep track of the name of the column. Locking the headings makes it possible to keep the column headings 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 column headings in place
