Paul Wherly

How to print Headings in Microsoft Excel

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.

Print your titles on every page

 

 

 

 

 

 

 

 

 

  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

See column headings print

 

 

 

 

 

 

 

 

 

 

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.

Print the first column on every page

 

 

 

 

 

 

 

 

 

  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!

SFsignature

 

 

 

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

excel-2013-core-part-i

 

 

 

 

 

 

 

 

 

 

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

 

4 thoughts on “How to print Headings in Microsoft Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.

More