Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training seminar - Headers..
Resolved · Low Priority · Version Standard
Colette has attended:
Excel Introduction course
How do I keep headers at the top of each column so that as I scroll down the page they are still visible at the top?
Hi Collette
It is known as FREEZE PANES
To use this function, select the row BELOW the the row you want to freeze, and then select WINDOW > FREEZE PANES
Regards
Richard
|
Excel tip:Adding up time greater than 24 hoursWhen you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours. |
We'll call during UK business hours
Server loaded in 0.08 secs.