ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   print headings at the top of each page (https://www.excelbanter.com/excel-discussion-misc-queries/47071-print-headings-top-each-page.html)

onemanhattanrebel

print headings at the top of each page
 
When I go to the Sheet Tab, the Print Titles option is not acive. These
options are greyed out. How can make them active?

Earl Kiosterud

I think you mean the sheet tab of the File - Page Setup dialog. If you've
come from a print preview, those boxes are not available. You have to have
gone directly from a sheet with File - Page Setup. There has to be a sheet
in the background, not a print preview, because the Print Titles boxes are
RefEdit boxes, boxes you can click in a cell to put in the reference you
want.

--
Earl Kiosterud
www.smokeylake.com

"onemanhattanrebel" wrote in
message ...
When I go to the Sheet Tab, the Print Titles option is not acive. These
options are greyed out. How can make them active?





All times are GMT +1. The time now is 04:46 PM.

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