🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Business & Cross-Cutting › Bookkeeping / Office Administration › Excel for Bookkeeping and Office Administration › Lesson 9
BUS-BOOK55-05 · Lesson 9 · 10 clock hours · demo

Professional Report Formatting and Print-Ready Output

Objective. Students format a multi-sheet Excel workbook to produce print-ready financial reports with consistent fonts, colors, headers, footers, page breaks, and print areas that meet standard bookkeeping documentation presentation requirements.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a credentialed professional in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Why Print-Ready Formatting Matters in Bookkeeping

A financial report is only as useful as its readability. When you hand a printed Income Statement or Accounts Receivable Aging report to a manager, lender, or auditor, every page must look intentional and professional. Sloppy formatting—tables split across pages, inconsistent fonts, missing headers—signals careless work and can undermine trust in the numbers themselves. In this lesson you will learn to format a multi-sheet Excel workbook so that every worksheet prints cleanly, carries identifying information on every page, and presents data in a consistent, professional style.

Page Layout View vs. Normal View

Excel offers three views accessible from the View tab: Normal, Page Layout, and Page Break Preview.

Always switch to Page Layout view or Print Preview before finalizing any report. What you see on screen in Normal view can differ significantly from the printed page.

Setting Print Areas

A print area tells Excel exactly which cells to include when you print. Without a print area, Excel prints all cells that contain data, which may include scratch calculations or notes you never intended to share.

To set a print area: select the cell range you want to print, go to Page Layout → Print Area → Set Print Area. A dashed border appears around the selection. Each worksheet in a workbook can have its own independent print area. For a three-sheet workbook such as the one in this lesson (Income Summary, Expense Detail, AR Aging), you must set the print area on each sheet separately unless you group the sheets first and the ranges are identical.

Manual Page Breaks

Excel inserts automatic page breaks based on paper size and margin settings. These automatic breaks do not respect the logic of your data—a table of transactions can be sliced in the middle of a section. Manual page breaks let you control exactly where one page ends and the next begins.

To insert a horizontal page break: click the row header of the row that should begin the new page, then go to Page Layout → Breaks → Insert Page Break. A solid line appears above that row. To remove a manual break, click the row below it and choose Remove Page Break. Always verify in Page Break Preview or Print Preview that no table or subtotal block is split between pages.

Headers and Footers

A professional financial document includes identifying information on every page. Excel's built-in header and footer tool (found in Page Layout view by clicking the header or footer zone, or via Insert → Header & Footer) lets you place text or codes in three zones: left, center, and right.

Standard bookkeeping practice:

Grouping Sheets for Simultaneous Formatting

To apply identical headers and footers to all sheets at once, group the sheets: right-click any sheet tab and choose Select All Sheets, or click the first tab, then Shift-click the last. The title bar shows "[Group]". Any header or footer you set now applies to every sheet in the group. When finished, right-click a tab and choose Ungroup Sheets, then verify each sheet individually to confirm the settings carried through.

Important: While sheets are grouped, edits to cell content apply to all sheets simultaneously. Ungroup immediately after finishing the shared task to avoid accidental overwriting of data.

Consistent Theme, Fonts, and Cell Styles

A theme in Excel is a coordinated set of fonts and colors that applies across the workbook. For financial documents, choose a conservative built-in theme (such as Office, Facet, or Ion Boardroom) with muted accent colors. Avoid bright or saturated colors; they are distracting on paper and unprofessional in a business context.

Cell Styles (found on the Home tab) provide pre-built formatting for specific roles:

Applying cell styles rather than manual bold-and-color choices keeps formatting consistent when you later change the theme, because styles update automatically.

Print Settings to Verify Before Finalizing

Before submitting a formatted workbook, confirm these settings for each sheet:

1. Paper size: Letter (8.5 × 11 in.) for US business documents

2. Orientation: Portrait for most reports; Landscape only if column count requires it

3. Margins: Normal or Narrow; be consistent across all sheets

4. Scale: "Fit Sheet on One Page" or a percentage—do not let Excel shrink text below readable size (no smaller than about 85%)

5. Gridlines and row/column headings: Typically turned off for printed reports (Page Layout → Sheet Options)

6. Print titles: If a table spans multiple pages, set Print Titles (Page Layout → Print Titles) to repeat the column header row on every page

Workplace Safety Note

Office work involves prolonged computer use. Follow ergonomic best practices: position the monitor at eye level, keep wrists neutral while keyboarding, and take short breaks to reduce eye strain and repetitive-stress risk. When loading paper or clearing printer jams, keep fingers away from moving rollers and follow the printer manufacturer's jam-clearing instructions to avoid burns from the fuser unit, which operates at high temperature.

Key terms8

Print AreaA defined range of cells on a worksheet that Excel prints when you send the sheet to a printer; cells outside the print area are excluded from output.
Page Layout ViewAn Excel view that displays the worksheet as it will appear on a printed page, including header and footer zones, margins, and page boundaries.
Manual Page BreakA page break inserted by the user to control exactly where one printed page ends and the next begins, overriding Excel's automatic break placement.
Header / FooterText or automatic codes placed in the top (header) or bottom (footer) margin of every printed page, typically containing the company name, report title, date, and page number.
Group SheetsA technique that links multiple worksheet tabs so that formatting changes — such as headers, footers, or print settings — apply to all grouped sheets simultaneously.
Cell StyleA named collection of formatting attributes (font, size, color, border, number format) applied to a cell or range to ensure consistent appearance across a workbook.
Print TitlesA Page Layout setting that repeats specified rows or columns (such as column headers) at the top or left of every printed page when a table spans multiple pages.
ThemeA coordinated set of fonts, colors, and effects in Excel that can be applied to an entire workbook to maintain a consistent, professional visual style.
In class: Instructor demonstrates Page Layout view versus Normal view, manual page breaks, and the print-area setting; students then set print areas on each of three worksheets (Income Summary, Expense Detail, AR Aging), insert manual page breaks so no table splits across pages, and preview each sheet in print preview before printing. · Students add a standardized header (company name left, report title center, date right using the &[Date] code) and footer (page number center using &[Page] of &[Pages]) to all sheets simultaneously using the Group Sheets technique, then ungroup and verify each sheet independently. · Students apply a consistent theme (font, accent colors appropriate for a professional financial document — no bright or distracting colors), use cell styles for headings and totals rows, and submit the final workbook to the instructor's shared folder; a peer uses a provided formatting checklist to score the submission before the instructor reviews it.
Materials: Excel, three-sheet financial workbook file, print-formatting checklist, access to a printer or PDF printer
Check: Peer and instructor formatting checklist: all 10 checklist items marked as meeting standard (header/footer on all sheets, print areas set, no table splitting, consistent theme, total row styled) — pass = 9/10 items correct.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

Microsoft Office Specialist — Excel: formatting and print settings
1. A bookkeeper wants to print only cells A1:F45 on the Expense Detail worksheet, excluding a scratch area in columns H–J. Which sequence of steps accomplishes this?
Microsoft Office Specialist — Excel: formatting and print settings
2. Which Excel view allows you to drag page break lines to reposition them and shows automatic breaks as dashed blue lines?
Microsoft Office Specialist — Excel: formatting and print settings
3. A student wants the footer of every sheet in a workbook to display 'Page 2 of 5' (updating automatically). Which footer code produces this result?
Microsoft Office Specialist — Excel: workbook management
4. An office administrator groups all three worksheet tabs to add a standardized header. After finishing, she forgets to ungroup the sheets and then edits cell B10 on the Income Summary sheet. What is the most likely unintended consequence?
AIPB Certified Bookkeeper — bookkeeping documentation standards
5. According to standard bookkeeping presentation practice, which of the following header arrangements is most appropriate for a printed financial report?
Microsoft Office Specialist — Excel: formatting and print settings
6. A bookkeeper notices that her AR Aging table is split so that the last three rows of one vendor's section print on a new page, separated from the section heading. Which action corrects this without changing data?
Microsoft Office Specialist — Excel: formatting and print settings
7. Which Excel feature should a bookkeeper use to ensure that the column labels ('Date', 'Description', 'Amount', 'Balance') repeat at the top of every printed page when an AR Aging report spans three pages?
AIPB Certified Bookkeeper — bookkeeping documentation standards
8. A peer reviewer is scoring a classmate's formatted workbook using the class checklist. The workbook has correct headers, footers, and print areas on all three sheets, but the totals rows on the Income Summary and AR Aging sheets use bright green fill and bold red text, while the Expense Detail sheet uses the built-in 'Total' cell style. The theme is set to 'Office.' How should the reviewer score the 'consistent theme and cell styles' checklist item?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →