200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi again, I got the answer to the last question but now I am trying to do something that must be simple... How do I add a header only to the second page of a spreadsheet when I print it?
I can click the header and type what i want from Page Layout on the View tab and then type the header, I just can't stop it from appearing on my first (title) page.
Thanks again!
Ging
Hi Ging!
I think what you need to do once you are in the page layout view (View tab > Page Layout) is to click where it says "Click to add header" AND then look to the Ribbon menu and a new tab will appear called "Design." Go to that tab and on the right check the option "Different First Page".
Then anything you enter on the first page will only be for the first page and anything you enter on the second page will work for the second page and any following pages.
