Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Sohail Sayed
Lv 5
Sohail Sayed asked in Computers & InternetProgramming & Design · 6 years ago

How to give different header to different page in MS excel 2013?

I am using a 2013 version of Microsoft office and like how in word you can give header to page and apply page break then Un-link to previous one and get different header on the next page and get a new header for that page but in excel i applied the header and un-linked it but i am still getting the same header on every page.

please help and tell me he way to not get same header on every page. if you have a video or a site that may solve my problem please provide me with that site link.

And thank you in advance.

1 Answer

Relevance
  • Anonymous
    6 years ago

    Excel just doesn't offer the same facility for having different headers as Word does. Try thinking along the lines of making your header dynamic. For example, if you place each section in a different worksheet tab and give each tab the name you want for each section, when you print the whole workbook, if you use the custom header "My Report: &[Tab]", you would have different section headers:

    My Report: Sheet 1

    My Report: Sheet 2

    My Report: Sheet 3

Still have questions? Get answers by asking now.