The Page Setup dialog box will be displayed. In the Page Setup section, click the Repeat Titles button: The ribbon will change to the Page Layout ribbon bar: Start by opening the spreadsheet you want to print.Choose the rows you want to print on each page The concepts are the same, but the steps are slightly different. You will also learn how to print header columns on the left of every page in your printout.Ĭlick here if you want to print header rows in Excel 2010 for Windows. This lesson shows you how to get header rows printing at the top of every page in Microsoft Excel 2011 for Mac. There is nothing worse than having a printout that runs to multiple pages, with the column headings only printed on the first page. column headings) on each page in the print out. When printing in Excel, it is sometimes useful to print a set of rows (e.g.
