Hi, I have a spreadsheet that I need to have a header on each page. Not on each tab, but page. So, when I enter the header on the first page, it copies it to all subsequent pages. How can I can the header title on all pages? Any help is appreciated. Thanks
Excel VBA Course - From Beginner to Expert
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.)
Inserting Header on each page
1
Answers
0
Page Layout tab > Page Setup section and click the small arrow in the bottom-right corner > in the window that opens, go to the Header/Footer tab > click Custom Header > input the desired header.