Spreadsheets are a great way to make calculations, organize data, and analyze information. They typically live on-screen, but it’s not uncommon to print your spreadsheets and create physical copies.
When you do that, it takes work to ensure that they appear similar to the on-screen version. For example, you need your titles to appear at the top of each page to remind you of the column header. We can do that as we learn how to print titles in Excel.
How to Print Titles in Excel
Let’s say that we have a very tall spreadsheet with many rows. When it’s printed, it’s common that the data continues far past a single page.
Here’s the problem: starting on the second page, you can’t see the headers to the column. That means that you no longer know what each number means, because it lacks context. We can correct this by printing titles in Excel.
First, switch to the Page Layout tab. Click on the Print Titles icon on the ribbon. You’ll see a new window pop up.
Click on the arrow next to the Print Area box. Then, click and drag to select everything you want to print on the spreadsheet. In my case, I highlighted the entire table that includes invoice information.
Now, we need to click on the Rows to Repeat at Top arrow. Now, click on the row that includes the titles for the table. This is basically telling Excel which area to use as the continuing header row. This will show on each and every printed page. You can click the Print Preview option to see the results.
Check out the example below. You’ll see that I’m on page 2, but the table headers show. This means that each and every page includes the headers and helps you stay oriented in your workbook in a printed copy.
With printed titles, you’ll never lose track of your spot in a printed spreadsheet. Remember to turn this option before you print so that each sheet doesn’t feel disconnected.