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:
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:
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.
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 http://www.mrexcel.com/tip129.shtml. If you are looking for show notes from another episode, visit my complete list of TechTV appearances.
MrExcel.com 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.