alternate headers and footers

T

tjtjjtjt

Is there a way to alternate headers and footers in Excel--apart from dividing the data for each page onto separate worksheets?
As of now we are (depending on the user) either using Word to print out the correct number of pages with the correct headers and footers, then putting the paper back in the printer and printing the Excel sheet.
or
Inserting the file into a word document and then printing it. This doesn't always seem to bring all of the data over, though.
Is there a limit to the amount of data that can be transferred form Excel to Word (rows and/or columns)?

tj
 
Top