Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 16th 09, 08:55 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,101
Default Excel 2007 - How do I print my two row header on each page?

Similar to "freezing panes" except I want the frozen panes to print on each
page.

  #2   Report Post  
Old June 16th 09, 09:36 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,204
Default Excel 2007 - How do I print my two row header on each page?

[Page Layout] tab, {Page Setup} group, click the "Print Titles" item. A
classic page setup dialog will open. In its [Sheets] tab, enter $1:$2 in the
area labeled "Rows to repeat at top" (or click in that area and choose rows 1
& 2 - same result).

Hope this helps.

"Mike" wrote:

Similar to "freezing panes" except I want the frozen panes to print on each
page.

  #3   Report Post  
Old June 16th 09, 09:42 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default Excel 2007 - How do I print my two row header on each page?

Excel 2003 and earlier.

FilePage SetupSheetRows to repeat at top. enter 1:2

Excel 2007

Page LayoutPrint Titles enter 1:2


Gord Dibben MS Excel MVP

On Tue, 16 Jun 2009 12:55:02 -0700, Mike
wrote:

Similar to "freezing panes" except I want the frozen panes to print on each
page.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't print a header with Excel 2007 beta PLUMMER Excel Discussion (Misc queries) 0 July 18th 06 11:11 PM
In excel print header on firt page only roberte Excel Discussion (Misc queries) 2 May 14th 06 09:07 PM
print a certain row as the header on each page Michelle Excel Discussion (Misc queries) 1 October 13th 05 10:14 PM
How can I print a different header on each page of an Excel Sheet Fatrad Excel Discussion (Misc queries) 2 June 30th 05 07:20 PM
In Excel 2000, can I print the header on the first page only? gwh Excel Worksheet Functions 1 January 14th 05 10:56 PM


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017