In excel, if I have a spreadsheet that takes more than 2 pages, how can I make a certain range of columns appear on the second sheet as well.
eg.
I have the 12 months in column A. I have different temps and stuff in columns B through H, and I want to print the spreadsheet, but the page cuts off at column E. How do I make column A to appear on the 2nd sheet where I continue to print columns F through H.
In otherwords, I want column A to appear on every sheet no matter how many sheets I need to print. How do I do this?
eg.
I have the 12 months in column A. I have different temps and stuff in columns B through H, and I want to print the spreadsheet, but the page cuts off at column E. How do I make column A to appear on the 2nd sheet where I continue to print columns F through H.
In otherwords, I want column A to appear on every sheet no matter how many sheets I need to print. How do I do this?
Facebook
Twitter