Tuesday Tip: Print a Heading/Title in Excel Across Multiple Pages

By Richard Stokes

There are so many things that the program Microsoft Excel can do and most of us (including me) only stumble across its vast feature-set when we can’t do something and are forced to look it up. Well, that was me last week.

I wanted to print out a computer inventory spreadsheet for a client meeting and due to the number of entries, it was going to print across 2 pages. The issue I had was that the column titles didn’t print on anything but the first page. So, the second page had the remaining data but with no title heading for reference. My print job looked like this:

Page 1:
Print a Heading/Title in Excel Across Multiple PagesPage 2:
Print a Heading/Title in Excel Across Multiple Pages

There is an easy fix that applies to Office versions 2010 – 2016. If you’re running 2007 or earlier I’m not sure if the same instructions would apply. And besides, if you are, don’t you think it’s time to upgrade?!?

Here’s what to do:
In the spreadsheet you are working in click on the ‘Page Layout’ tab and then click on ‘Print Titles.’
Print a Heading/Title in Excel Across Multiple Pages

The ‘Page Setup’ box will pop up. Click on the mini spreadsheet icon and your mouse pointer will be taken back to the active spreadsheet. Simply click anywhere on row 1 (the title row) and Excel will automatically select that entire row. Then click the red ‘x’ on the active pop up to be taken back to the original ‘Page Setup’ box and you’ll now notice a set of values: ($1:$1) in the box called ‘Rows to repeat at top.’

Click on the OK button at the bottom to keep this setting.
Print a Heading/Title in Excel Across Multiple Pages

Now when you go to print, these titles will display on every page of the spreadsheet (page 2 shown now has the title row visible).
Print a Heading/Title in Excel Across Multiple Pages

 

Richard Stokes: As the Director of Sales for Network 1, Richard identifies “future” clients that can benefit from the support of an experienced, outsourced IT team. He helps clients and prospects find technology solutions they need to achieve better productivity and efficiency so they can focus their attention on making money and growing their respective business.

Network 1 designs, builds and supports the IT you need to run your business more securely, productively and successfully. Whether you want to outsource all of your IT needs to a reliable, responsive, service-oriented company, or need to supplement the work of your internal IT staff, we will carefully evaluate where you are now, discuss where you want to go and implement and support a plan to get you there with as little interruption as possible.

Leave a Comment





Related Posts