See Ron de Bruin's site for where to find the menu commands in 2007

http://www.rondebruin.nl/0307commands.htm

Rows to repeat at top should be under FilePage Layout

Note: you don't use the "Freeze Panes" for printing.


Gord Dibben MS Excel MVP


On Mon, 2 Jun 2008 18:49:00 -0700, Alain59
wrote:

Hi, how do you do that in Excel 2007. The freeze pane is always gray and
there is no page setup menu function. I am baffled.
Alain

"Andrea" wrote:

if you mean how to repeat rows and columns each page:
go to page setup, sheet Tab and than you can input wich row to repeat on top
and wich column to repeat at left
Andrea

"kdhelm" wrote:

How do you set computer to print "freeze panes" on succeeding pages in excell?