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

print

ResolvedVersion Standard

Agata has attended:
Excel Intermediate course

Print

how to print titles

RE: print

Hi Agata

Hope you enjoyed the course on the 11th

When you want to print titles what you will need to do is go to the Page Layout ribbon under page setup click the Print Title
button

which will take you to the sheet tab of page setup where you get to choose which columns or rows you want to repeat on the pages you are about to print

Make sure you go to print preview before you print

Hope this helps

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

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.