I have created an Excel file with Header and Footer and I can view the Header and Footer using the Page Layout view when opening the file in my computer.

I upload the same file on SharePoint and open it on SharePoint, I can not see the header and Footer, because only Standard ( or normal) View is available on Excel in SharePoint.

How can I add the Page Layout view to Excel on SharePoint Excel. I am not the admin and I am not a programmer.

enter image description here

1 Answer 1


When you open the excel file in SharePoint and edit it in browser, you are actually using Excel Online. Per my knowledge, you cannot modify header and use page layout view in Excel online. You can try to open the file in client application like this: enter image description here

It will open the file in your desktop application, which will having the features like header & footer and page layout view.

  • Yes, Thank you very much :)
    – Armin
    Oct 20, 2020 at 18:39
  • @Armin, Glad to be help. It the reply solves your problem. Would you like to accept it as answer?
    – Jerry_MSFT
    Oct 21, 2020 at 5:22
  • My wish was to add the Page Layout view to Excel on SharePoint Excel. What you offered didn't answer my question, but I accept it as an asnwer, just because you spent time on it and I thank you for that.
    – Armin
    Oct 22, 2020 at 14:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.