How to lock headings in Excel

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