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.
- Click on Print Titles
- Click into Rows to repeat at top
- If you want to repeat a column or two select them as well in Columns to repeat at left
- 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.
- Click on Print Titles
- Click into Columns to Repeat at left
- 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
Very helpful tip Shelley. Thank you.
Wow, thank you that’s just what I need for my annual accounts spreadsheets.
Very useful, thank you Shelley, I’m learning so many useful tips from your posts.
Gosh, I never knew that. Thanks.