Excel print header on all sheets


Nov 15, 2013 · Repeat table header in every page while printing in Excel I have one Excel file with some data in the beginning, a table with ~100 rows and some rows at the end. Is there a way to print table header for the table in every page it spans to? Click the left section and using the contextual Design tab, click Picture in the Header & Footer Elements group. Locate the picture file and click Insert. Excel will display the &Picture code until you move to another section of the header. To display the sheet name, click Sheet Name in the same group.'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code Click the left section and using the contextual Design tab, click Picture in the Header & Footer Elements group. Locate the picture file and click Insert. Excel will display the &Picture code until you move to another section of the header. To display the sheet name, click Sheet Name in the same group.If you want to print spreadsheet with data on several pages, it is more informative to have a column headers or labels on every printed page. See also how to print a large Excel spreadsheet.