Tue 13 Sep 2011, 12:29Delegate Peter said...
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
Wed 14 Sep 2011, 09:40Trainer Anthony said...
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
