Tags: excel, grouped, grouping, means, microsoft, msdn, page, print, row, setup-gtsheet-gtprint, sheet, software, titles, unable, workbook, worksheets

Cannot print titles (top row) even though worksheets not grouped

On Microsoft » Microsoft Excel

2,186 words with 4 Comments; publish: Thu, 22 May 2008 23:18:00 GMT; (306108.89, « »)

Even though my workbook only has one sheet, which means I

don't have any grouping, I am still unable to use Page

Setup->Sheet->Print Titles. This option is always dimmed.

How can I correct this situation?

Thanks.

All Comments

Leave a comment...

  • 4 Comments
    • Hi Elson

      Don't know if you use File>Page Setup or the Printpreview ?

      But It is not working if you are in printpreview .

      Regards Ron de Bruin

      (Win XP Pro SP-1 XL2000-2003)

      www.rondebruin.nl

      "Elson" <anonymous.excel.todaysummary.com.discussions.microsoft.com> wrote in message news:044b01c3ef5c$0c706cb0$3a01280a.excel.todaysummary.com.phx.gbl...

      > Even though my workbook only has one sheet, which means I

      > don't have any grouping, I am still unable to use Page

      > Setup->Sheet->Print Titles. This option is always dimmed.

      > How can I correct this situation?

      > Thanks.

      #1; Thu, 22 May 2008 23:19:00 GMT
    • Hi Ron,

      Thanks for the answer! You are right in that I was going

      to Page Setup through Print Preview instead of through

      File->Page Setup directly. This must be a bug?

      In any case, now I know how to do it properly.

      Thanks again!

      Elson

      >--Original Message--

      >Hi Elson

      >Don't know if you use File>Page Setup or the

      Printpreview ?

      >But It is not working if you are in printpreview .

      >

      >--

      >Regards Ron de Bruin

      >(Win XP Pro SP-1 XL2000-2003)

      >www.rondebruin.nl

      >

      >"Elson" <anonymous.excel.todaysummary.com.discussions.microsoft.com> wrote in

      message news:044b01c3ef5c$0c706cb0$3a01280a.excel.todaysummary.com.phx.gbl...

      >> Even though my workbook only has one sheet, which means

      I

      >> don't have any grouping, I am still unable to use Page

      >> Setup->Sheet->Print Titles. This option is always

      dimmed.

      >> How can I correct this situation?

      >> Thanks.

      >

      >.

      >

      #2; Thu, 22 May 2008 23:20:00 GMT
    • It's not a bug--it's a side effect of the fact you can't select any cell contents in the Print Preview

      tj

      #3; Thu, 22 May 2008 23:22:00 GMT
    • Thanks, tj.

      >--Original Message--

      >It's not a bug--it's a side effect of the fact you can't

      select any cell contents in the Print Preview.

      >tj

      >.

      >

      #4; Thu, 22 May 2008 23:23:00 GMT