Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2005

Tip: Looking for answers? Try searching our database.

make first few rows print on every page?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CD - 03 Jan 2005 03:29 GMT
I have the first few rows of my sheet frozen so that I can scroll down the
long columns (about 3 printed page lengths) without losing sight of the top
headings.
I would like to be able to set it so that those top rows print at the top of
each page.
Is that possible? It would be a great deal easier than trying to repeat the
heading columns at periodic intervals down the page becasue i don't know how
to figure out where I would repeat them to make them be the top rows of each
consecutive new page. Hope this makes sense.
Thanks,
CD
Max - 03 Jan 2005 03:52 GMT
Try:

Click File > Page Setup > Sheet tab

Under Print Titles, input* in box for:
Rows to repeat at the top: $1:$2
(to repeat the top rows1 and 2, for example)

Click OK

*Instead of keying-in, you could also just click inside the box,
then click outside on any cell in row1, say select B1 and drag down to B2

This'll also give return "$1:$2" inside the box
Signature

--
Rgds
Max
xl 97
---
GMT+8,  1? 22' N  103? 45' E
xdemechanik <at>yahoo<dot>com
----

> I have the first few rows of my sheet frozen so that I can scroll down the
> long columns (about 3 printed page lengths) without losing sight of the top
[quoted text clipped - 7 lines]
> Thanks,
> CD
CD - 03 Jan 2005 04:56 GMT
Thankyou. Going to see what I can do with those instructions.
Max - 03 Jan 2005 06:07 GMT
You're welcome !
Should work ..
Signature

--
Rgds
Max
xl 97
---
GMT+8,  1? 22' N  103? 45' E
xdemechanik <at>yahoo<dot>com
----

> Thankyou. Going to see what I can do with those instructions.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.