Tags: column, excel, header, microsoft, msdn, page, row, sheet, software, spread

How to make first row to show on every page

On Microsoft » Microsoft Excel

6,562 words with 5 Comments; publish: Thu, 22 May 2008 21:02:00 GMT; (306171.88, « »)

I have a spread sheet. The first row data is the header for each column. But

they does not show on every page.

How can I make them show on every page?

I surely would appreciate any answer.

All Comments

Leave a comment...

  • 5 Comments
    • If you mean show on the window while you're editing:

      Select A1 (to make sure you can see row 1)

      select B1

      window|freeze panes

      If you mean when you print:

      file|page setup|sheet tab

      rows to repeat at top: $1:$1

      Minnow wrote:

      > I have a spread sheet. The first row data is the header for each column. But

      > they does not show on every page.

      > How can I make them show on every page?

      > I surely would appreciate any answer.

      --

      Dave Peterson

      #1; Thu, 22 May 2008 21:03:00 GMT
    • I do mean print out. It worked. Thanks a lot.

      "Dave Peterson" wrote:

      > If you mean show on the window while you're editing:

      > Select A1 (to make sure you can see row 1)

      > select B1

      > window|freeze panes

      > If you mean when you print:

      > file|page setup|sheet tab

      > rows to repeat at top: $1:$1

      >

      >

      > Minnow wrote:

      > >

      > > I have a spread sheet. The first row data is the header for each column. But

      > > they does not show on every page.

      > >

      > > How can I make them show on every page?

      > >

      > > I surely would appreciate any answer.

      > --

      > Dave Peterson

      >

      #3; Thu, 22 May 2008 21:05:00 GMT
    • You are using the "Microsoft CDO for Windows 2000" (Microsoft Communities)

      web interface. You are not directly using the newsgroups.

      If you are checking a box to show that the response(s) answered your question, please

      be aware that that indication does not come back to the actual newsgroups -- we can

      only see the text you type in.

      This question and ansers in this case were very straightforward and there are no

      conflicting answers, so it is reasonable to assume that the question was answered satisfactorily.

      Had there been different and/or conflicting answers feedback becomes much more

      valuable so that everyone knows WHICH answer was usable from your point of view,

      and so that everyone can tell whether you problem was really solved or not.

      Or maybe you just accidentally hit hit Enter and an empty response was generated,

      which can happen even in the newsgroups, but more likely to happen on web based

      (HTML) interfaces. ..

      --

      HTH,

      David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]

      My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

      Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

      "Falcp" <Falcp.excel.questionfor.info.discussions.microsoft.com> wrote in message news:0BD00603-5C35-4910-A8FC-BD5AD11A1E9B.excel.questionfor.info.microsoft.com...

      > --

      > Falcp

      #5; Thu, 22 May 2008 21:07:00 GMT