Forum home » Delegate support and help forum » Microsoft Excel Training and help » Heading Locking
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Heading Locking
Resolved · High Priority · Version 2010
Reply 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
For upcoming training course dates see: Pricing & availability
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
|