ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I print the column headers in a freeze pane on all pag (https://www.excelbanter.com/excel-discussion-misc-queries/126343-re-how-can-i-print-column-headers-freeze-pane-all-pag.html)

Meenie

How can I print the column headers in a freeze pane on all pag
 
I see this is a "hundred year old post" and no one will probably ever see
my reply, but wow! At first I thought I didn't understand your answer,
then the light dawned :D I'm so excited. I have several spreadsheets and
could never get the column headings to print. It was sooo aggravating.
Thanks a gazillion :)

"swatsp0p" wrote:


From the main menu, select FilePage Setup click on the Sheet tab and
enter the rows you want repeated in the "Rows to Repeat at Top" box.
Click OK or Print Preview to verify you have the correct rows
selected.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=269231




All times are GMT +1. The time now is 05:20 PM.

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