Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 7th 05, 01:40 PM
Minnow
 
Posts: n/a
Default How to make first row to show on every page

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.

  #2   Report Post  
Old September 7th 05, 01:52 PM
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Old September 7th 05, 02:01 PM
David McRitchie
 
Posts: n/a
Default

I see Dave answered your question, perhaps the related information
may still be of use.

For printing, file, page setup, sheets (tab)
Rows to print at top: 1:1

You probably want the same for viewing
Select row 2 if you want to repeat row 1, or
Select cell B2 if you want to retain column A and row 1
Window (menu), Freeze panes -- unfreeze to reverse process

Additional related information in
http://www.mvps.org/dmcritchie/excel/freeze.htm
http://www.mvps.org/dmcritchie/excel/logohead.htm
http://www.mvps.org/dmcritchie/excel/pathname.htm
http://support.microsoft.com/default...;en-us;Q288964 Excel 2002 picture in header/footer

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

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




  #4   Report Post  
Old September 7th 05, 02:05 PM
Minnow
 
Posts: n/a
Default

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

  #5   Report Post  
Old September 22nd 05, 03:00 PM
Falcp
 
Posts: n/a
Default


--
Falcp


"David McRitchie" wrote:

I see Dave answered your question, perhaps the related information
may still be of use.

For printing, file, page setup, sheets (tab)
Rows to print at top: 1:1

You probably want the same for viewing
Select row 2 if you want to repeat row 1, or
Select cell B2 if you want to retain column A and row 1
Window (menu), Freeze panes -- unfreeze to reverse process

Additional related information in
http://www.mvps.org/dmcritchie/excel/freeze.htm
http://www.mvps.org/dmcritchie/excel/logohead.htm
http://www.mvps.org/dmcritchie/excel/pathname.htm
http://support.microsoft.com/default...;en-us;Q288964 Excel 2002 picture in header/footer

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

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







  #6   Report Post  
Old September 22nd 05, 06:56 PM
David McRitchie
 
Posts: n/a
Default

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

--
Falcp





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
page break preview VickiJo Excel Discussion (Misc queries) 1 June 10th 05 04:12 PM
How do I get a row to show up on every page texansgal Excel Worksheet Functions 1 June 2nd 05 04:22 PM
How do I delete the page watermark in the page break preview? fragilemouse Excel Discussion (Misc queries) 2 May 19th 05 03:16 PM
UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 05:58 PM
make first few rows print on every page? CD New Users to Excel 3 January 3rd 05 07:07 AM


All times are GMT +1. The time now is 09:32 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017