If you work with a title row or column in a large worksheet in Excel and find
that you keep needing to scroll back and forth to check the headings, then why
not fix that row or column in place? In this way, when you scroll, the title row
or column remains in place.
To do this for a title row, highlight the row above the first data row and
choose Freeze Panes from the Window menu. The technique for freezing headings in
a column is in essence the same – just highlight the column to the left of the
first data row.
To freeze both rows and columns, select the appropriate cell before executing
the Freeze Panes command. To turn this feature off, open the Window menu and
choose Unfreeze Panes.
Senior Technical Analyst - £26,781 - £28,562 - London The Medicines and Healthcare products Regulatory Agency (MHRA) is the government agency which is responsible for ensuring that medicines and medical devices work, and are acceptably ... more >
London, Haringey, United Kingdom | Haringey Council
PMO Support Officer - Haringey, London - £32,289 - £37,542 pa Experienced project support officer required by the internal IT services organisation of a London borough council to work within its Programme Management Office ... more >
Senior Business Analyst - London Highly professional individual capable of working at senior / board level with blue chip clients - shaping and driving the analysis and design of their energy management solutions Proven capability ... more >
ICT Support Officer £27,320 - £33,370 pa inc. depending on experience (pay award pending) Maternity cover for up to one year Guildhall, London EC2 Bring your IT experience to one of the country's most prestigious ... more >More job opportunities
Print
Discuss
Send to friend
RSS feeds
del.icio.us
Digg this
reddit!
