Forum Discussion

Sue123's avatar
Sue123
Copper Contributor
Sep 17, 2020
Solved

Excel Headers - paste an object

I am trying to paste a company logo into an excel header so that I can create an invoice. I have copied the logo from word but the paste option is greyed out in excel header. Is it possible to do this?

Thanks

 

  • Sue123 

     

    A small workaround and you can use graphics in headers or footers:

    Ribbon, Page Layout tab, click on the dialog arrow in the lower right corner of the Page Setup group.
    In the dialog, open the Header / Footer tab and then click on User-defined Header ... (or Footer ...).
    Now all you have to do is click the Insert Image icon and select the graphics file.
    If you still have to scale the graphic file ...
    In the View tab in the ribbon, switch to Page Layout.
    Click in the text "& [graphic]" in the header or footer.
    Now you can open the dialog of the same name in the Draft tab with the Format graphic button.

    Tip tested under Excel 2007, 2010, 2013, 2016/19

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

5 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    Sue123 

     

    A small workaround and you can use graphics in headers or footers:

    Ribbon, Page Layout tab, click on the dialog arrow in the lower right corner of the Page Setup group.
    In the dialog, open the Header / Footer tab and then click on User-defined Header ... (or Footer ...).
    Now all you have to do is click the Insert Image icon and select the graphics file.
    If you still have to scale the graphic file ...
    In the View tab in the ribbon, switch to Page Layout.
    Click in the text "& [graphic]" in the header or footer.
    Now you can open the dialog of the same name in the Draft tab with the Format graphic button.

    Tip tested under Excel 2007, 2010, 2013, 2016/19

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

    • vaphaet's avatar
      vaphaet
      Copper Contributor
      I'm using Office 365. I can open the dialog box for inserting image where I have 3 options: From file, Bing search and OneDrive.
      None of the options work. Clicking on the 1st and 3rd option does nothing, entering any search term in to the bing search bar gives an error message.
    • Sue123's avatar
      Sue123
      Copper Contributor
      thanks that has worked for me.
      • NikolinoDE's avatar
        NikolinoDE
        Gold Contributor
        your welcome.
        I was pleased to be able to help you.

        Nikolino
        I know I don't know anything (Socrates)

Resources