When you go to print, be sure you are on the first tab, and select Print Entire Workbook so that all the pages print at once.If you need to adjust your margins so that there is enough space for the header/footer to not overlap data, you can. At the top of your worksheet, you have a left. Your worksheet’s view will immediately change, and you can now start adding your header. In the Insert tab, click Text > Header & Footer. In Excel’s ribbon at the top, click the Insert tab.
To do so, you need to open a file reference and write your headers, similar to what can be done for a text file. Have you ever printed an excel file with multiple tabs or worksheets, only to find you can’t tell which page came from which worksheet? There are several ways to solve this one, but the easiest is to just put the worksheet name in the header or footer, so that when you print the file, each page indicates the sheet it came from. Writing headers on Spreadsheet files is not natively supported by the LabVIEW function 'Write to Spreadsheet File'.