ExamFinch.com My Study

Study guide

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

Practice this exam

Microsoft Excel Microsoft 365 Apps

Track your progress as you read

Finished sections get a check mark.

1 Introduction & Exam Overview

About the MO-210 Exam Performance-Based Exam Strategy

2 Import Data & Navigate Workbooks

Import Data from Text Files Import Data from Online Sources Search and Navigate to Named Cells, Ranges, Elements Insert and Remove Hyperlinks

3 Format Worksheets, Views & Collaboration

Page Setup, Headers, Footers, Row Height & Column Width Quick Access Toolbar, Views, Freeze Panes, Properties, Display Formulas Print Area, Export Formats, Print Settings, Inspect, Comments & Notes

4 Manipulate Data in Worksheets

Paste Special and Auto Fill Insert and Delete Rows, Columns, and Cells Generate Numeric Data with RANDBETWEEN and SEQUENCE

5 Format Cells and Ranges

Merge, Alignment, Orientation, Indentation, Wrap Text Number Formats, Format Painter, Format Cells Dialog Cell Styles, Clear Formatting, Group Worksheets

6 Named Ranges & Visual Summaries

Define and Reference Named Ranges Insert and Manage Sparklines Apply and Remove Conditional Formatting

7 Create and Format Tables

Create Excel Tables from Cell Ranges Apply Table Styles and Convert Tables to Ranges Add or Remove Table Rows and Columns

8 Table Options, Filter & Sort

Configure Table Style Options Insert and Configure Total Rows Filter Table Records Sort Data by Multiple Columns

9 Formula References

Relative, Absolute, and Mixed References Structured References in Tables

10 Calculate and Transform Data

SUM, AVERAGE, MIN, and MAX COUNT, COUNTA, and COUNTBLANK Conditional Operations with IF SORT and UNIQUE Functions

11 Format and Modify Text

LEFT, RIGHT, and MID UPPER, LOWER, LEN, CONCAT, and TEXTJOIN

12 Create Charts

Create Charts from Data Create Chart Sheets

13 Modify and Format Charts

Add Data Series and Switch Rows/Columns Add and Modify Chart Elements Chart Layouts, Styles, and Alternative Text

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

Key Takeaways Explain This Topic AI

Page Layout > Page Setup controls orientation, margins, paper size, and Scale to Fit (including Fit Sheet on One Page) for printable worksheets

Headers and footers are edited in Page Layout view or via Insert > Header & Footer; use Header & Footer Elements for page number, date, file name, and sheet name

AutoFit column width or row height by double-clicking the boundary between headers; set precise sizes with Home > Format > Column Width or Row Height

Print Titles (Page Layout > Print Titles) repeats selected rows at the top or columns at the left on every printed page

MO-210 tasks describe outcomes such as landscape with narrow margins or a centered footer page number — use the Page Setup dialog when multiple settings must match exactly

Last updated: August 2026

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:

  • Setting Typical ribbon path What MO-210 expects
  • Orientation Page Layout > Orientation Portrait (default) or Landscape
  • Margins Page Layout > Margins Normal, Wide, Narrow, or Custom Margins…
  • Paper size Page Layout > Size Letter, Legal, A4, and other installed sizes

Scaling Page Layout > Scale to Fit (Width / Height / Scale) Fit to 1 page wide, 1 page tall, or a percent scale

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:

View > Page Layout (or the Page Layout button on the status bar), then click Add header / Add footer regions (left, center, right).

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:

  • Element button Inserts Exam use
  • Page Number &[Page] "Page 3" style numbering
  • Number of Pages &[Pages] Often combined as Page X of Y
  • Current Date &[Date] Print date stamps
  • Current Time &[Time] Less common on Associate tasks
  • File Path &[Path] Full folder + file name
  • File Name &[File] Workbook name only
  • Sheet Name &[Tab] Active sheet tab name
  • Picture Embedded image Logos when specified

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.

Technique How When to use

AutoFit column width Double-click the right border of the column letter, or Home > Format > AutoFit Column Width Content is cut off with #### or truncated text

AutoFit row height Double-click the bottom border of the row number, or Home > Format > AutoFit Row Height Wrapped text or taller fonts need more vertical space

Precise column width Home > Format > Column Width… (character-width units) Prompt specifies an exact width such as 15

  • Precise row height Home > Format > Row Height… (point units) Prompt specifies height in points
  • Drag resize Drag the boundary between headers Approximate sizing when no number is given
  • Default width Home > Format > Default Width… Change the sheet's standard column width

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.

Go to Page Layout > Print Titles (opens Page Setup on the Sheet tab).

Click in Rows to repeat at top , then select the row(s) that contain column headings (for example, row 1 or rows 1:2).

Optionally set Columns to repeat at left for wide sheets that need row labels on each horizontal page.

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:

Page Layout > Orientation > Landscape; Margins > Narrow; set Scale to Fit Width and Height to 1 page (or Page Setup > Fit to 1 × 1).

Insert > Header & Footer → left header → File Name; center footer → Page Number.

Select A:F → Home > Format > AutoFit Column Width.

Page Layout > Print Titles → Rows to repeat at top = $1:$1 .

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.