Headers and footers

Once a sheet leaves your screen as paper or a PDF, every page has to identify itself: project, sheet title, date, page 3 of 11. That furniture sits on the Document tab, not the Text tab. Header and Footer in the Page group show or hide the two bands. Top and Bottom in the Margins group set their heights in pixels. 72 by default, anywhere from 40 to 400.

Open a band and put something in it

1. Open the Document tab.
2. Choose Header, Footer, or both. The page grows a band at the top or the bottom.
3. Raise Top or Bottom if the band is too tight for a logo above a title.
4. Double-click empty space inside the band to place a text region there, exactly as you would on the page body, then type or insert a field. Bands take text and pictures only. A separator line or a math region is refused.

Fields that fill themselves in

Click inside a header or footer region first, so there is a caret to insert into, then use the Fields group:

Field	What prints
Page #	The page number, updated per printed page.
Pages	The total number of pages, so you can write 3 of 11.
Date	Today's date.
Title	The worksheet name. The same name as the field at the top of the window.

Whatever you put in a band repeats on every printed page. Header and footer regions play no part in evaluation order, and calc numbering ignores them, so a title block cannot disturb your answers. Zoom on the Document tab changes only what you see on screen, never the printed page size. See Print and PDF.