Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Printing the Frozen pane

    I have used the freeze pane feature in Excel. So that the top 2 rows and the columns have been frozen…..

    When clicking on Print Preview, I want the frozen panes to be printed on every page… currently when printing it doesn’t hold the frozen panes on each page….

    I have attached the worksheet I am using currently

    Please note that it works in ‘Nurse’ worksheet and not for ‘Summary Top Sheet’

    Thanks in advance

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Go to File > Page Setup > Sheet (last tab). Then you can choose which rows to repeat on each page. When you click the button it will allow you to select the entire row(s). You have to do that for each worksheet.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2007
    Posts
    127
    once again you provided a quick and clear answer... thanks very much...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •