Peter has attended:
Excel Intermediate course
Heading Locking
Having created a table for listing PAT tests, how do I lock line1 with the headings on so that the other lines pass up under it
RE: Heading Locking
Hi Peter, thanks for your query. Position the active cell at A2. Then from the ribbon choose the View tab, the Freeze Panes drop down and the Freeze Top Row option. That should lock row 1.
Hope this helps,
Anthony