printing

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Printing

Printing

resolvedResolved · Low Priority · Version 2003

Annabel has attended:
Excel Intermediate course
Project Intro Intermediate course

Printing

How do you print out worksheets ensuring your headings are carried over to each page

RE: Printing

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 sheet

In 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.



Hyperlinks appear as underlined text and can jump to any cell or range name in your file. You can also use hyperlinks to jump to other files.



To create a hyperlink to a location in the active workbook: (1) Select the cell that contains the text you want to use as the hyperlink and choose Insert|Hyperlink.(2)Click Place in this document.(3)Choose the sheet you want to link to or the range name from the list of "Defined Names".(4)If necessary, type the cell reference in the Type in the cell reference box. (5) Click OK.

View all Excel hints and tips


Server loaded in 0.08 secs.