ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column Titles on top of every printed page (https://www.excelbanter.com/excel-discussion-misc-queries/96717-column-titles-top-every-printed-page.html)

Alejandra

Column Titles on top of every printed page
 

Hi,

I would like to know how to keep all column titles on top of every page
when I print them. On the screen I just freeze panes, but when I print a
large file with hundrets of rows I get the problem.

Thank you.
Alejandra


--
Alejandra
------------------------------------------------------------------------
Alejandra's Profile: http://www.excelforum.com/member.php...o&userid=31933
View this thread: http://www.excelforum.com/showthread...hreadid=556741


Peo Sjoblom

Column Titles on top of every printed page
 
Filepage setup, select sheet then rows to repeat at top

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Alejandra" wrote in
message ...

Hi,

I would like to know how to keep all column titles on top of every page
when I print them. On the screen I just freeze panes, but when I print a
large file with hundrets of rows I get the problem.

Thank you.
Alejandra


--
Alejandra
------------------------------------------------------------------------
Alejandra's Profile:
http://www.excelforum.com/member.php...o&userid=31933
View this thread: http://www.excelforum.com/showthread...hreadid=556741




Alejandra

Column Titles on top of every printed page
 

Peo, thanks so much!!
Alejandra:)


--
Alejandra
------------------------------------------------------------------------
Alejandra's Profile: http://www.excelforum.com/member.php...o&userid=31933
View this thread: http://www.excelforum.com/showthread...hreadid=556741


Peo Sjoblom

Column Titles on top of every printed page
 
Thanks for the feedback


Peo



"Alejandra" wrote
in message ...

Peo, thanks so much!!
Alejandra:)


--
Alejandra
------------------------------------------------------------------------
Alejandra's Profile:
http://www.excelforum.com/member.php...o&userid=31933
View this thread: http://www.excelforum.com/showthread...hreadid=556741





All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com