In Excel is it possible to print titles only over a certain range instead of every page?

Question

I am trying to print titles over a section of my spreadsheet. I do not want the titles over the entire print range. Is this possible?

Answer 1

File, Page setup, Sheet tab, Print Titles Section.
Depending on whether you have titles across the top or the side or both, you would use the "rows to repeat" and/or "columns to repeat" boxes.

Answer 2

At the top of the Excel pane, go to 'File', then choose 'Page Setup'. This will bring up a dialog box. Go to the 'Sheet' tab, the farthest one to the right at the top of the pane. Under the section "Print titles", there's a place where you can choose "Rows to repeat at top:" Click on the square that looks like a little spreadsheet with an arrow in the middle of it. This will be at the far right of the text box where you're supposed to type in an answer. The dialog box will suddenly collapse into a blank, one row high box with "Page Setup - Rows to repeat at top:" along the top of the pane. Now go directly to the Excel spreadsheet and click and hold while you highlight rows 1 and 2 at the extreme left of the pane. This should put those flashing dashed lines around the two rows on the actual spreadsheet. There should also be "$1:$2" in the dialog box. Hit "Enter" on your keyboard. The big "Page Setup" dialog box should reappear and the small one will have disappeared. "$1:$2" should be in the "Rows to repeat at top:" field. Click "Ok" at the bottom right hand corner of the dialog box, and it should disappear. You have just set the parameters for printing the top two rows of your spreadsheet on every page that is printed, no matter how many columns are included or in what order the pages are printed. When you save the spreadsheet, that option will remain set to the top two rows. For some reason, in some versions of Excel, this can only be done by going to File, Page Setup. No shortcuts will allow you to set the print options. I'm sure Mighty Microsoft has its reasons for this, but it can be really infuriating when you don't know the tricks. Hope that helps.

Answer 3

yes just highlight the ranges and print