A professional spreadsheet is not complete without proper headers and footers. Page numbers, the company name, a logo, the print date, the filename — these elements appear on every printed page and turn a raw Excel printout into a polished business document. This module also covers inserting mathematical equations and special symbols into cells, which is essential for technical reports, scientific spreadsheets, and documents requiring currency signs, trademark symbols, arrows, or mathematical notation.
A header is a section that prints at the top of every page. A footer is a section that prints at the bottom of every page. Both are divided into three zones: Left, Centre, and Right — giving you independent control over what appears in each area of the header or footer.
When you click inside a header or footer zone, the Header & Footer contextual tab appears with buttons to insert dynamic fields (field codes that update automatically).
| Button | Field Code Inserted | What It Displays |
|---|---|---|
| Page Number | &[Page] | The current page number (1, 2, 3…) |
| Number of Pages | &[Pages] | The total number of pages in the printout |
| Current Date | &[Date] | Today's date — updates automatically each time the file is printed |
| Current Time | &[Time] | The current time at the moment of printing |
| File Path | &[Path]&[File] | The full file path and filename (e.g., C:\Reports\Q1_Sales.xlsx) |
| File Name | &[File] | The filename only (without the folder path) |
| Sheet Name | &[Tab] | The name of the current worksheet tab |
| Picture | &[Picture] | An image (logo) that prints in the header or footer area. See Section 10.4. |
| Format Picture | — | Resizes and formats an image already inserted in the header/footer. Only available after inserting a Picture. |
You can mix plain text with field codes in any zone. Type freely and click the Insert buttons to add codes at the cursor position:
Page &[Page] of &[Pages]Printed: &[Date] at &[Time]CONFIDENTIAL — &[Tab]&B before the code: e.g., &B&[File] prints the filename in bold&"FontName,Bold"&12 before the field — or use the Ribbon font controls when text is selectedThis is the correct method to add a company logo that prints on every page. Unlike a sheet background image (which never prints), a logo in the header appears on every printed page and every PDF export page.
&[Picture] appears in the header zone (you cannot see the image itself until you click outside the header)&[File])Page &[Page] of &[Pages])Printed: &[Date])
The Options group in the Header & Footer contextual tab provides advanced controls for when headers and footers appear.
| Option | What It Does | When to Use |
|---|---|---|
| Different First Page | Creates a separate, independent header and footer for the first page only. The first page header/footer can be different from (or blank on) all subsequent pages. | The first page is a title/cover page — you do not want "Page 1 of 10" or the logo to appear on the cover. Leave the first-page header blank and set the regular header for pages 2 onwards. |
| Different Odd & Even Pages | Creates separate headers and footers for odd-numbered and even-numbered pages. | Double-sided (duplex) printed documents where the binding is on alternating sides — page numbers appear on the outer edge of each page (left on even pages, right on odd pages), like a printed book. |
| Scale with Document | When ticked, the header/footer font size scales proportionally if the spreadsheet is scaled to fit (e.g., shrunk to 85%). When unticked, the header/footer stays at its defined size regardless of scaling. | Usually leave ticked for consistent visual appearance. Untick if you want the header to remain large even when the data is scaled down significantly. |
| Align with Page Margins | When ticked, the left and right header/footer zones align with the left and right page margins. When unticked, the header/footer extends edge-to-edge regardless of the margin settings. | Leave ticked for standard documents. Untick only when you need the header/footer to span the full paper width (e.g., a full-width colour banner in the header). |
Excel provides a list of common preset combinations via the Page Setup dialog (Page Layout → Page Setup dialog launcher → Header/Footer tab):
Headers and footers are per-sheet settings. To apply the same header/footer to multiple sheets quickly:
Excel supports inserting fully formatted mathematical equations — fractions, integrals, summations, square roots, matrices, and more — using the Equation Editor. Equations are inserted as floating objects (not inside cells) and are ideal for technical reports, scientific worksheets, and documentation.
| Option | What It Does |
|---|---|
| Insert New Equation | Creates a blank equation object on the sheet. The Equation contextual tab appears with a full set of mathematical symbols and structure tools. Type and build your equation from scratch. |
| Built-In Equations | A gallery of pre-built equations: Area of a Circle, Binomial Theorem, Expansion of a Sum, Fourier Series, Pythagorean Theorem, Quadratic Formula, Taylor Expansion, and more. Click any to insert it instantly. |
When an equation object is selected and you are in edit mode, the Equation contextual tab provides all the tools to build complex mathematical expressions:
| Group | Contents | Examples |
|---|---|---|
| Tools | Equation (switch to/from professional/linear format), Normal Text (switch between math and text mode) | Professional: renders beautifully. Linear: shows the raw code like x^2+y^2=z^2 |
| Symbols | Gallery of mathematical symbols: Greek letters (α β γ π θ Σ), operators (± × ÷ ≠ ≤ ≥ ∞ ∫ ∇ ∂), arrows, and more | π, Σ, ∞, ∫, α, β, θ |
| Structures | Pre-built mathematical structural templates with placeholders | Fraction (①/②), Script (x², x₂), Radical (√□), Integral (∫), Large Operator (Σ), Bracket, Function, Accent, Limit and Log, Operator, Matrix |
| Structure | How to Insert | Result |
|---|---|---|
| Fraction | Structures → Fraction → choose style → click numerator placeholder → type → click denominator → type | a/b as a proper fraction with numerator above denominator |
| Square Root | Structures → Radical → Square Root → type inside the radical placeholder | √(a²+b²) |
| Superscript / Exponent | Structures → Script → Superscript → type base then exponent; or type x^2 and press Space — Excel auto-converts | x², e𝑤 |
| Summation | Structures → Large Operator → Summation → type the limits and expression | Σi=1n xi |
| Integral | Structures → Integral → choose type (definite, indefinite) → fill placeholders | ∫ab f(x) dx |
| Matrix | Structures → Matrix → choose size (2x2, 3x3, etc.) → fill each cell placeholder | A 3x3 matrix with brackets |
Instead of clicking through menus, you can type equations in Linear format (a text-based syntax) and Excel converts them to professional display:
| You Type | Excel Converts To |
|---|---|
x^2 + y^2 = z^2 then Space | x² + y² = z² |
a/b then Space | Proper fraction a over b |
\sqrt(x) then Space | √x |
\alpha, \beta, \pi, \Sigma then Space | α, β, π, Σ |
\pm, \times, \div, \neq then Space | ±, ×, ÷, ≠ |
x_i then Space | xᵢ (subscript i) |
The Symbol dialog gives you access to thousands of special characters — currency signs, copyright marks, trade marks, arrows, fractions, accented letters, mathematical operators, and characters from every major writing system — that are not available directly on the keyboard.
| Control | Purpose |
|---|---|
| Font dropdown | Select the font to browse symbols from. "Normal text" uses the current cell font. "Wingdings", "Webdings", and "Symbol" fonts contain large libraries of special icons and symbols. |
| Subset dropdown | Filter by character category: Basic Latin, Currency Symbols, Mathematical Operators, Greek and Coptic, Letterlike Symbols, Arrows, Dingbats, Emoticons, etc. |
| Character code | Shows the Unicode or ASCII code for the selected character. You can type a code directly to jump to that character. |
| Recently used symbols | The bottom of the dialog shows the last 16 symbols you inserted — click any to reinsert it quickly |
| Insert button | Inserts the selected symbol at the cursor position. Click Insert multiple times to insert the same symbol repeatedly. The dialog stays open so you can insert several symbols before closing. |
The Special Characters tab provides quick access to typographic characters with their keyboard shortcuts:
| Character | Name | Shortcut |
|---|---|---|
| — | Em Dash (long dash) | Alt+Ctrl+- (numpad) |
| – | En Dash (medium dash) | Ctrl+- (numpad) |
| … | Ellipsis | Alt+Ctrl+. |
| © | Copyright | Alt+Ctrl+C |
| ® | Registered Trademark | Alt+Ctrl+R |
| ™ | Trademark | Alt+Ctrl+T |
| Symbol | Name | Unicode | Practical Use in SA Offices |
|---|---|---|---|
| R | Rand symbol | R (uppercase R) | SA currency — type directly or use custom number format "R "#,##0.00 |
| © | Copyright | U+00A9 | Footer of proprietary reports: © 2025 Company Name |
| ™ | Trademark | U+2122 | Product names requiring TM notation |
| ® | Registered | U+00AE | Registered product or brand names |
| ° | Degree sign | U+00B0 | Temperature (25°C), angles (45°), coordinates |
| ± | Plus-minus | U+00B1 | Tolerances, margins of error, approximations |
| × | Multiplication sign | U+00D7 | Dimensions (210×297 mm), multiplication in text |
| ÷ | Division sign | U+00F7 | Mathematical notation in text explanations |
| ≠ | Not equal to | U+2260 | Technical and scientific notation |
| ≤ ≥ | Less/greater-than-or-equal | U+2264/5 | Criteria notation in documentation |
| ✓ | Checkmark / Tick | U+2713 | Checklists, confirmation, compliance trackers |
| ✗ | Cross / X mark | U+2717 | Checklists, non-compliance, negative results |
| → ← ↑ ↓ | Directional arrows | U+2192 etc. | Process flows, trend indicators, navigation labels |
| € £ ¥ | Euro, Pound, Yen | U+20AC/A3/A5 | Foreign currency columns in import/export reports |
| ² ³ | Superscript 2, 3 | U+00B2/B3 | Area measurements (m²), volume (m³), formulas |
| Method | How | Best For |
|---|---|---|
| Alt + numpad code | Hold Alt → type the numeric code on the numpad → release Alt. Works in any Windows application. | © = Alt+0169 • ® = Alt+0174 • ™ = Alt+0153 • ° = Alt+0176 • ± = Alt+0177 • × = Alt+0215 • ÷ = Alt+0247 |
| AutoCorrect shortcut | Excel (and Windows) AutoCorrects common sequences: type (c) → Enter to get ©; type (r) to get ®; type (tm) to get ™ |
Copyright, registered, and trademark symbols without the dialog |
| Copy from Character Map | Windows Start → type "Character Map" → browse and copy symbols → paste into Excel | Symbols not easily found in the Excel Symbol dialog |
| Unicode entry | Type the 4-digit Unicode hex code → press Alt+X. Converts the typed code to the character. (e.g., type 2713 → Alt+X → ✓) | Any Unicode character when you know the code — fastest method for frequent use |
Q1: You need every page of a printed report to show the company name on the left, "CONFIDENTIAL" centred, and "Page X of Y" on the right in the header. Write the exact content you would type into each of the three header zones.
✓ Left zone: type the company name directly, e.g., Skailit Learning Solutions (Pty) Ltd. Centre zone: type CONFIDENTIAL (optionally bold it with Ctrl+B, or use the Bold button while the text is selected). Right zone: type Page then click the Page Number button (inserts &[Page]) then type of then click the Number of Pages button (inserts &[Pages]) — the zone reads Page &[Page] of &[Pages] which prints as "Page 3 of 7" on page 3.
Q2: Your printed report is 6 pages long. The first page is a cover page and you do not want the header and footer to appear on it, but they should appear on pages 2 through 6. How do you set this up?
✓ Click inside the header area → Header & Footer tab → Options group → tick Different First Page. This creates two independent header/footer pairs: one for the first page and one for all other pages. Leave the "First Page Header" and "First Page Footer" zones completely empty (delete any content in them). Set up the regular header and footer content in the standard header/footer zones — these will appear on pages 2 through 6. The first page will have no header or footer.
Q3: You want to add your company logo to the left zone of the header so it prints on every page. The logo is a PNG file saved on your computer. What are the exact steps?
✓ View → Page Layout (to switch to Page Layout view) → click in the left zone of the header at the top of the page → Header & Footer tab → Header & Footer Elements group → click Picture → in the Insert Pictures dialog click This Device… → browse to the PNG logo file → click Insert. The code &[Picture] appears in the left zone. Click outside the header to see the logo preview. If the logo is too large, click back into the header zone → Header & Footer tab → click Format Picture → Size tab → adjust Height (tick "Lock aspect ratio") → OK → click outside to verify size.
Q4: You need to insert a degree symbol (°) and a plus-minus sign (±) into a cell that describes a temperature tolerance: "Operating range: 25°C ± 5°C". What are two different methods to insert these symbols?
✓ Method 1 (Alt codes): click in the cell → type "Operating range: 25" → hold Alt → type 0176 on the numpad → release Alt → the ° symbol appears. Type "C " → hold Alt → type 0177 → the ± symbol appears. Type " 5" → hold Alt → 0176 again for the second degree sign → type "C". Method 2 (Symbol dialog): Insert → Symbol → in the Symbol dialog set Subset to "Latin-1 Supplement" → find the degree sign (U+00B0) → click Insert → find plus-minus (U+00B1) → click Insert → Close. Both methods insert the actual Unicode characters that display and print correctly on any system.
Q5: You need to display the quadratic formula in a technical report spreadsheet. How do you insert it, and what is the fastest method?
✓ The fastest method is to use the built-in equation: Insert → Symbols group → Equation dropdown ▼ → in the gallery of built-in equations, click Quadratic Formula. Excel instantly inserts the perfectly formatted equation. The equation is a floating graphic object — click and drag to position it on the sheet. To customise it, double-click the equation to enter edit mode → modify the variables or coefficients using the Equation tab tools. Alternatively, use the linear format: Insert → Equation → New Equation → type x = (-b\pm\sqrt(b^2-4ac))/(2a) and Excel converts it to the formatted quadratic formula as you press Space after each component.
Q6: You have set up headers and footers on Sheet1 and want the same headers and footers on Sheet2, Sheet3, and Sheet4. What is the most efficient way to do this?
✓ Group the sheets before setting up the header/footer: click Sheet1 tab → hold Shift → click Sheet4 tab (this groups all four sheets, shown by [Group] in the title bar). Then set up the header and footer on Sheet1 while the sheets are grouped — the same header and footer settings apply to all four sheets simultaneously. Click any sheet outside the group (or right-click → Ungroup Sheets) when done. Verify by clicking each sheet tab and checking Print Preview (Ctrl+P) to confirm the header and footer appear on all four sheets.