Google-sheets – Use text and images in a Google Sheets header/footer

google sheets

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?

Best Answer

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.

Related Topic