print

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

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

Print

resolvedResolved · Low Priority · Version 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:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips


Server loaded in 0.08 secs.