Page Setup, Headers, Footers, Row Height & Column Width

Page Setup, Headers, Footers, Row Height & Column Width

Quick Answer: On MO-210, formatting worksheets for print means configuring Page Layout settings (orientation, margins, paper, scaling), building headers/footers with page numbers or file metadata, sizing rows and columns with AutoFit or exact values, and optionally setting Print Titles so heading rows repeat.

Certiport's MO-210 Objective Domain groups these under Format worksheets and workbooks. Tasks are performance-based: you receive a workbook and a short instruction such as "Change the worksheet to landscape orientation with 0.5" margins and fit the columns to one page wide." Ribbon paths matter more than memorizing dialog names, but the Page Setup dialog is the fastest way to apply several print settings at once.

Why Page Setup Matters on the Exam

Excel Associate candidates are expected to produce worksheets that print cleanly for managers and clients. A correct formula sheet that spills across three landscape pages with cut-off headers fails the business outcome even if the data is right. Practice reading the full prompt: orientation, margins, scaling, and header text are often combined in one task.

Orientation, Margins, Paper Size, and Scaling

Open the Page Layout tab. The Page Setup group exposes the controls you use most:

Click the Page Setup dialog launcher (small arrow at the bottom-right of the Page Setup group) when a task lists several requirements together. The Page tab holds orientation, scaling (Fit to: n page(s) wide by m tall, or Adjust to: percent), and paper size. The Margins tab sets Top/Bottom/Left/Right and optional Center on page horizontally or vertically. The Sheet tab includes print options covered later (print area, print titles, gridlines).

Scaling traps

• Fit Sheet on One Page (Margins gallery or Scale to Fit both Width and Height set to 1) shrinks everything — including charts — onto a single sheet. Use it only when the prompt asks to fit the entire sheet on one page.
• Setting Width to 1 page and Height to Automatic keeps columns on one page while allowing additional vertical pages — a common real-world and exam pattern for wide tables.
• Manual Scale percentages override Fit to settings; if scaling looks wrong, reopen Page Setup and confirm which option is active.

Headers and Footers

Headers and footers appear in the top and bottom margin areas of each printed page. Two reliable entry points:

1. View > Page Layout (or the Page Layout button on the status bar), then click Add header / Add footer regions (left, center, right).
2. Insert > Text > Header & Footer, which switches to Page Layout view and activates the Header & Footer contextual tab.

On the Header & Footer tab, Header & Footer Elements insert fields rather than static typed text:

You can type custom text beside fields — for example, Confidential — Page &[Page] of &[Pages] in the center footer. Use Go to Header / Go to Footer to move between regions. Different First Page and Different Odd & Even Pages exist for advanced layouts; Associate prompts usually ask for the same header/footer on all pages.

Return to Normal view when finished editing so you can work with cells again. Header content is easiest to verify in Page Layout view or File > Print preview.

Row Height and Column Width

Readable printouts depend on sensible column widths and row heights — especially after importing text or widening wrapped labels.

Select multiple columns or rows before AutoFit or Format commands to resize them together. Hide / Unhide are related Format commands but belong more to structure tasks; for this objective, focus on visible sizing so printed data is complete.

Performance-task tip

If a column shows #### after you apply a number format, AutoFit the column — the exam often expects you to notice truncated displays, not only follow an explicit "AutoFit column B" instruction.

Print Titles (Repeating Rows and Columns)

Print Titles keep identifying labels visible on every printed page of a long list.

1. Go to Page Layout > Print Titles (opens Page Setup on the Sheet tab).
2. Click in Rows to repeat at top, then select the row(s) that contain column headings (for example, row 1 or rows 1:2).
3. Optionally set Columns to repeat at left for wide sheets that need row labels on each horizontal page.
4. Confirm with Print Preview — titles appear on pages 2+ as well as page 1.

Print Titles are not the same as Freeze Panes. Freeze Panes affect on-screen scrolling; Print Titles affect printed/PDF output. MO-210 may test either skill in Domain 1, so match the wording: "repeat row 1 on each printed page" → Print Titles; "keep row 1 visible while scrolling" → Freeze Panes (next section).

Exam Scenario Walkthrough

Prompt: Configure the Sales sheet for printing in landscape orientation, narrow margins, scaled to 1 page wide by 1 page tall. Add the file name in the left header and the page number in the center footer. AutoFit columns A:F. Set row 1 as rows to repeat at top.

Suggested path:

1. Page Layout > Orientation > Landscape; Margins > Narrow; set Scale to Fit Width and Height to 1 page (or Page Setup > Fit to 1 × 1).
2. Insert > Header & Footer → left header → File Name; center footer → Page Number.
3. Select A:F → Home > Format > AutoFit Column Width.
4. Page Layout > Print Titles → Rows to repeat at top = $1:$1.
5. File > Print to verify one landscape page with repeating header row, file name, and page number.

Mastering these paths covers the "modify page setup," "customize headers and footers," and "adjust row height and column width" bullets on the MO-210 outline — and Print Titles when the prompt asks for repeating printed labels.