Print "freeze panes" on succeeding pages?

A

Andrea

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
 
K

kdhelm

Thank you Andrea, what does it mean when it says I do not have a valid
reference. I want to print row 1 and row 2 what do I enter in the box and
how should it read?
Thanks
 
R

RagDyeR

Enter
1:2
Then <OK>

When you go back to:
<File> <SetUp> <Sheet> tab,
You'll see:
$1:$2

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Thank you Andrea, what does it mean when it says I do not have a valid
reference. I want to print row 1 and row 2 what do I enter in the box and
how should it read?
Thanks
 
J

John

in the box you need to enter $1:$2. The easy way to do this is to click in
the row to repeat box and use the mouse and clicl on the rows you want to
repeat.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
A

Alain59

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
 
O

OneCosmicGuy

Im looking for a way to do this when I save the excel file as a web page. In
Office 2000, I could save it with interactivity or something and when viewed
as a webpage, the freeze panes would work.... after upgrading to Office 2007,
can't get that to work anymore. I would assume it's still possible?

TIA!
Adam
 
Top