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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
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:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

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