Print Headings in Microsoft Excel 2013

There are times when you may have a very long list and you would like the header to print on every page.   You know, you print the list out and on pages 2,3,4 etc it becomes impossible to see what the columns are.   Enter Print Titles.

1. Click on Print Titles
2. Click into Rows to repeat at top
3. If you want to repeat a column or two select them as well in Columns to repeat at left
4. Click OK

Here on Page 2 you can see the Column Headers are showing in Print Preview

Print Columns to Repeat with Titles

Just like printing the header row on each page, you may wish to print the first column on every page too.

1. Click on Print Titles
2. Click into Columns to Repeat at left
3. Select the column you wish to print

Now the column you selected will be printed on every page.

How has this tip helped you? Do leave a comment and let me know!

This topic has been taken from my free eBook on Microsoft Excel 2013 Core : Intro which can be downloaded here:

For more ways to use Microsoft Excel effectively, give us a call to find out how we can help your organisation fill its skill gaps. Call us on 020 8203 1774  or email enquiries@theittrainingsurgery.com