View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Print "freeze panes" on succeeding pages?

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!
================================================== ===

"kdhelm" wrote in message
...
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

"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?