{"id":167444,"date":"2021-01-31T14:23:51","date_gmt":"2021-01-31T11:23:51","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-add-headers-or-footers-in-google-sheets\/"},"modified":"2021-01-31T14:23:51","modified_gmt":"2021-01-31T11:23:51","slug":"how-to-add-headers-or-footers-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-add-headers-or-footers-in-google-sheets\/","title":{"rendered":"#How to Add Headers or Footers in Google Sheets"},"content":{"rendered":"

“#How to Add Headers or Footers in Google Sheets”<\/strong><\/p>\n

\n\"Google<\/p>\n

A Google Sheets spreadsheet doesn\u2019t have a visible header or footer until you decide to print. If you want to add headers and footers to a Google Sheets spreadsheet, you\u2019ll have to use the printer settings menu\u2014here\u2019s how.<\/p>\n

To begin, open the Google Sheets spreadsheet<\/a>\u00a0that contains your data. At the top, click File > Print to view the printer settings menu for your document.<\/p>\n

\"On<\/p>\n

In the \u201cPrint Settings\u201d menu, you can customize the layout and design of your spreadsheet to make it suitable for printing. To add a new header or footer, click the \u201cHeaders and Footers\u201d category in the menu on the right.<\/p>\n

\"To<\/p>\n

A list of available options for both headers and footers will app<\/a>ear. Click the checkbox next to a preset option (for example, \u201cPage Numbers\u201d) to enable it.<\/p>\n

\"Click<\/p>\n

You can add page numbers, a workbook title, sheet name, or the current date or time to your printed spreadsheet. Google automatically determines whether to place these in the header or footer.<\/p>\n

For example, page numbers are automatically placed in the footer, while a workbook title will be placed in the header. If you want to change the position of a preset option or add any custom text to a header or footer, click \u201cEdit Custom Fields.\u201d<\/p>\n

\"Click<\/p>\n

The print view on the right will change and allow you to edit the text boxes in the header or footer. Click a box to make any changes to your header or footer.<\/p>\n

\"Click<\/p>\n

When you\u2019re ready to save your changes, click \u201cConfirm\u201d at the top right to return to the \u201cPrint Settings\u201d menu.<\/p>\n

\"Press<\/p>\n

If you\u2019re happy with the changes you made to your header or footer, click \u201cNext\u201d at the top right.<\/p>\n

\"After<\/p>\n

You\u2019ll now be taken to your browser or operating system\u2019s printer options menu. Here, you can specify more print settings for your spreadsheet, like the number of copies you want to print.<\/p>\n

The changes you made to your header or footer will save automatically, and they\u2019ll also be applied to any future copies of your Google Sheets spreadsheet that you print.<\/p>\n<\/div>\n