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

printing

ResolvedVersion 2007

Pia has attended:
Excel Introduction course
Excel Intermediate course

Printing

How do I ensure the first row appears on each printed page?

RE: Printing

Hello Pia

Thank you for your question and welcome to the forum.

You need to use something called Print Titles to do this.

1. Go to the Page Layout tab.
2. Click the Print Titles button.
3. Under Print Titles, select the row/s that you would like repeated at the top of each page, next to Rows to repeat at top.
4. Click OK.

Kind regards
Amanda

Excel tip:

Switch between workbooks ni EXCEL.

use Alt-TAB to switch between workbooks.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.