Heading Locking

Resolved · High Priority · Version 2010

Tue 13 Sep 2011, 12:29 Delegate 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:40 Trainer 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

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

Heading Locking

Heading Locking

RE: Heading Locking

Excel articles

Excel tip:

Calculate difference between two times