Jul 29, 2005 - For some reason, on my current sheet that option is greyed out. How can I get Excel to print title/column headers on each page as it normally.
Not being able to make this change from the print preview page setup window has been a bug in Excel for several versions now. Intuitively, anything related to the way something is printed should be available, and primarily accessed through this route, since this is where you will notice if something is not the way you want it. However, as is, you must:. Back out and go back to the main document editing view. Choose the page layout tab. Click on that tiny arrow in the corner of page setup to open the options by that route.
Make changes there. Go back to print preview again to find out if it is the way you want it now. If you need to produce several printouts to the preference of several bosses, multiple roundabouts are needed.