Customize header and footer in Sheets Windows
After you enter your header/footer in the Page Setup window, you will be able to modify them.
*You can position your header/footer and customization in the left, right, or center part of the document (left, right, or center section).
Header and footer position.
- Scale with document - select the box to scale header/footer according to the document.
- Align with page margins - select the box to align header/footer by the document’s margins.
Odd and even pages.
- Different odd and even pages - select to insert different header/footer for each odd and even page.
- Different first page - select if you want header/footer on the first page to differ from the rest of the pages. Enter header/footer for the first page and header/footer for the rest of the pages.
Text formatting.
1. Select header/footer.
2. Click on the Font icon.
3. Modify the text.
4. Click OK.
Numerating pages.
Page number
1. Click on the right, left, or center section, depending on where you want additions to appear.
2. Select Page Number - Sheets will automatically display the consequent page number.
3. Click OK.
Total number of pages.
1. Click on the right, left, or center section, depending on where you want additions to appear.
2. Select Total number of pages - Sheets will automatically display the total number of pages.
3. Click OK.
Adding Time and Date.
1. On a Page Setup window, click in the left, right, or center section, depending on where you want time and/or date to appear.
2. Click on the time and/or date icons.
3. Click OK.
*Keep in mind that Sheets will display the time/date of printing to your header and footer.
Inserting File path, File name, and Sheet name.
1. On a Page Setup window, click in the left, right, or center section, depending on where you want additions to appear.
2. Select one or more icons, depending on the info you would like to add to header/footer.
- File path adds the file location to the header or footer.
- File name adds the file name to the header or footer.
- Sheet name adds the sheet name to the header or footer.
3. Click OK.
<%= heading %>