About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store


Printing in Excel

Amber MacArthur, Bill Jelen, Leo LaPorte, Andy Walker on the set of Call for Help on TechTV Canada.

The tip in this show is from Learn Excel from MrExcel.

Today's episode reveals some printing secrets in Excel.

Print titles at the top of each page
To print your headings from row 1 at the top of each page, follow these steps:
  • From the Excel menu, choose File - Page Setup.
  • Select the 4th tab in the dialog box - the Sheet tab.
  • In the box for Rows to Repeat at Top, enter 1:1. For two rows, use 1:2. Excel will add the dollar signs after you close the dialog.

Print a letter at the top of page 1, and then repeat headings at the top of each additional page.
Say that you want to print a letter at the top of page 1, followed by a long report. Perhaps your letter is in rows 1-20 and the headings are in row 21 - 23. Data follows in rows 24-9000.

It is amazing that this works, but if you follow the steps above, specifying that rows 21:23 should be the rows to repeat at top, it will actually work. Excel will not print rows 21:23 at the top of page 1. Those rows will appear at the top of pages 2:150.

Print page numbers at the bottom of each page

While rows to repeat at top puts the headers on each page, there is something else called called Header/Footer. These tags will print outside the data area on each page. To add a page number to the bottom of each printed page, follow these steps:
  • From the Excel menu, choose File - Page Setup.
  • Select the 3rd tab in the dialog box - the Header/Footer tab.
  • In the Footer dropdown, choose Page 1 of ?

Print the Entire Workbook at once
If you have page numbers assigned to each worksheet, and then attempt to print using the print icon, Excel will start over at page 1 as you print each worksheet. To have all of the pages numbered sequentially starting at 1 and continuing for the entire workbook, follow these steps.
  • Select File - Print
  • In the Print What section, choose Entire Workbook
  • Click OK

For the BEST TV show on technology, check out Call for Help.

This tip was originally published on June 26, 2006 and aired on TechTV in Canada and Australia on June 26, 2006.

The permanent URL for this page is

If you are looking for show notes from another episode, visit my complete list of TechTV appearances. Consulting can be hired to implement this concept, or many other cool applications, with your data. provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.


Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.