Forum Discussion

Laura_Bishop's avatar
Laura_Bishop
Copper Contributor
Jan 08, 2022

Inserting Headers and Footers

When I go to insert, I do not have the option of headers and footers.  Can you tell me how to add these to the ribbon?

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Laura_Bishop 

     In advance, with your permission, add several pieces of information, this would be helpful, especially for you ... but also for those who would like to help.

    Find out about the Excel version, operating system, storage medium (hard drive, OneDrive, Sharepoint, etc.), add one or a few photos and explain step by step which exactly is your plan/issue/problem.

     

    Headers and footers in a worksheet

    You can add headers or footers at the top or bottom of a printed worksheet in Excel. For example, you might create a footer that has page numbers, the date, and the name of your file. You can create your own, or use many built-in headers and footers.

    Headers and footers are displayed only in Page Layout view, Print Preview, and on printed pages. You can also use the Page Setup dialog box if you want to insert headers or footers for more than one worksheet at a time. For other sheet types, such as chart sheets, or charts, you can insert headers and footers only by using the Page Setup dialog box.

     Video: Header and Footer Details

     

    Hope I was able to help you with this info.

     

    NikolinoDE

    I know I don't know anything (Socrates)

     

Resources