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 » Printing
Resolved · Low Priority · Version 2003
Annabel has attended:
Excel Intermediate course
Project Intro Intermediate course
How do you print out worksheets ensuring your headings are carried over to each page
Hello Annabel
Thank you for your question and welcome to the forum.
You can use Print Titles to ensure headings are repeated at the top and/or left hand side of each page when a spreadsheet is printed.
To use print titles, go to File - Page Setup - Sheet tab and use the Print titles areas to select columns and/or rows that contain the data to be repeated.
Please note you cannot use Print titles whilst in Print Preview - you must be looking at your spreadsheet in Normal view.
Kind regards
Amanda
Mon 23 Feb 2009: Automatically marked as resolved.
|
Excel tip:Create a hyperlink navigation sheetIn large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets. |
We'll call during UK business hours
Server loaded in 0.08 secs.