0

In Google Docs I can apply a header and footer which can contain custom text or images to a doc.

In Google Sheets I can see how to apply a footer but it seems to only allow me to use standard data such as page number , sheet title etc, is it possible to use custom text and images in a Google Sheets header/footer?

1

After invoking print preview by CTRL + P you can Edit custom fields under Headers & footers

There you can add your custom text.

For an image, you can use =IMAGE("https://i.imgur.com/HC08Fqe.png?1"; 3) and place it under Frozen rows which can act like custom header if you select to repeat them.

Otherwise, you can create fully custom headers/footers simply by counting rows.

  • thanks i tried that but couldnt get the image to output, rather it just outs the formula instead (see screenshot here) any ideas where im going wrong ? imgur.com/a/o8ouSdV – sam Dec 3 '18 at 12:32
  • Here is my setup page : imgur.com/a/HYYRGfz – sam Dec 3 '18 at 12:33
  • @sam for that image you need to put it under "frozen rows" not "headers&footers" – user0 Dec 25 '18 at 17:18
0

Just paste the image in the rows where the header will be and it will show in all the sheets when you choose repeat frozen rows.
I wish I could do the same with a footer, but no solution for now.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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