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

printing

ResolvedVersion 2007

RALPH has attended:
Excel Intermediate course

Printing

how do i print multiple worksheets with the same headings on each worksheet

RE: printing

Hi Ralph,

Thank you for your question and welcome to the forum.

Do you mean repeat the same headings on subsequent pages on the same workbook?

If so, then go to the Page Layout tab and in the Page Setup group and click on Print Titles. If the orientation of your page is portrait, then click into the columns to repeat at left and then with your mouse select the column you want repeated on the other pages.

I hope this answers your question.

Regards

Simon

Wed 14 Dec 2011: Automatically marked as resolved.

Excel tip:

Missing Field handle

If your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked.

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.1 secs.