You open a spreadsheet, do your work, hit print — and the output comes out on three pages when it should be one. Or the columns are cut in half. Or there's no header on the second page. That's usually a Page Layout problem, and everything you need to fix it is right here in this tab.
This guide covers every group and every visible button on the Page Layout tab, based on the actual Excel interface in the screenshot. Whether you're preparing a report for printing or just keeping your sheet organized visually, this tab has more to offer than most people realize.
Table of Contents
What Is the Page Layout Tab?
The Page Layout tab controls how your spreadsheet looks on a page — not inside a cell, but as a whole document. It's the bridge between your screen and the real world: printed reports, exported PDFs, and presentations that need to look polished rather than like a raw data dump.
From the screenshot, the tab is divided into five groups:
| # | Group | Quick Purpose |
|---|---|---|
| 1 | Themes | Global color, font, and effect styling for the workbook |
| 2 | Page Setup | Margins, orientation, size, print area, breaks, background, print titles |
| 3 | Scale to Fit | Width, height, and scale percentage for fitting content to printed pages |
| 4 | Sheet Options | Toggle gridlines and headings visibility for view and print |
| 5 | Arrange | Bring forward, send backward, selection pane, align, group, rotate objects |
1. Themes — Set the Visual Tone for the Whole Workbook
One click that changes everything at once.
The Themes group controls the overall visual design applied across your entire workbook — colors, fonts, and effects — as a coordinated package. When you apply a theme, it updates all charts, tables, shapes, and SmartArt to match consistently.
What's Inside
- Themes — a gallery of pre-built design packages; each theme combines a color palette, a font pairing (heading + body), and a set of shape effects; hover over any theme to preview it live before applying
- Colors — change only the color palette component of the current theme without affecting fonts or effects; useful when you like a theme's layout but need it to match your company's brand colors
- Fonts — change only the font pairing (heading font + body font) used across the workbook
- Effects — change only the visual effects applied to shapes and charts (shadow depth, glow intensity, bevel style, etc.)
Themes are most valuable when your workbook has multiple charts, tables, and shapes that all need to look consistent. Instead of formatting each object individually, applying a theme synchronizes everything in one action. If you're building a report that needs to match a company brand, set the Colors and Fonts to match first — then everything you insert afterward will automatically use those settings.
A theme doesn't lock your formatting. It sets the default palette and fonts. You can still override individual cells, charts, or objects manually — the theme just makes the defaults look intentional.
Themes Explained
2. Page Setup — The Core of Print Preparation
This is the group that determines whether your printout looks professional or chaotic.
The Page Setup group is the most feature-rich section of the Page Layout tab. It controls everything about how your content is arranged and bounded when it leaves the screen and goes to paper or PDF.
What's Inside
- Margins — sets the blank space between your content and the edge of the page; options include Normal, Wide, Narrow, and Custom Margins; narrow margins let you fit more columns on one page
- Orientation — Portrait (tall) or Landscape (wide); for wide tables with many columns, Landscape almost always works better
- Size — sets the paper size: A4, Letter, Legal, A3, and more; make sure this matches the paper actually loaded in your printer
- Print Area — defines exactly which cells will be included when you print; everything outside the print area is ignored; use this when your sheet has working data you don't want printed
- Breaks — manually inserts page breaks to control exactly where one printed page ends and the next begins; useful when you want a new section to always start at the top of a fresh page
- Background — tiles an image behind the entire sheet as a background texture or watermark effect; this is a display-only feature and does not appear when printing
- Print Titles — specifies which rows and/or columns should repeat at the top or left of every printed page; essential for multi-page tables where readers need the headers on every page
Print Titles — The One Everyone Forgets
If you have a table that spans three printed pages, the column headers only appear on the first page by default. Readers on page 2 and 3 have no idea what each column means. Print Titles solves this: go to Page Layout → Print Titles → set "Rows to repeat at top" to your header row. Now every printed page shows the headers automatically. This alone makes multi-page Excel reports dramatically more readable.
Dialog Launcher:
The small diagonal arrow at the bottom right of the Page Setup group opens the full Page Setup dialog — a single window with four tabs (Page, Margins, Header/Footer, Sheet) that gives you access to all settings in one place, including header/footer customization and print quality settings.
Shortcut: Alt+P+S+P — opens the Page Setup dialog directly.
3. Scale to Fit — Make It All Fit on the Page
Stop fighting with page breaks. Let Excel do the math.
The Scale to Fit group is the fastest solution to the most common printing frustration in Excel: content that spills over onto an extra page with just one or two columns. Instead of manually adjusting column widths or font sizes, Scale to Fit shrinks the content proportionally to fit your target page count.
What's Inside
- Width — sets how many pages wide the printout should be; set to "1 page" and Excel scales down the content horizontally until all columns fit on a single page width; currently shows "Automatic" in the screenshot
- Height — sets how many pages tall the printout should be; set to "1 page" to force all rows onto a single page vertically; currently shows "Automatic" in the screenshot
- Scale — manually set a percentage zoom for the printout; currently shows 100% in the screenshot; reducing this (e.g., to 85%) shrinks everything proportionally without specifying a page count
| Scenario | Best Setting |
|---|---|
| Table is one column too wide | Set Width to 1 page, leave Height on Automatic |
| Everything must fit on exactly one page | Set both Width and Height to 1 page |
| Want to slightly shrink without specifying pages | Set Scale to 85–90% |
| Long table, want controlled column count per page | Set Width to 1 page, let Height flow naturally |
Note:
Setting both Width and Height to "1 page" on a very large dataset will shrink the text to an unreadable size. Excel will comply with the instruction regardless of how small the result gets. Always check Print Preview after applying Scale to Fit settings.
4. Sheet Options — Control What's Visible and What Prints
The grid you see on screen doesn't have to be the grid that prints.
The Sheet Options group gives you independent control over two visual elements of the spreadsheet — gridlines and row/column headings — for two separate contexts: what you see on screen (View) and what appears on paper (Print).
What's Inside
- Gridlines — View (checked by default): shows or hides the light gray cell border lines across the entire sheet in normal view; unchecking this gives the sheet a cleaner, more document-like appearance
- Gridlines — Print (unchecked by default): when checked, the gray cell grid lines are included in the printed output; useful for tables that don't have manually applied borders but still need visible structure on paper
- Headings — View (checked by default): shows or hides the row numbers (1, 2, 3…) and column letters (A, B, C…) along the edges of the sheet
- Headings — Print (unchecked by default): when checked, the row numbers and column letters are printed alongside the content — helpful for debugging or technical reference printouts
The most common use case here is hiding gridlines for view only — when you're building a clean dashboard or a visually designed report, turning off the grid lines makes the sheet look much more like a finished document than a spreadsheet in progress. The actual cell borders you've manually applied with the Borders tool remain visible regardless of this setting.
5. Arrange — Control Objects Above the Grid
When you have charts, images, and shapes on a sheet, this group keeps them organized.
The Arrange group manages floating objects — anything that sits above the cell grid rather than inside it. Charts, images, shapes, text boxes, icons, and SmartArt all fall into this category. When you have multiple objects overlapping, this group controls their order, alignment, grouping, and rotation.
What's Inside
- Bring Forward — moves a selected object one layer forward in the stacking order; the dropdown arrow offers "Bring to Front" to instantly jump the object to the very top layer
- Send Backward — moves a selected object one layer back; the dropdown offers "Send to Back" to push it behind all other objects
- Selection Pane — opens a side panel listing every object on the current sheet by name; you can click any object in the list to select it, reorder layers by dragging, and hide/show individual objects with the eye icon
- Align — aligns two or more selected objects relative to each other or to the page; options include align left, center, right, top, middle, bottom, and distribute evenly
- Group — combines multiple selected objects into a single grouped unit; you can then move, resize, or format them all as one object; Ungroup separates them again
- Rotate — rotates or flips the selected object; options include 90° left, 90° right, flip horizontal, flip vertical, and free rotate
Selection Pane — The Hidden Gem
The Selection Pane is one of the most underappreciated tools in Excel. On a dashboard with a dozen charts, images, and shapes, clicking and selecting the right object can be frustrating — especially when they overlap. The Selection Pane lists every object by name in a sidebar, lets you click to select any of them, hide individual objects temporarily with the eye icon, and drag to reorder their stacking. Once you discover it, you'll wonder how you managed without it.
Key Relationships Between Page Layout Groups
| Pair | The Relationship |
|---|---|
| Print Area vs Scale to Fit | Print Area defines what content gets printed. Scale to Fit controls how big or small that content appears on the page. Use Print Area first to exclude unwanted content, then use Scale to Fit to make what remains fit cleanly. |
| Margins vs Scale to Fit | Narrow Margins and Scale to Fit both help squeeze content onto fewer pages, but in different ways. Narrow Margins reclaims white space at the edges. Scale to Fit shrinks the content itself. Use Margins first — only use Scale to Fit if Margins alone aren't enough. |
| Gridlines View vs Gridlines Print | These are independent toggles. You can hide gridlines on screen (cleaner view) while still printing them (for reference). Or show them on screen but suppress them in print (when you have manual borders). They don't affect each other. |
| Themes vs Manual Cell Formatting | Themes set the defaults — they affect charts, tables, and shapes. Manual cell formatting (bold, fill color, font) takes precedence over the theme for individual cells. The theme doesn't override formatting you've already applied; it only affects new objects and unformatted elements. |
| Breaks vs Scale to Fit | Page Breaks give you manual control over exactly where pages split. Scale to Fit automatically redistributes content across pages by resizing. Using both simultaneously can cause unexpected results — pick one approach and stick with it per sheet. |
Essential Shortcuts for the Page Layout Tab
| Shortcut | Action |
|---|---|
| Alt+P+M | Open Margins options |
| Alt+P+O | Toggle Orientation (Portrait/Landscape) |
| Alt+P+S+Z | Open Size options |
| Alt+P+R | Set Print Area |
| Alt+P+I | Insert Page Break |
| Alt+P+T | Open Print Titles dialog |
| Alt+P+A | Open Arrange → Align options |
| Ctrl+P | Print Preview (fastest way to check layout) |
10 Professional Tips for the Page Layout Tab
- Always check Print Preview before printing. Press Ctrl+P and look at the preview on the right side before sending anything to the printer. This catches cut-off columns, blank extra pages, and layout issues before they become wasted paper.
- Set Print Titles on every multi-page report. Go to Page Layout → Print Titles → set your header row to repeat at the top. Your readers on page 2 and beyond will thank you.
- Use Landscape orientation for wide tables. Any table with more than 6–8 columns almost always benefits from Landscape. It's the first thing to try when columns are getting cut off in print.
- Set Width to 1 page as a first fix for column overflow. Before adjusting column widths or font sizes, try Scale to Fit → Width → 1 page. It's the fastest solution when your table is just slightly too wide.
- Use Narrow Margins before scaling. Switching from Normal to Narrow margins recovers about 1.5 cm on each side — often enough to fit that extra column without shrinking text at all.
- Define a Print Area to exclude working data. If your sheet has helper columns, calculation areas, or reference tables you don't want printed, define the Print Area to include only the report section. Everything outside the area is ignored completely.
- Use the Selection Pane when objects overlap. If you can't click a chart or image because another object is on top of it, open the Selection Pane (Arrange group) and click the object's name directly in the list.
- Group charts and labels together before moving. Select the chart and its title text box, group them (Arrange → Group), then move the group as one unit. This keeps them from drifting apart accidentally.
- Save a custom theme for repeated use. If you've set up company-branded Colors and Fonts, save the theme via Themes → Save Current Theme. Apply it to any new workbook in seconds.
- Use Page Break Preview to see and adjust breaks visually. Go to View tab → Page Break Preview to see blue dashed lines showing exactly where pages split. You can drag those lines to reposition breaks interactively — much more intuitive than inserting breaks through the menu.
10 Mistakes Beginners Make with the Page Layout Tab
- Printing without checking Print Preview. The screen view and the print output are not the same. Always Ctrl+P and verify the preview before printing anything intended for someone else.
- Setting both Width and Height to 1 page on a large dataset. Excel will squeeze 500 rows onto a single page if you tell it to — making the text microscopically small. Set Width to 1 page and leave Height on Automatic for most cases.
- Thinking the Background image will print. The Page Layout → Background feature is display-only. It never prints. If you need a printed watermark, it must go in the Header/Footer.
- Forgetting to set Print Titles on long reports. Without this, only the first page has column headers. Every subsequent page is a mystery for the reader. Always set this on any table that spans more than one printed page.
- Confusing gridlines with cell borders. Hiding Gridlines (View) in Sheet Options only hides the display guides — it doesn't remove any cell borders you've manually applied. Borders are formatting; gridlines are a visual aid. They're independent.
- Applying Scale to Fit without checking the result. After setting Scale to Fit, always open Print Preview. Excel may have shrunk the text to a size that's technically one page but completely unreadable in practice.
- Forgetting to clear the Print Area after it's no longer needed. Once a Print Area is set, it persists. If you add new columns or rows outside the defined area later, they won't print — and you might not notice. Always check Page Layout → Print Area when something is missing from a printout.
- Manually sizing and aligning charts instead of using Align tools. Dragging charts by hand never produces perfectly aligned results. Select all charts, use Arrange → Align → Align Top, then Distribute Horizontally for a clean dashboard layout in seconds.
- Applying a Theme and expecting all existing formatting to update. Themes update unformatted elements and new objects. Cells you've already formatted manually keep their manual formatting. If you want the Theme to apply everywhere, you'd need to clear existing formats first.
- Inserting manual Page Breaks while also using Scale to Fit. These two features can conflict — Scale to Fit recalculates page divisions automatically, which can override or shift your manual breaks. Use one approach consistently; don't mix them on the same sheet.
Frequently Asked Questions
Why does my spreadsheet print on multiple pages when I only want one?
The fastest fix is Scale to Fit. Go to Page Layout → Scale to Fit → set Width to 1 page. If you also want all rows on one page, set Height to 1 page as well — but be aware this may make text very small on large datasets. A better approach for wide tables is to also try switching Orientation to Landscape (Page Setup → Orientation) and reducing Margins to Narrow before using Scale to Fit. These three steps in combination usually solve the problem without shrinking text too aggressively.
How do I make column headers repeat on every printed page?
Go to Page Layout → Print Titles. In the Page Setup dialog that opens, click in the field labeled "Rows to repeat at top" and then click the row number of your header row on the sheet (or type it manually, e.g., $1:$1 for row 1). Click OK. Now every printed page will show that row at the top. You can do the same for columns using "Columns to repeat at left" — useful when the first column contains row labels that need to be visible on wide tables that span multiple pages horizontally.
Why is my background image not showing up when I print?
This is by design — the Background feature in Page Layout is a screen display effect only and explicitly does not print. Microsoft built it this way intentionally. If you need something to appear on every printed page — a watermark, a company logo, a "CONFIDENTIAL" stamp — the correct place to add it is the Header or Footer. Go to Insert → Header & Footer, and in the header or footer zone you can insert an image that will appear on every printed page.
What's the difference between hiding gridlines in Sheet Options vs changing cell borders?
They are completely separate. Gridlines (Sheet Options) are the light gray guide lines Excel draws between every cell as a visual aid — they're not real formatting and don't print unless you check Gridlines → Print. Cell Borders (Home tab → Font group → Borders) are actual formatting applied to specific cells — they always print and are always visible regardless of the Gridlines setting. Turning off gridlines makes the sheet look cleaner on screen, but any borders you've manually added remain fully visible and print normally.
My print area is set but some data I added later isn't printing. Why?
When a Print Area is defined, Excel prints only what's inside that defined range — nothing outside it. If you added rows or columns outside the original Print Area boundary, they're excluded automatically. To fix it: go to Page Layout → Print Area → Clear Print Area, then reselect the full range you want to include and go to Page Layout → Print Area → Set Print Area again. Alternatively, you can extend the existing Print Area by selecting the new range, then choosing Page Layout → Print Area → Add to Print Area.
How do I remove a page break I accidentally inserted?
Click on the cell directly below a horizontal page break (or directly to the right of a vertical one), then go to Page Layout → Breaks → Remove Page Break. To remove all manual page breaks on a sheet at once, go to Page Layout → Breaks → Reset All Page Breaks. The easiest way to manage breaks visually is to switch to Page Break Preview (View tab → Page Break Preview) — you can see all breaks as blue dashed lines and drag them to new positions, or right-click a break line to remove it.
Why is the Scale percentage grayed out when I set Width or Height?
Width/Height and Scale are mutually exclusive settings — you can use one or the other, but not both at the same time. When you set Width or Height to a specific page count, Excel calculates the scale percentage automatically and locks the manual Scale field. If you want to use the manual Scale percentage instead, set both Width and Height back to "Automatic." This releases the Scale field so you can type in your own percentage.
How do I align multiple charts so they're perfectly lined up?
Hold Ctrl and click each chart to select multiple objects at once. Then go to Page Layout → Arrange → Align and choose your alignment option — Align Top makes all chart tops flush with the highest one, Distribute Horizontally spaces them evenly from left to right. For a dashboard grid layout, Align Top + Distribute Horizontally on one row, then repeat for the second row, produces clean results in seconds. Much faster and more precise than dragging by hand.
What does grouping objects actually do and when is it useful?
Grouping combines multiple selected objects — charts, images, shapes, text boxes — into a single unit with shared resize handles. Once grouped, moving, resizing, or applying an effect to the group affects all objects inside it together while preserving their relative positions and proportions. It's most useful when you've built a composite element (like a chart with a custom legend text box, or a logo with a label) that you want to treat as one piece. Select all the objects you want to group, then go to Arrange → Group → Group. To edit individual objects inside the group, double-click the group first to enter it.
Can I use a different paper size for different sheets in the same workbook?
Yes — paper size (and all Page Setup settings) are set per sheet, not per workbook. Each sheet maintains its own independent Page Setup configuration. To set different paper sizes: click the first sheet tab, go to Page Layout → Size and select your size. Then click the second sheet tab and repeat with a different size. The settings don't carry over between sheets unless you right-click and select multiple sheet tabs before making the change — in which case the setting applies to all selected sheets simultaneously.
Now You're Ready to Print With Confidence
The Page Layout tab isn't just for printing — but printing is where it really proves its worth. A report that lands on someone's desk looking clean, structured, and easy to read is the result of someone who took five minutes in this tab before hitting print.
Now that you know what every group does — from Themes that set the visual foundation, to Scale to Fit that resolves the most common print frustrations, to the Arrange tools that keep dashboards looking polished — you have everything you need to produce output that looks intentional, not accidental.
The goal of Page Layout isn't to make your spreadsheet look fancy. It's to make sure what you built translates cleanly to the format your reader actually sees.
Excel Page Layout Tab — Fully Explored
